[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_216":217,"_218":219},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_164":-5,"_20":165,"_22":166,"_167":168,"_169":170,"_26":171,"_24":172,"_173":-5,"_174":-5,"_175":54,"_176":177,"_178":45,"_179":-5,"_180":-5,"_181":182},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","Tribeca_Rep","name","tax-reminder-list","branchName","main","version","path","components/SubscribersPage.tsx","project",{"_33":106,"_13":14,"_46":107,"_108":-5,"_109":54,"_110":111,"_112":111,"_113":114,"_115":-5,"_116":117,"_118":64,"_119":45,"_120":-5,"_121":-5,"_122":48,"_123":124,"_125":126,"_127":128,"_129":130,"_131":-5,"_132":133,"_134":133,"_135":136,"_137":136,"_138":136,"_139":133,"_140":133,"_141":142,"_143":144,"_145":146,"_147":54},"tree",[58,59,60,61],"file",{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":56},"contents",[],"upstream","pull","ahead","behind","envVars","id","c968598b-29c1-4193-8897-d45bcc95704f","SubscribersPage.tsx","fileId","9dc1f060-a7ff-11f1-b25e-1607ee4eb77e","parentId","01a06a04-c9f8-74eb-96aa-027dfdf54c37","branchId","6921c41c-0094-40ab-820b-7b9840e727e2","branchVersion",5,"latest",true,"createdAt",["D",1788485173029],0,"fileType","script","content","/** @jsxImportSource npm:hono/jsx */\nimport Layout from \"./Layout.tsx\";\nimport type { Subscriber } from \"../db.ts\";\n\nexport default function SubscribersPage({ subscribers }: { subscribers: Subscriber[] }) {\n const bySite = new Map();\n for (const s of subscribers) {\n if (!bySite.has(s.site)) bySite.set(s.site, []);\n bySite.get(s.site)!.push(s);\n }\n\n return (\n \n

Tax reminder subscribers ({subscribers.length})

\n {[...bySite.entries()].map(([site, rows]) => (\n

{site} ({rows.length})

\n \n \n \n \n \n \n \n \n {rows.map((s) => (\n \n \n \n \n ))}\n \n

Email	Subscribed
{s.email}	{s.created_at}

\n ))}\n {subscribers.length === 0 &&

No subscribers yet.

}\n \n );\n}\n","deleted",false,"label",[57,35],"components",{"_33":88,"_13":57,"_36":39,"_38":-5,"_40":41,"_42":77,"_44":45,"_46":89,"_17":48,"_49":90,"_51":-5,"_53":54,"_55":-5,"_70":91,"_18":92},{"_33":81,"_13":82,"_36":83,"_38":-5,"_40":41,"_42":77,"_44":45,"_46":84,"_17":48,"_49":24,"_51":85,"_53":54,"_55":-5,"_70":86,"_18":87},{"_33":73,"_13":74,"_36":75,"_38":-5,"_40":41,"_42":67,"_44":45,"_46":76,"_17":77,"_49":50,"_51":78,"_53":54,"_55":-5,"_70":79,"_18":80},{"_33":62,"_13":63,"_36":64,"_38":-5,"_40":41,"_42":65,"_44":45,"_46":66,"_17":67,"_49":68,"_51":69,"_53":54,"_55":-5,"_70":71,"_18":72},"fb985ac1-9204-424a-bce5-1ae94451d8cc","main.tsx","01a06a04-c9f8-74eb-96aa-0e0010426b0c",8,["D",1788486491827],2,"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 if (c.req.query(\"key\") !== Deno.env.get(\"ADMIN_KEY\")) {\n return c.text(\"Not authorized.\", 401);\n }\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","children",[],[63],"7a0b9747-6017-48de-8975-2982fa93ab5e","db.ts","01a06a04-c9f8-74eb-96aa-0a5c24455eab",["D",1788485123477],1,"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",[],[74],"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",[],[82],"8698a8b3-3507-4ce9-a72e-c3f0f46687eb",["D",1788485093769],"directory",[93,94],[57],{"_33":98,"_13":99,"_36":100,"_38":39,"_40":41,"_42":101,"_44":45,"_46":102,"_17":77,"_49":50,"_51":103,"_53":54,"_55":-5,"_70":104,"_18":105},{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":95,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_70":96,"_18":97},["D",1788485173029],[],[57,35],"ee60d8b3-c26c-4d00-a346-09e448a847b1","Layout.tsx","01a06a04-c9f8-74eb-96a9-f93baabc1634",4,["D",1788485162818],"/** @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",[],[57,99],"0df0e67e-2aa6-42ba-9aa1-69fd20bc105b",["D",1788485093769],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Email list for tax filing deadline reminders","imageUrl","userId","c5acd3b3-60a7-4deb-bc6d-528f83012ea9","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019f8fe2-cdfc-775d-a845-a69af13d39cb","tursoName","0df0e67e2aa642ba9aa169fd20bc105b","tursoHostname","0df0e67e2aa642ba9aa169fd20bc105b-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789531852468],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_163":159},"org",{"_11":12,"_156":157,"_158":159,"_116":117,"_160":161,"_162":54},"branch",{"_17":65,"_13":16,"_33":41,"_148":106,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":-5,"_154":14,"_155":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","M A","avatar","https://lh3.googleusercontent.com/a/ACg8ocI9znhXn2hWp1wjjyWzeuOyoO_JrDgJo8aD0umFraR7bAG3UAmc=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":106,"_13":14,"_46":211,"_108":-5,"_109":54,"_110":111,"_112":111,"_113":114,"_115":-5,"_116":117,"_118":64,"_119":45,"_120":-5,"_121":-5,"_122":48,"_123":124,"_125":126,"_127":128,"_129":212,"_131":-5,"_132":133,"_134":133,"_135":136,"_137":136,"_138":136,"_139":133,"_140":133,"_141":213,"_143":214,"_145":215,"_147":54},[193,196,197,198],"files",[193,194,195,196,197,198],"counts",{"_184":48,"_185":77,"_186":48,"_32":187,"_188":189},[],{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":183},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[57,35],"pulls","branches","forks",{"_190":77,"_192":48},"connections",{"_190":48,"_191":48},"count","unfilledCount","emptyCount",{"_33":88,"_13":57,"_36":39,"_38":-5,"_40":41,"_42":77,"_44":45,"_46":89,"_17":48,"_49":90,"_51":-5,"_53":54,"_55":-5,"_70":209,"_18":210},{"_33":98,"_13":99,"_36":100,"_38":39,"_40":41,"_42":101,"_44":45,"_46":102,"_17":77,"_49":50,"_51":103,"_53":54,"_55":-5,"_70":207,"_18":208},{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":95,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_70":205,"_18":206},{"_33":81,"_13":82,"_36":83,"_38":-5,"_40":41,"_42":77,"_44":45,"_46":84,"_17":48,"_49":24,"_51":85,"_53":54,"_55":-5,"_70":203,"_18":204},{"_33":73,"_13":74,"_36":75,"_38":-5,"_40":41,"_42":67,"_44":45,"_46":76,"_17":77,"_49":50,"_51":78,"_53":54,"_55":-5,"_70":201,"_18":202},{"_33":62,"_13":63,"_36":64,"_38":-5,"_40":41,"_42":65,"_44":45,"_46":66,"_17":67,"_49":68,"_51":69,"_53":54,"_55":-5,"_70":199,"_18":200},[],[63],[],[74],[],[82],[],[57,35],[],[57,99],[194,195],[57],["D",1788485093769],["D",1789531852468],{"_11":12,"_163":159},{"_11":12,"_156":157,"_158":159,"_116":117,"_160":161,"_162":54},{"_17":65,"_13":16,"_33":41,"_148":106,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":-5,"_154":14,"_155":12},"ctx",{"_141":-5,"_180":249,"_250":251,"_252":253,"_254":54,"_255":54,"_256":54,"_257":45,"_258":-5,"_259":-7,"_260":-7,"_261":48,"_262":54,"_263":54,"_264":-5,"_265":54,"_266":54,"_267":54,"_268":-5},"ENV",{"_220":221,"_222":223,"_224":16,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248},"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"]