2a:null 2b:["$","title",null,{"children":"Post on google apps script | voteofsilence | Observable"}] 30:T4f5,sendToSheets = async function({sheetName, action, payload, token, options = {}, onProgress }) { const notify = (status, message) => { if (typeof onProgress === "function") { onProgress({ status, message }); } }; try { notify("SENDING", "Invio dati a Google Sheets in corso..."); const response = await fetch(googleappscript_url, { method: "POST", headers: { "Content-Type": "text/plain;charset=utf-8" }, body: JSON.stringify({ token, sheetName, action, payload }) }); notify("RECEIVING", "Risposta ricevuta, lettura esito..."); if (!response.ok) { throw new Error(`Errore HTTP ${response.status}: ${response.statusText}`); } const result = await response.json(); if (result.status === "error") { const errMsgi = result.message || result.error || "Errore sconosciuto lato server"; notify("ERROR", errMsgi); return { success: false, error: errMsgi }; } notify("SUCCESS", result.message || "Operazione completata con successo!"); return { success: true, data: result }; } catch (err) { const errorText = err.message || "Errore durante la connessione"; notify("ERROR", errorText); return { success: false, error: errorText }; } }31:T6c3,viewof widgetInvio = { // Contenitore HTML con stili per il badge di stato const container = html`

Stato: In attesa...

`; const btn = container.querySelector("#btn"); const statusDiv = container.querySelector("#status"); // Funzione per aggiornare la grafica dello stato const updateStatus = ({ status, message }) => { let color = "#555"; let icon = "⏳"; if (status === "SENDING") { color = "#d97706"; icon = "📤"; } if (status === "RECEIVING") { color = "#2563eb"; icon = "⚙️"; } if (status === "SUCCESS") { color = "#16a34a"; icon = "✅"; } if (status === "ERROR") { color = "#dc2626"; icon = "❌"; } statusDiv.innerHTML = `${icon} [${status}] ${message}`; }; btn.onclick = async () => { btn.disabled = true; btn.style.opacity = "0.6"; const res = await sendToSheets({ url: googleappscript_url, token: token, sheetName: "richieste", action: "add", payload: richiesta, onProgress: updateStatus} ); btn.disabled = false; btn.style.opacity = "1"; // Aggiorna il valore della cella Observable container.value = res; container.dispatchEvent(new Event("input")); }; container.value = null; return container; }32:[] 2e:{"id":"8d535e609321262f","slug":"post_biglietti","title":"Post on google apps script","thumbnail":"35551d8035475dce3fc74999971e944cbe56a826e7605bb908508a8870100ca1","access_level":"public","create_time":"$D2026-09-05T11:49:39.732Z","update_time":"$D2026-09-07T14:46:32.266Z","view_time":null,"first_public_time":"$D2026-09-05T14:11:31.935Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"58953e69d68be0b2","login":"voteofsilence","name":"","avatar_url":"https://avatars-next.observableusercontent.com/60f94f57b61e05ed3b443c9eac2e96cc2f2cc862852c8b2f6918f715a0b4c967","tier":"starter_2024"},"version":94,"publish_version":94,"role":null,"authored":false,"authors":[{"type":"individual","id":"3a04fcc840c2d21e","login":"voteofsilence","name":"","avatar_url":"https://avatars-next.observableusercontent.com/60f94f57b61e05ed3b443c9eac2e96cc2f2cc862852c8b2f6918f715a0b4c967","tier":null}],"members":[{"type":"team","id":"58953e69d68be0b2","login":"voteofsilence","name":"","avatar_url":"https://avatars-next.observableusercontent.com/60f94f57b61e05ed3b443c9eac2e96cc2f2cc862852c8b2f6918f715a0b4c967","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Post on google apps script","cells":[{"id":1,"value":"# Post on google apps script","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"googleappscript_url = \"https://script.google.com/macros/s/AKfycbwttn46R-M8MVZrojw3uHfc7BfZkYkY42tjXjx5fAhOMJMEL3kXihI3X6t6EmEZdn8-pw/exec\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"const response = await fetch(googleappscript_url, {\n method: \"POST\",\n mode: \"no-cors\",\n headers: { \"Content-Type\": \"text/plain\" },\n body: JSON.stringify({\n token: token,\n sheetName: \"richieste\",\n action: \"add\",\n payload: richiesta\n })\n});","pinned":true,"hidden":false,"mode":"js","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"richiesta = {\n return {\n id: \"12346572\",\n concerto: \"2026-09-07\",\n richiedente: \"Alice Milan\",\n data_richiesta: \"2026-09-13\",\n no_biglietti_richiesti: \"2\",\n no_biglietti_ottenuti: \"\",\n stato: \"pendente\"\n}\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"$30","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"// Esempio: Invocazione della funzione con gestione dello stato\npost = {\n let progressStatus = \"In attesa dell'invio...\";\n\n const outcome = await sendToSheets(\"richieste\", \"add\", richiesta,token, {\n onProgress: (state) => {\n // Questo callback viene invocato nei vari step\n console.log(\"Stato attuale:\", state);\n }\n });\n\n return outcome;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3,"value":"viewof token = Inputs.text()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"$31","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W32","stdlib":"2"}} 2f:"$2e:body"