[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_219":220,"_221":222},"routes/_app.x.$handle.$name",{"_101":100,"_32":46,"_110":91,"_27":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_20":-5,"_122":-5,"_123":-5,"_124":25,"_125":126,"_127":60,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":25},"version",4,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","components/Layout.tsx","latestPath","fileId","01a06a04-c9f8-74eb-96a9-f93baabc1634","name","Layout.tsx","fileType","script","content","/** @jsxImportSource npm:hono/jsx */\n\nexport default function Layout({ title, children }: { title: string; children?: unknown }) {\n return (\n \n \n \n \n {title}\n \n \n \n \n

{children}

\n \n \n );\n}\n","/** @jsxImportSource npm:hono/jsx */\n\nexport default function Layout({ title, children }: { title: string; children?: unknown }) {\n return (\n \n \n \n \n {title}\n \n \n \n \n

{children}

\n \n \n );\n}\n","createdAt",["D",1788485162818],"branchVersion","branchId","6921c41c-0094-40ab-820b-7b9840e727e2","id","0df0e67e-2aa6-42ba-9aa1-69fd20bc105b","tax-reminder-list",["D",1788485093769],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Email list for tax filing deadline reminders","imageUrl","c5acd3b3-60a7-4deb-bc6d-528f83012ea9","pinnedFileId","01a06a04-c9f8-74eb-96aa-0e0010426b0c","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f8fe2-cdfc-775d-a845-a69af13d39cb","tursoName","0df0e67e2aa642ba9aa169fd20bc105b","tursoHostname","0df0e67e2aa642ba9aa169fd20bc105b-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789444861734],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_101":100,"_109":105},"org",{"_101":100,"_102":103,"_104":105,"_18":56,"_106":107,"_108":25},"branch",{"_13":90,"_32":91,"_44":43,"_92":45,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":46,"_99":100},"isOwned",8,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Tribeca_Rep","handle","displayName","M A","avatar","https://lh3.googleusercontent.com/a/ACg8ocI9znhXn2hWp1wjjyWzeuOyoO_JrDgJo8aD0umFraR7bAG3UAmc=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":214,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":215,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":216,"_85":217,"_87":218,"_89":25},"tree",[176,180,181,182],"files",[176,177,178,179,180,181,182],"counts",{"_166":64,"_167":142,"_168":64,"_169":170,"_171":172},"contents",[132,133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":160,"_32":161,"_30":162,"_138":-5,"_42":43,"_41":142,"_140":60,"_39":163,"_13":64,"_34":164,"_36":-5,"_24":25,"_145":-5,"_27":165},{"_44":154,"_32":155,"_30":156,"_138":-5,"_42":43,"_41":142,"_140":60,"_39":157,"_13":64,"_34":20,"_36":158,"_24":25,"_145":-5,"_27":159},{"_44":147,"_32":148,"_30":149,"_138":-5,"_42":43,"_41":150,"_140":60,"_39":151,"_13":142,"_34":35,"_36":152,"_24":25,"_145":-5,"_27":153},{"_44":136,"_32":137,"_30":58,"_138":-5,"_42":43,"_41":139,"_140":25,"_39":141,"_13":142,"_34":143,"_36":144,"_24":25,"_145":-5,"_27":146},"426eb147-de5a-4601-bcc2-a40bec9652fe","main.tsx","parentId",3,"latest",["D",1788485138799],1,"http","/** @jsxImportSource npm:hono/jsx */\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport SubscribersPage from \"./components/SubscribersPage.tsx\";\nimport { addSubscriber, listSubscribers } from \"./db.ts\";\n\nconst ALLOWED_SITES = new Set([\n \"filenewyorksalestax.com\",\n \"filefloridasalestax.com\",\n \"homesteadexemptioninflorida.com\",\n]);\n\nconst app = new Hono();\n\napp.get(\"/\", (c) => c.text(\"Tax reminder list — see /source\"));\n\napp.post(\"/subscribe\", async (c) => {\n const form = await c.req.formData();\n\n // Honeypot: real visitors never fill this hidden field.\n if (String(form.get(\"bot-field\") ?? \"\").trim()) {\n return c.text(\"ok\", 200);\n }\n\n const email = String(form.get(\"email\") ?? \"\").trim().toLowerCase();\n const site = String(form.get(\"site\") ?? \"\").trim().toLowerCase();\n\n if (!ALLOWED_SITES.has(site)) {\n return c.text(\"Unrecognized site.\", 400);\n }\n if (!/^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/.test(email)) {\n return c.text(\"A valid email address is required.\", 400);\n }\n\n await addSubscriber(email, site);\n\n return c.redirect(`https://${site}/subscribed/`, 302);\n});\n\napp.get(\"/subscribers\", async (c) => {\n const subscribers = await listSubscribers();\n return c.html();\n});\n\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","label",[137],"7a0b9747-6017-48de-8975-2982fa93ab5e","db.ts","01a06a04-c9f8-74eb-96aa-0a5c24455eab",2,["D",1788485123477],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport interface Subscriber {\n id: number;\n email: string;\n site: string;\n created_at: string;\n}\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS subscribers (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT NOT NULL,\n site TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n UNIQUE(email, site)\n)`);\n\nexport async function addSubscriber(email: string, site: string) {\n await sqlite.execute({\n sql: \"INSERT OR IGNORE INTO subscribers (email, site) VALUES (?, ?)\",\n args: [email, site],\n });\n}\n\nexport async function listSubscribers(): Promise {\n const result = await sqlite.execute(\n \"SELECT id, email, site, created_at FROM subscribers ORDER BY id DESC\",\n );\n return result.rows as unknown as Subscriber[];\n}\n",[148],"fd3a92c2-388f-46f2-b5a3-9ef45cae1468","README.md","01a06a04-c9f8-74eb-96aa-0643313bc1c6",["D",1788485093769],"# What's the easiest way to put a form online and save submissions?\n\nRemix this val. It serves a contact form (name, email, message) at `/`, saves every submission to the val's own SQLite database, and lists everything received at `/submissions`. No external services, no API keys, no env vars.\n\n## Setup\n\n1. Remix this val.\n2. Open the HTTP endpoint of `main.tsx` — that is your live form. Share the URL.\n3. Visit `/submissions` on the same URL to see what people sent.\n\nEach remix gets its own private SQLite database, so your submissions stay with your copy.\n\n## Files\n\n- `main.tsx` — Hono routes: GET `/` (form), POST `/submit` (save), GET `/submissions` (list)\n- `db.ts` — creates the `submissions` table and holds the two queries\n- `components/Layout.tsx` — shared page shell with Tailwind (via Twind)\n- `components/FormPage.tsx` — the form\n- `components/SubmissionsPage.tsx` — the list\n\n## Notes\n\n- `/submissions` is public by default. If your form collects anything sensitive, protect that route before sharing the form URL.\n- No client-side JavaScript: the form is a plain HTML POST.\n",[155],"8698a8b3-3507-4ce9-a72e-c3f0f46687eb","components","01a06a04-c9f8-74eb-96aa-027dfdf54c37",["D",1788485093769],"directory",[161],"pulls","branches","forks","envVars",{"_173":142,"_175":64},"connections",{"_173":64,"_174":64},"count","unfilledCount","emptyCount",{"_44":160,"_32":161,"_30":162,"_138":-5,"_42":43,"_41":142,"_140":60,"_39":211,"_13":64,"_34":164,"_36":-5,"_24":25,"_145":-5,"_184":212,"_27":213},{"_44":204,"_32":205,"_30":206,"_138":162,"_42":43,"_41":142,"_140":25,"_39":207,"_13":64,"_34":35,"_36":208,"_24":25,"_145":-5,"_184":209,"_27":210},{"_44":200,"_32":33,"_30":31,"_138":162,"_42":43,"_41":14,"_140":60,"_39":201,"_13":142,"_34":35,"_36":38,"_24":25,"_145":-5,"_184":202,"_27":203},{"_44":193,"_32":194,"_30":195,"_138":162,"_42":43,"_41":142,"_140":25,"_39":196,"_13":64,"_34":35,"_36":197,"_24":25,"_145":-5,"_184":198,"_27":199},{"_44":154,"_32":155,"_30":156,"_138":-5,"_42":43,"_41":142,"_140":60,"_39":190,"_13":64,"_34":20,"_36":158,"_24":25,"_145":-5,"_184":191,"_27":192},{"_44":147,"_32":148,"_30":149,"_138":-5,"_42":43,"_41":150,"_140":60,"_39":187,"_13":142,"_34":35,"_36":152,"_24":25,"_145":-5,"_184":188,"_27":189},{"_44":136,"_32":137,"_30":58,"_138":-5,"_42":43,"_41":139,"_140":25,"_39":183,"_13":142,"_34":143,"_36":144,"_24":25,"_145":-5,"_184":185,"_27":186},["D",1788485138799],"children",[],[137],["D",1788485123477],[],[148],["D",1788485093769],[],[155],"4eb083bd-a1ac-4e90-aba4-f82cf948e97d","SubmissionsPage.tsx","01a06a04-c9f8-74eb-96a9-febfe1646045",["D",1788485093769],"/** @jsxImportSource npm:hono/jsx */\nimport type { Submission } from \"../db.ts\";\nimport Layout from \"./Layout.tsx\";\n\nexport default function SubmissionsPage({ submissions }: { submissions: Submission[] }) {\n return (\n \n

Submissions ({submissions.length})

\n {submissions.length === 0\n ?

Nothing yet. Be the first to submit the form.

\n : (\n

\n
\n {s.name}\n {s.created_at}\n
\n
{s.email}
\n
{s.message}
\n

\n )}\n

\n back to form\n view source\n

\n \n );\n}\n",[],[161,194],"ee60d8b3-c26c-4d00-a346-09e448a847b1",["D",1788485162818],[],[161,33],"1da560e0-0be8-4050-86a3-9044becbb438","FormPage.tsx","01a06a04-c9f8-74eb-96a9-f4a19585b1b8",["D",1788485093769],"/** @jsxImportSource npm:hono/jsx */\nimport Layout from \"./Layout.tsx\";\n\nexport default function FormPage() {\n return (\n \n

Contact form

\n Submissions are saved to this val's SQLite database.\n

\n \n

\n view submissions\n view source\n

\n \n );\n}\n",[],[161,205],["D",1788485093769],[177,178,179],[161],["D",1788485093769],["D",1789444861734],{"_101":100,"_109":105},{"_101":100,"_102":103,"_104":105,"_18":56,"_106":107,"_108":25},{"_13":90,"_32":91,"_44":43,"_92":45,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":46,"_99":100},"ctx",{"_83":-5,"_129":252,"_253":254,"_255":256,"_257":25,"_258":25,"_259":25,"_260":60,"_261":-5,"_262":-7,"_263":-7,"_264":64,"_265":25,"_266":25,"_267":-5,"_268":25,"_269":25,"_270":25,"_271":-5},"ENV",{"_223":224,"_225":226,"_227":91,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251},"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 · v4