var SHEET_URL = "https://docs.google.com/spreadsheets/d/e/2PACX-1vTG6wkpsyPn8J6ydLn2IYnhmDrHqGDU2661u7xAG087pIE9sO0gEwAH33k3eePg823IuR71-BFw7gtQ/pub?output=csv"; var sheetRows = []; function showImage() { var idx = parseInt(localStorage.getItem("sheetIdx") || "0"); var wrap = document.getElementById("img-wrap"); wrap.innerHTML = ""; var row = sheetRows[idx]; if (!row) return; var img = document.createElement("img"); img.src = row[2]; img.style.width = "80%"; img.style.display = "block"; wrap.appendChild(img); } fetch(SHEET_URL) .then(function(r){ return r.text(); }) .then(function(csv){ var lines = csv.trim().split("\n"); for (var i = 1; i < lines.length; i++) { var cols = lines[i].split(","); var url = cols[2] ? cols[2].trim().replace(/^"|"$/g,"") : ""; if (url) sheetRows.push([ cols[0] ? cols[0].trim().replace(/^"|"$/g,"") : "", cols[1] ? cols[1].trim().replace(/^"|"$/g,"") : "", url ]); } localStorage.setItem("sheetTotal", sheetRows.length); showImage(); }); window.addEventListener("sheetNavUpdate", showImage); window.addEventListener("storage", function(e) { if (e.key === "sheetIdx") showImage(); }); var SHEET_URL = "https://docs.google.com/spreadsheets/d/e/2PACX-1vTG6wkpsyPn8J6ydLn2IYnhmDrHqGDU2661u7xAG087pIE9sO0gEwAH33k3eePg823IuR71-BFw7gtQ/pub?output=csv"; var textRows = []; function showText() { var idx = parseInt(localStorage.getItem("sheetIdx") || "0"); var wrap = document.getElementById("text-wrap"); wrap.innerHTML = ""; var row = textRows[idx]; if (!row) return; var h = document.createElement("h1"); h.textContent = row[0]; h.style.fontSize = "2em"; h.style.margin = "0 0 0.25em 0"; h.style.fontFamily = "'Arial Rounded MT Bold',Arial,sans-serif"; var p = document.createElement("p"); p.textContent = row[1]; p.style.fontSize = "1em"; p.style.margin = "0 0 1em 0"; p.style.fontFamily = "'Arial Rounded MT Bold',Arial,sans-serif"; wrap.appendChild(h); wrap.appendChild(p); } fetch(SHEET_URL) .then(function(r){ return r.text(); }) .then(function(csv){ var lines = csv.trim().split("\n"); for (var i = 1; i < lines.length; i++) { var cols = lines[i].split(","); var url = cols[2] ? cols[2].trim().replace(/^"|"$/g,"") : ""; if (url) textRows.push([ cols[0] ? cols[0].trim().replace(/^"|"$/g,"") : "", cols[1] ? cols[1].trim().replace(/^"|"$/g,"") : "" ]); } showText(); }); window.addEventListener("sheetNavUpdate", showText); window.addEventListener("storage", function(e) { if (e.key === "sheetIdx") showText(); });