[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_162":163,"_164":165},"routes/_app.x.$handle.$name",{"_103":102,"_37":49,"_111":93,"_32":112,"_13":14,"_113":-5,"_11":114,"_115":116,"_117":118,"_119":120,"_121":122,"_26":-5,"_123":-5,"_124":-5,"_125":30,"_126":127,"_128":62,"_129":-5,"_130":-5,"_131":132},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_47":48,"_37":49,"_42":50,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":36,"_61":62,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":86,"_87":88,"_89":90,"_91":30},"version",1,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","b31ea4ad-5698-4f6b-839a-bee01aa68836","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":33,"_38":39,"_40":41,"_42":43,"_44":14,"_45":46,"_29":30},"previous","deleted",false,"deletedHere","path","index.ts","latestPath","fileId","65372a4c-9bc2-11f1-8237-1607ee4eb77e","name","fileType","http","content","// Airtable-backed approval form.\n//\n// URL: /?record=recXXXX (the Airtable record id)\n//\n// Reads the record's fields, renders an approval form, and on submit\n// writes the approver's decision back to Airtable.\n//\n// Env vars required:\n// AIRTABLE_API_KEY personal access token (data.records:read + write)\n// AIRTABLE_BASE_ID the appBaseId, e.g. \"appAbC123\"\n// AIRTABLE_TABLE the table name or id\n// APPROVER_FIELD field name for the approver, e.g. \"Approver\"\n// NOTE_FIELD field name for the note, e.g. \"Approver Note\"\n// STATUS_FIELD field name for the decision, e.g. \"Status\"\n// NAME_FIELD field name to display as the request title, e.g. \"Name\"\n\nconst error = (msg: string, status = 500) =>\n new Response(`

Error

${escapeHtml(msg)}

`, {\n status,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n\nconst escapeHtml = (s: string) =>\n s.replace(/[&<>\"']/g, (c) =>\n ({ \"&\": \"&\", \"<\": \"<\", \">\": \">\", '\"': \""\", \"'\": \"'\" })[c]!\n );\n\nconst base = \"https://api.airtable.com/v0\";\n\nexport default async function handler(req: Request): Promise {\n const key = Deno.env.get(\"AIRTABLE_API_KEY\");\n const baseId = Deno.env.get(\"AIRTABLE_BASE_ID\");\n const table = Deno.env.get(\"AIRTABLE_TABLE\");\n if (!key || !baseId || !table) {\n return error(\"Missing AIRTABLE_* env vars. Add them in the val's env vars.\");\n }\n\n const f = {\n approver: Deno.env.get(\"APPROVER_FIELD\") || \"Approver\",\n note: Deno.env.get(\"NOTE_FIELD\") || \"Approver Note\",\n status: Deno.env.get(\"STATUS_FIELD\") || \"Status\",\n name: Deno.env.get(\"NAME_FIELD\") || \"Name\",\n };\n\n const url = new URL(req.url);\n const recordId = url.searchParams.get(\"record\");\n if (!recordId) {\n return error(\"Missing ?record= in the URL.\", 400);\n }\n\n if (req.method === \"POST\") {\n const form = await req.formData();\n const decision = form.get(\"decision\")?.toString() || \"\";\n const approver = form.get(\"approver\")?.toString() || \"\";\n const note = form.get(\"note\")?.toString() || \"\";\n\n const status = decision === \"approve\" ? \"Approved\" : \"Declined\";\n\n const res = await fetch(`${base}/${baseId}/${table}/${recordId}`, {\n method: \"PATCH\",\n headers: {\n Authorization: `Bearer ${key}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n typecast: true,\n fields: { [f.status]: status },\n }),\n }).catch((e) => null);\n\n if (!res || !res.ok) {\n const body = res ? await res.text() : \"network error\";\n console.error(\"Airtable PATCH failed:\", res?.status, body);\n return error(`Could not update the record. ${body}`, 502);\n }\n\n // Write the approver/note to our own small storage too (Airtable can't be\n // inferred, so append them to the same note field if present).\n await writeMeta(recordId, approver, note, status).catch(() => {});\n\n return new Response(\n `\n

✅ ${decision === \"approve\" ? \"Approved\" : \"Declined\"}

Thanks, your decision for this record has been saved to Airtable.

\n Back\n `,\n { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } },\n );\n }\n\n // GET — fetch record and render form\n const res = await fetch(`${base}/${baseId}/${table}/${recordId}`, {\n headers: { Authorization: `Bearer ${key}` },\n }).catch(() => null);\n\n if (!res || !res.ok) {\n return error(`Could not fetch record ${recordId}. Is the id valid?`, 404);\n }\n const data = await res.json();\n const recordFields = data.fields || {};\n const title = recordFields[f.name] ?? \"Approval request\";\n\n return new Response(\n `\n

${escapeHtml(String(title))}

Review this request and submit your decision.

\n \n `,\n { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } },\n );\n}\n\n// Minimal kv store for approvals so they're visible in Val Town too.\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst db = sqlite();\n\nasync function writeMeta(recordId: string, approver: string, note: string, status: string) {\n db.execute(\n `CREATE TABLE IF NOT EXISTS approvals (\n record_id TEXT PRIMARY KEY, approver TEXT, note TEXT, status TEXT, at TEXT DEFAULT CURRENT_TIMESTAMP\n )`,\n );\n db.execute(\n `INSERT OR REPLACE INTO approvals (record_id, approver, note, status) VALUES (?, ?, ?, ?)`,\n [recordId, approver, note, status],\n );\n}\n","createdAt",["D",1787139464917],"branchVersion","branchId","9b9abaa1-d920-4c6c-9e30-bb9fac0049e3","id","4d61816f-152b-42a1-8139-861fa01332f5","airtable-approval-form",["D",1787139453377],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Airtable-backed approval form (approve/decline)","imageUrl","45088755-762b-4822-a602-c6427fb13a1a","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a019cc-24df-7478-82d7-5b520124f432","tursoName","4d61816f152b42a18139861fa01332f5","tursoHostname","4d61816f152b42a18139861fa01332f5-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789476648181],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_103":102,"_110":-5},"org",{"_103":102,"_104":105,"_106":-5,"_19":-5,"_107":108,"_109":30},"branch",{"_13":92,"_37":93,"_47":46,"_94":48,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":49,"_101":102},"isOwned",23,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","orbem","handle","displayName","Orbem","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_47":48,"_37":49,"_42":157,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":36,"_61":62,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":158,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":159,"_87":160,"_89":161,"_91":30},"tree",[152],"files",[152],"counts",{"_141":66,"_142":14,"_143":66,"_144":145,"_146":147},"contents",[133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":134,"_37":33,"_35":36,"_135":-5,"_45":46,"_44":14,"_136":30,"_42":137,"_13":66,"_38":39,"_40":41,"_29":30,"_138":139,"_32":140},"2699efbb-18b8-4a84-9e8c-f9626b439d70","parentId","latest",["D",1787139464917],"label","airtable-approval",[33],"pulls","branches","forks","envVars",{"_148":150,"_151":66},"connections",{"_148":66,"_149":66},"count","unfilledCount",2,"emptyCount",{"_47":134,"_37":33,"_35":36,"_135":-5,"_45":46,"_44":14,"_136":30,"_42":153,"_13":66,"_38":39,"_40":41,"_29":30,"_138":139,"_154":155,"_32":156},["D",1787139464917],"children",[],[33],["D",1787139453377],["D",1789476648181],{"_103":102,"_110":-5},{"_103":102,"_104":105,"_106":-5,"_19":-5,"_107":108,"_109":30},{"_13":92,"_37":93,"_47":46,"_94":48,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":49,"_101":102},"ctx",{"_85":-5,"_130":195,"_196":197,"_198":199,"_200":30,"_201":30,"_202":30,"_203":62,"_204":-5,"_205":-7,"_206":-7,"_207":66,"_208":30,"_209":30,"_210":-5,"_211":30,"_212":30,"_213":30,"_214":-5},"ENV",{"_166":167,"_168":169,"_170":93,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v1