[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_225":226,"_227":228},"routes/_app.x.$handle.$name",{"_99":98,"_31":44,"_108":89,"_26":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":24,"_123":124,"_125":58,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":24},"version",4,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","components/LeadsPage.tsx","latestPath","fileId","28d08204-a7bd-11f1-ba65-1607ee4eb77e","name","LeadsPage.tsx","fileType","script","content","/** @jsxImportSource npm:hono/jsx */\nimport Layout from \"./Layout.tsx\";\nimport type { Lead } from \"../db.ts\";\n\nexport default function LeadsPage({ leads }: { leads: Lead[] }) {\n return (\n \n

Leads

\n Most recent {leads.length} submission{leads.length === 1 ? \"\" : \"s\"} across all sites.\n

\n {leads.map((lead) => {\n const fields = JSON.parse(lead.fields_json) as Record;\n return (\n

\n \n {lead.site} · {lead.form_name}\n \n {lead.created_at}\n

{k}: {v}

\n );\n })}\n {leads.length === 0 &&

No leads yet.

}\n

\n \n );\n}\n","createdAt",["D",1788456630046],"branchVersion","branchId","a3185ec6-ba1c-4b36-b86e-d84880f41daf","id","9f69e07f-cfcb-4caa-9929-255d912e2d33","tribeca-lead-relay",["D",1788456546221],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Netlify Forms replacement: emails + stores quote-form leads","imageUrl","c5acd3b3-60a7-4deb-bc6d-528f83012ea9","pinnedFileId","01a06851-302f-749c-af36-42279acb0805","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f8fe2-cdfc-775d-a845-a69af13d39cb","tursoName","9f69e07fcfcb4caa9929255d912e2d33","tursoHostname","9f69e07fcfcb4caa9929255d912e2d33-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789501263826],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":54,"_104":105,"_106":24},"branch",{"_13":88,"_31":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"isOwned",13,"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",{"_42":43,"_31":44,"_37":220,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":221,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":222,"_83":223,"_85":224,"_87":24},"tree",[174,179,180,181],"files",[174,175,176,177,178,179,180,181],"counts",{"_164":62,"_165":140,"_166":62,"_167":168,"_169":170},"contents",[130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":158,"_31":159,"_29":160,"_136":-5,"_40":41,"_39":140,"_138":58,"_37":161,"_13":62,"_33":162,"_35":-5,"_23":24,"_143":-5,"_26":163},{"_42":152,"_31":153,"_29":154,"_136":-5,"_40":41,"_39":140,"_138":58,"_37":155,"_13":62,"_33":20,"_35":156,"_23":24,"_143":-5,"_26":157},{"_42":145,"_31":146,"_29":147,"_136":-5,"_40":41,"_39":148,"_138":58,"_37":149,"_13":140,"_33":34,"_35":150,"_23":24,"_143":-5,"_26":151},{"_42":134,"_31":135,"_29":56,"_136":-5,"_40":41,"_39":137,"_138":24,"_37":139,"_13":140,"_33":141,"_35":142,"_23":24,"_143":-5,"_26":144},"6c549611-b050-48ee-bf97-a76e9ccf6a91","main.tsx","parentId",3,"latest",["D",1788456618933],1,"http","/** @jsxImportSource npm:hono/jsx */\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { email } from \"https://esm.town/v/std/email\";\nimport { Hono } from \"npm:hono\";\nimport LeadsPage from \"./components/LeadsPage.tsx\";\nimport { addLead, listLeads } from \"./db.ts\";\n\nconst app = new Hono();\n\n// Only these sites may post here. Keeps this from being usable as an open\n// mail relay by anyone who finds the URL, and pins the /thank-you/ redirect\n// target to a known-good domain.\nconst ALLOWED_SITES = new Set([\n \"jerseywaterdeliverypros.com\",\n \"manhattanwaterdeliverypros.com\",\n \"miamiwaterdeliverypros.com\",\n]);\n\nconst NOTIFY_TO = \"info@tribecabeverage.com\";\n\napp.get(\"/\", (c) => c.redirect(\"/leads\"));\n\napp.post(\"/submit\", async (c) => {\n const form = await c.req.formData();\n\n // Honeypot: real visitors never fill this in. Bots that blindly fill\n // every field will.\n if (String(form.get(\"bot-field\") ?? \"\").trim()) {\n return new Response(null, { status: 302, headers: { Location: \"/thank-you-bot\" } });\n }\n\n const site = String(form.get(\"site\") ?? \"\").trim().toLowerCase();\n const formName = String(form.get(\"form-name\") ?? \"unknown\").trim();\n\n if (!ALLOWED_SITES.has(site)) {\n return c.text(\"Unrecognized site.\", 400);\n }\n\n const fields: Record = {};\n for (const [key, value] of form.entries()) {\n if (key === \"site\" || key === \"form-name\" || key === \"bot-field\") continue;\n fields[key] = String(value);\n }\n\n // Require at least one way to reach the person who submitted this.\n if (!fields.email && !fields.phone) {\n return c.text(\"An email or phone number is required.\", 400);\n }\n\n await addLead(site, formName, fields);\n\n const lines = Object.entries(fields)\n .map(([k, v]) => `${k}: ${v}`)\n .join(\"\\n\");\n\n try {\n await email({\n to: NOTIFY_TO,\n subject: `New ${formName} lead — ${site}`,\n text: `New submission from ${site} (${formName} form)\\n\\n${lines}`,\n });\n } catch (err) {\n // Don't fail the user's submission just because the notification email\n // had a problem — it's already durably stored above.\n console.error(\"notification email failed:\", err);\n }\n\n return new Response(null, {\n status: 302,\n headers: { Location: `https://${site}/thank-you/` },\n });\n});\n\napp.get(\"/leads\", async (c) => {\n const leads = await listLeads();\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",[135],"3fa66a25-0714-4a5e-b0ed-ce482d46a5d6","db.ts","01a06851-302f-749c-af36-3c2a9b50d72f",2,["D",1788456602836],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport interface Lead {\n id: number;\n site: string;\n form_name: string;\n fields_json: string;\n created_at: string;\n}\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS leads (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n site TEXT NOT NULL,\n form_name TEXT NOT NULL,\n fields_json TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n)`);\n\nexport async function addLead(site: string, formName: string, fields: Record) {\n await sqlite.execute({\n sql: \"INSERT INTO leads (site, form_name, fields_json) VALUES (?, ?, ?)\",\n args: [site, formName, JSON.stringify(fields)],\n });\n}\n\nexport async function listLeads(): Promise {\n const result = await sqlite.execute(\n \"SELECT id, site, form_name, fields_json, created_at FROM leads ORDER BY id DESC LIMIT 200\",\n );\n return result.rows as unknown as Lead[];\n}\n",[146],"8cb63f41-8a7e-420a-bdd4-597ac50cb0cb","README.md","01a06851-302f-749c-af36-3b812047b4b4",["D",1788456546221],"# 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",[153],"a1138fe6-5441-4a00-9ea7-7ddf58060e0b","components","01a06851-302f-749c-af36-35a6166f97ac",["D",1788456546221],"directory",[159],"pulls","branches","forks","envVars",{"_171":148,"_173":62},"connections",{"_171":62,"_172":62},"count","unfilledCount","emptyCount",{"_42":158,"_31":159,"_29":160,"_136":-5,"_40":41,"_39":140,"_138":58,"_37":217,"_13":62,"_33":162,"_35":-5,"_23":24,"_143":-5,"_183":218,"_26":219},{"_42":210,"_31":211,"_29":212,"_136":160,"_40":41,"_39":140,"_138":24,"_37":213,"_13":62,"_33":34,"_35":214,"_23":24,"_143":-5,"_183":215,"_26":216},{"_42":203,"_31":204,"_29":205,"_136":160,"_40":41,"_39":140,"_138":24,"_37":206,"_13":62,"_33":34,"_35":207,"_23":24,"_143":-5,"_183":208,"_26":209},{"_42":199,"_31":32,"_29":30,"_136":160,"_40":41,"_39":14,"_138":58,"_37":200,"_13":62,"_33":34,"_35":36,"_23":24,"_143":-5,"_183":201,"_26":202},{"_42":192,"_31":193,"_29":194,"_136":160,"_40":41,"_39":140,"_138":24,"_37":195,"_13":62,"_33":34,"_35":196,"_23":24,"_143":-5,"_183":197,"_26":198},{"_42":152,"_31":153,"_29":154,"_136":-5,"_40":41,"_39":140,"_138":58,"_37":189,"_13":62,"_33":20,"_35":156,"_23":24,"_143":-5,"_183":190,"_26":191},{"_42":145,"_31":146,"_29":147,"_136":-5,"_40":41,"_39":148,"_138":58,"_37":186,"_13":140,"_33":34,"_35":150,"_23":24,"_143":-5,"_183":187,"_26":188},{"_42":134,"_31":135,"_29":56,"_136":-5,"_40":41,"_39":137,"_138":24,"_37":182,"_13":140,"_33":141,"_35":142,"_23":24,"_143":-5,"_183":184,"_26":185},["D",1788456618933],"children",[],[135],["D",1788456602836],[],[146],["D",1788456546221],[],[153],"e1c69940-990d-4463-a6f0-fdeedc263da1","SubmissionsPage.tsx","01a06851-302f-749c-af36-32e4e51a62e5",["D",1788456546221],"/** @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",[],[159,193],"60cf02c9-6e37-4193-a53d-c40b623fea9d",["D",1788456630046],[],[159,32],"8979b737-7046-49db-a003-560c9580a00c","Layout.tsx","01a06851-302f-749c-af36-2d631c7d892c",["D",1788456546221],"/** @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",[],[159,204],"6250a57e-1efc-499b-ad35-ab49bc48a0ff","FormPage.tsx","01a06851-302f-749c-af36-2912c1fb24be",["D",1788456546221],"/** @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",[],[159,211],["D",1788456546221],[175,176,177,178],[159],["D",1788456546221],["D",1789501263826],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":54,"_104":105,"_106":24},{"_13":88,"_31":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"ctx",{"_81":-5,"_127":258,"_259":260,"_261":262,"_263":24,"_264":24,"_265":24,"_266":58,"_267":-5,"_268":-7,"_269":-7,"_270":62,"_271":24,"_272":24,"_273":-5,"_274":24,"_275":24,"_276":24,"_277":-5},"ENV",{"_229":230,"_231":232,"_233":89,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257},"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