Available Courses

// Wait for the DOM to load before executing document.addEventListener('DOMContentLoaded', function() { const sheetURL = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vToGfCw45vQhldhdLcf7dMmBDEHKOi-sqWxyWLaJbwi7VYLcjVjyQkMquO7N_QYUJAWFiaDw67b5BZ7/pubhtml'; // Fetch data from the Google Sheets public JSON feed fetch(sheetURL) .then(response => { if (!response.ok) { throw new Error('Network response was not ok'); } return response.json(); }) .then(data => { const courses = data.feed.entry; // Get the course list container const listContainer = document.getElementById('courses'); listContainer.innerHTML = ''; // Clear any previous content // Loop through each course and create a list item courses.forEach(course => { const listItem = document.createElement('li'); listItem.innerHTML = ` Course Name: ${course['gsx$coursename'].$t}
Grade Band: ${course['gsx$gradeband'].$t}
Subject: ${course['gsx$subject'].$t}
Description: ${course['gsx$description'].$t} `; listContainer.appendChild(listItem); }); }) .catch(error => { console.error('Error loading data:', error); }); });