// ------------------ START COMMUNITY RESOURCES FROM SPREADSHEET ------------------ document.addEventListener("appLoaded", () => { UtilityHelpers.waitForElement("#app", "#community-resources", (element) => { const getInfo = new GetInfo(); const currentLanguage = (getInfo.orgTranslation || "en").toLowerCase(); // IMPORTANT NOTE: the translated languages (and name of the filters) are part of the AppScript (Google Spreadsheet -> Extensions) const TRANSLATIONS = { en: { resourseWebpage: "Website", category: "Category", moreInfo: "More Info", }, es: { resourseWebpage: "Sitio web", category: "Categoría", moreInfo: "Más detalles", }, }; const t = (key) => (TRANSLATIONS[currentLanguage] && TRANSLATIONS[currentLanguage][key]) || TRANSLATIONS.en[key]; // (Optional) RTL languages, if you want to add dir="rtl" on the buttons/links const RTL_LANGS = new Set(["ar", "ur"]); const maybeDir = RTL_LANGS.has(currentLanguage) ? ' dir="rtl"' : ""; const itemTemplate = `

${t("category")}: {{ Category }}

${t("resourseWebpage")}

${t("moreInfo")}

`; const BASE_URL = "https://script.google.com/macros/s/AKfycbz0USuGgO5gFq9YNZFH4Kuuvyiw7dcap44ufklpbX4ViqCR_Tr-SJMTosuHrSZogNMI/exec"; const fetchDataUrl = BASE_URL + (BASE_URL.includes("?") ? "&" : "?") + "lang=" + encodeURIComponent(currentLanguage); const fallbackFetchDataUrl = BASE_URL; // 2 sheets should exist; one with the main data, the other one with the filters const communityResourcesConfig = { jsonDataKeys: { mainFileKey: "programs", // Default key for the main file (ex: courses) data filtersKey: "filters", // Default key for filters data }, fetchDataUrl, fallbackFetchDataUrl, translateFailureRetries: 2, addLoadedClassTo: document.getElementById("community-resources"), // when the content is loaded, a css class is added in order to hide the loader searchElement: document.getElementById("search-input"), // commejnt to disable search; also remove from HTML searchAsYouType: true, resetAllFiltersElement: ".js-reset-all-filters", // comment if the reset functionality is not needed; also remove from HTML sortButtonElement: ".js-sort-button", // comment if sort functionality is not needed; also remove from HTML itemsPerPageElement: ".js-items-per-page", // select how many items per page are shown; comment if not neeeded // also remove from HTML infoAreaElement: ".js-info-area", // search info: Showing X to Y of TOTAL entries; comment if not needed; also remove from HTML mainListArea: document.getElementById("main-list"), // this is where the results will be listed; required mainApp: document.getElementById("community-resources"), // this is the main app ID; required itemsPerPageDefaultValue: 96, scrollToAppOnFilter: true, // scrolls to mainApp on filter isTranslateable: true, currentLanguage: currentLanguage, translationFeedbackElement: "#feedback-area", preferServerFilterTitles: true, itemTemplate, // modalConfig - builds the modal - you have to match a column name from thee spreadsheet with a CSS selector inside the modal modalConfig: { enabled: true, triggerSelector: ".custom-button--2", modalWrapperClass: "spreadsheet-item-modal", // generic naming fields: [ { data: "resource-name", target: ".modal-resource-name", type: "text", }, { data: "resource-description", target: ".modal-resource-description", type: "html", }, { data: "resource-webpage", target: ".modal-resource-webpage", type: "link", }, { data: "resource-category", target: ".modal-resource-category", type: "text", }, { data: "resource-city", target: ".modal-resource-city", type: "text", }, { data: "resource-address", target: ".modal-resource-address", type: "text", }, { data: "resource-email", target: ".modal-resource-email", type: "mailto", }, { data: "resource-phone", target: ".modal-resource-phone", type: "text", }, { data: "resource-phone2", target: ".modal-resource-phone2", type: "text", }, { data: "resource-phone3", target: ".modal-resource-phone3", type: "text", }, ], }, searchInColumns: ["Agency Name"], // if search is enabled, this is required sortingCriteria: "Agency Name", // if sortButtonElement is enabled, this is required; ONLY ONE enablePagination: true, // Set to false to disable pagination; option to create your own #pagination-area anywhere in the page //filterLogicBetweenGroups: "OR", // or AND checkboxFilters: { ihe: { filterTitle: "City", filterLabel: "City", filterId: "City-ID", listedColumn: "City-ID", parentIdInPage: "custom-spreadsheet-app-filter-area", extraClass: "city-filters js-is-collapsable is-collapsed", filterLogic: "OR", }, certification: { filterTitle: "Category", filterLabel: "Category", filterId: "Category-ID", listedColumn: "Category-ID", parentIdInPage: "custom-spreadsheet-app-filter-area", extraClass: "category-filters js-is-collapsable is-collapsed", filterLogic: "OR", }, }, }; const communityResources = new CourseCatalog(communityResourcesConfig); }); }); // ------------------ END COMMUNITY RESOURCES FROM SPREADSHEET ------------------ // ------------------ START Library Book Removals FROM SPREADSHEET ------------------ document.addEventListener("appLoaded", () => { UtilityHelpers.waitForElement( "#app", "#library-book-removals", (element) => { const getInfo = new GetInfo(); const currentLanguage = ( getInfo.orgTranslation || "en" ).toLowerCase(); // IMPORTANT NOTE: the translated languages (and name of the filters) are part of the AppScript (Google Spreadsheet -> Extensions) const TRANSLATIONS = { en: { bookTitle: "Book Title", author: "Author", periodRemoved: "Period Removed", campusLevelBefore: "Campus Level Available Prior to Review", campusLevelAfter: "Campus Level Available After Review", evaluationProcess: "Evaluation Process", reasonforremoval: "Reason for Removal", moreInfo: "More Info", }, es: { bookTitle: "Título del libro", author: "Autor", periodRemoved: "Período de retiro", campusLevelBefore: "Nivel escolar disponible antes de la revisión", campusLevelAfter: "Nivel escolar disponible después de la revisión", evaluationProcess: "Proceso de evaluación", reasonforremoval: "Motivo de retiro", moreInfo: "Más detalles", }, }; const t = (key) => (TRANSLATIONS[currentLanguage] && TRANSLATIONS[currentLanguage][key]) || TRANSLATIONS.en[key]; // (Optional) RTL languages, if you want to add dir="rtl" on the buttons/links const RTL_LANGS = new Set(["ar", "ur"]); const maybeDir = RTL_LANGS.has(currentLanguage) ? ' dir="rtl"' : ""; const itemTemplate = `

${t("author")}: {{ Author }}

${t("evaluationProcess")}: {{ Evaluation Process }}

${t("campusLevelAfter")}: {{ Campus Level Available After Review }}

${t("reasonforremoval")}: {{ Reason for Removal }}

${t("moreInfo")}

`; const BASE_URL = "https://script.google.com/macros/s/AKfycbwEm502k1YmZeFDmmTwg9oAmHhmM83HKhXnyxR-qPp1KnB2Xbgz9WOprEkK5MKF_HReUQ/exec"; const fetchDataUrl = BASE_URL + (BASE_URL.includes("?") ? "&" : "?") + "lang=" + encodeURIComponent(currentLanguage); const fallbackFetchDataUrl = BASE_URL; // 2 sheets should exist; one with the main data, the other one with the filters const communityBooksConfig = { jsonDataKeys: { mainFileKey: "programs", // Default key for the main file (ex: courses) data filtersKey: "filters", // Default key for filters data }, fetchDataUrl, fallbackFetchDataUrl, translateFailureRetries: 2, addLoadedClassTo: document.getElementById( "library-book-removals", ), // when the content is loaded, a css class is added in order to hide the loader searchElement: document.getElementById("search-input"), // commejnt to disable search; also remove from HTML searchAsYouType: true, resetAllFiltersElement: ".js-reset-all-filters", // comment if the reset functionality is not needed; also remove from HTML sortButtonElement: ".js-sort-button", // comment if sort functionality is not needed; also remove from HTML itemsPerPageElement: ".js-items-per-page", // select how many items per page are shown; comment if not neeeded // also remove from HTML infoAreaElement: ".js-info-area", // search info: Showing X to Y of TOTAL entries; comment if not needed; also remove from HTML mainListArea: document.getElementById("main-list"), // this is where the results will be listed; required mainApp: document.getElementById("library-book-removals"), // this is the main app ID; required itemsPerPageDefaultValue: 96, scrollToAppOnFilter: true, // scrolls to mainApp on filter isTranslateable: true, currentLanguage: currentLanguage, translationFeedbackElement: "#feedback-area", preferServerFilterTitles: true, itemTemplate, // modalConfig - builds the modal - you have to match a column name from thee spreadsheet with a CSS selector inside the modal modalConfig: { enabled: true, triggerSelector: ".custom-button--2", modalWrapperClass: "spreadsheet-item-modal", // generic naming fields: [ { data: "book-name", target: ".modal-book-name", type: "text", }, { data: "book-author", target: ".modal-book-author", type: "text", }, { data: "book-evaluation", target: ".modal-book-evaluation", type: "text", }, { data: "book-levelafterreview", target: ".modal-book-levelafterreview", type: "text", }, { data: "book-reasonforremoval", target: ".modal-book-reasonforremoval", type: "text", }, { data: "book-schoolyear", target: ".modal-book-schoolyear", type: "mailto", }, { data: "book-levelbeforereview", target: ".modal-book-levelbeforereview", type: "text", }, ], }, searchInColumns: ["Title", "Author"], // if search is enabled, this is required sortingCriteria: "Title", // if sortButtonElement is enabled, this is required; ONLY ONE enablePagination: true, // Set to false to disable pagination; option to create your own #pagination-area anywhere in the page //filterLogicBetweenGroups: "OR", // or AND checkboxFilters: { evaluationProcess: { filterTitle: "Evaluation Process", filterLabel: "Evaluation Process", filterId: "Evaluation Process ID", listedColumn: "Evaluation Process ID", parentIdInPage: "custom-spreadsheet-app-filter-area", extraClass: "evaluation-flters js-is-collapsable is-collapsed", filterLogic: "OR", }, campusLevelPriorReview: { filterTitle: "Campus Level Available After Review", filterLabel: "Campus Level Available After Review", filterId: "Campus Level Available After Review ID", listedColumn: "Campus Level Available After Review ID", parentIdInPage: "custom-spreadsheet-app-filter-area", extraClass: "level-prior-tor-review js-is-collapsable is-collapsed", filterLogic: "OR", }, reasonforremoval: { filterTitle: "Reason for Removal", filterLabel: "Reason for Removal", filterId: "Reason for Removal ID", listedColumn: "Reason for Removal ID", parentIdInPage: "custom-spreadsheet-app-filter-area", extraClass: "reason-for-removal js-is-collapsable is-collapsed", filterLogic: "OR", }, }, }; const communityBooks = new CourseCatalog(communityBooksConfig); }, ); }); // ------------------ END Library Book Removals FROM SPREADSHEET ------------------ // ------------------ START Course Catalog FROM SPREADSHEET ------------------ document.addEventListener("appLoaded", () => { UtilityHelpers.waitForElement("#app", "#course-catalog", (element) => { const getInfo = new GetInfo(); const currentLanguage = (getInfo.orgTranslation || "en").toLowerCase(); // IMPORTANT NOTE: the translated languages (and name of the filters) are part of the AppScript (Google Spreadsheet -> Extensions) const TRANSLATIONS = { en: { courseCode: "Course Code", courseDescription: "Course Description", department: "Department", prerequisite: "Prerequisite", eligiblegrades: "Eligible Grades", grades: "Grades", graduationRequirement: "Graduation Requirement", credit: "Credit(s)", videourl: "Video", moreInfo: "More Info", }, es: { courseCode: "Código del curso", courseDescription: "Descripción del curso", department: "Departamento", prerequisite: "Requisito previo", eligiblegrades: "Grados elegibles", grades: "Grados", graduationRequirement: "Requisito de graduación", credit: "Créditos", videourl: "Video", moreInfo: "Más información", }, }; const t = (key) => (TRANSLATIONS[currentLanguage] && TRANSLATIONS[currentLanguage][key]) || TRANSLATIONS.en[key]; // (Optional) RTL languages, if you want to add dir="rtl" on the buttons/links const RTL_LANGS = new Set(["ar", "ur"]); const maybeDir = RTL_LANGS.has(currentLanguage) ? ' dir="rtl"' : ""; const itemTemplate = `

${t("courseCode")}: {{ courseCode }}

${t("prerequisite")}: yes no

${t("credit")}: {{ credit }}

${t("eligiblegrades")}: {{ grade }}

${t("department")}: {{ department }}

${t("moreInfo")}

${t("videourl")}

`; const BASE_URL = "https://script.google.com/macros/s/AKfycbwOsYWw1faXk8rY8x9lKWfLmjwyu52FqrBYaHI14auK6pkxPdntmcSAaFhfYj-oCJ-M-Q/exec"; const fetchDataUrl = BASE_URL + (BASE_URL.includes("?") ? "&" : "?") + "lang=" + encodeURIComponent(currentLanguage); const fallbackFetchDataUrl = BASE_URL; console.log(t("credit")); // 2 sheets should exist; one with the main data, the other one with the filters const communityCoursesConfig = { jsonDataKeys: { mainFileKey: "programs", // Default key for the main file (ex: courses) data filtersKey: "filters", // Default key for filters data }, fetchDataUrl, fallbackFetchDataUrl, translateFailureRetries: 2, addLoadedClassTo: document.getElementById("course-catalog"), // when the content is loaded, a css class is added in order to hide the loader searchElement: document.getElementById("search-input"), // commejnt to disable search; also remove from HTML searchAsYouType: true, resetAllFiltersElement: ".js-reset-all-filters", // comment if the reset functionality is not needed; also remove from HTML sortButtonElement: ".js-sort-button", // comment if sort functionality is not needed; also remove from HTML itemsPerPageElement: ".js-items-per-page", // select how many items per page are shown; comment if not neeeded // also remove from HTML infoAreaElement: ".js-info-area", // search info: Showing X to Y of TOTAL entries; comment if not needed; also remove from HTML mainListArea: document.getElementById("main-list"), // this is where the results will be listed; required mainApp: document.getElementById("course-catalog"), // this is the main app ID; required itemsPerPageDefaultValue: 96, scrollToAppOnFilter: true, // scrolls to mainApp on filter isTranslateable: true, currentLanguage: currentLanguage, translationFeedbackElement: "#feedback-area", preferServerFilterTitles: true, itemTemplate, // modalConfig - builds the modal - you have to match a column name from thee spreadsheet with a CSS selector inside the modal modalConfig: { enabled: true, triggerSelector: ".custom-button--2", modalWrapperClass: "spreadsheet-item-modal", // generic naming fields: [ { data: "course-video", target: ".modal-course-video", type: "link", }, { data: "course-name", target: ".modal-course-name", type: "text", }, { data: "course-code", target: ".modal-course-code", type: "text", }, { data: "course-department", target: ".modal-course-department", type: "text", }, { data: "course-prerequisites", target: ".modal-course-prerequisites", type: "text", }, { data: "course-pathways", target: ".modal-course-pathways", type: "text", }, { data: "course-grade", target: ".modal-course-grade", type: "text", }, { data: "course-graduationrequirement", target: ".modal-course-graduationrequirement", type: "mailto", }, { data: "course-level", target: ".modal-course-level", type: "text", }, { data: "course-description", target: ".modal-course-description", type: "html", }, ], }, searchInColumns: ["courseName"], // if search is enabled, this is required sortingCriteria: "courseName", // if sortButtonElement is enabled, this is required; ONLY ONE enablePagination: true, // Set to false to disable pagination; option to create your own #pagination-area anywhere in the page //filterLogicBetweenGroups: "OR", // or AND selectFilters: { departmentFilter: { filterTitle: t("department"), filterLabel: "department", filterId: "department ID", listedColumn: "department ID", parentIdInPage: "custom-spreadsheet-app-select-area", extraClass: "department-flters js-is-collapsable is-collapsed", filterLogic: "OR", optionAll: true, allButtonText: "All", }, }, checkboxFilters: { creditFilter: { filterTitle: t("credit"), filterLabel: "credit", filterId: "credit ID", listedColumn: "credit ID", parentIdInPage: "custom-spreadsheet-app-filter-area", extraClass: "credit-flters js-is-collapsable is-collapsed", filterLogic: "OR", }, gradeFilter: { filterTitle: t("grades"), filterLabel: "grade", filterId: "grade ID", listedColumn: "grade ID", parentIdInPage: "custom-spreadsheet-app-filter-area", extraClass: "grade-filters js-is-collapsable is-collapsed", filterLogic: "OR", }, graduationRequirementFilter: { filterTitle: t("graduationRequirement"), filterLabel: "graduationRequirement", filterId: "graduationRequirement ID", listedColumn: "graduationRequirement ID", parentIdInPage: "custom-spreadsheet-app-filter-area", extraClass: "graduations-filters js-is-collapsable is-collapsed", filterLogic: "OR", }, }, }; const communityCourses = new CourseCatalog(communityCoursesConfig); }); }); // ------------------ END Course Catalog FROM SPREADSHEET ------------------ /* --------------------------------------------- / / --------- START Events Buttons -------------- / / --------------------------------------------- */ const addCustomButtonsToCalendar = () => { const eventCalendarContainer = document.querySelector( ".event-cal .event-cal-container" ); if (eventCalendarContainer) { const eventButtons = { "2025-2026 Student Calendar": "https://www.friscoisd.org/docs/default-source/frisco-isd-calendars/2025-2026-school-calendar.pdf?sfvrsn=39d6e38e_2", "2025-2026 AB Calendar": "https://www.friscoisd.org/docs/default-source/frisco-isd-calendars/ab-calendar-2025-26.pdf", "2026-2027 Student Calendar": "https://www.friscoisd.org/docs/default-source/frisco-isd-calendars/2026-27-student-calendar.pdf?sfvrsn=7a4791e6_9", "Frisco ISD Athletics Calendar (Rank One)": "https://app.rankone.com/Schedules/View_Schedule_All_Web.aspx?D=2ee51739-9dc4-41d3-8f80-534f6b0d1586&Mt=0" }; const calendarButtonContainer = document.createElement("div"); calendarButtonContainer.classList.add("custom-eventButtons"); calendarButtonContainer.style.display = "flex"; calendarButtonContainer.style.alignItems = "center"; calendarButtonContainer.style.justifyContent = "center"; calendarButtonContainer.style.flexFlow = "row wrap"; for (const [key, url] of Object.entries(eventButtons)) { const customCalendarButton = document.createElement("a"); customCalendarButton.setAttribute("target", "_blank"); customCalendarButton.setAttribute("href", url); customCalendarButton.innerText = key; customCalendarButton.style.margin = "6px 10px"; customCalendarButton.style.padding = "0.5em 1.5em"; customCalendarButton.style.display = "flex"; customCalendarButton.style.alignItems = "center"; customCalendarButton.style.fontWeight = "700"; customCalendarButton.style.textDecoration = "none"; customCalendarButton.style.backgroundColor = "var(--primary-color)"; customCalendarButton.style.color = "#fff"; customCalendarButton.style.borderRadius = "1.5em"; calendarButtonContainer.appendChild(customCalendarButton); } eventCalendarContainer.insertAdjacentElement( "beforebegin", calendarButtonContainer ); } }; document.addEventListener("appLoaded", addCustomButtonsToCalendar); /* --------------------------------------------- / / ----------- END Events Buttons -------------- / / --------------------------------------------- */

{{ Agency Name }}

${t("category")}: {{ Category }}

{{ Title }}

${t("author")}: {{ Author }}

{{ courseName }}

${t("courseCode")}: {{ courseCode }}

Frisco ISD eNewsletter: August 1, 2025