[{"_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",{"_100":99,"_32":45,"_109":90,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":-5,"_122":-5,"_123":25,"_124":125,"_126":59,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",2,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","db.ts","latestPath","fileId","01a06851-302f-749c-af36-3c2a9b50d72f","name","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport interface Submission {\n id: number;\n name: string;\n email: string;\n message: string;\n created_at: string;\n}\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS submissions (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n message TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n)`);\n\nexport async function addSubmission(name: string, email: string, message: string) {\n await sqlite.execute({\n sql: \"INSERT INTO submissions (name, email, message) VALUES (?, ?, ?)\",\n args: [name, email, message],\n });\n}\n\nexport async function listSubmissions(): Promise {\n const result = await sqlite.execute(\n \"SELECT id, name, email, message, created_at FROM submissions ORDER BY id DESC\",\n );\n return result.rows as unknown as Submission[];\n}\n","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","createdAt",["D",1788456602836],"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",{"_100":99,"_108":104},"org",{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":25},"branch",{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"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",{"_43":44,"_32":45,"_38":211,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":212,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":213,"_84":214,"_86":215,"_88":25},"tree",[170,174,175,176],"files",[170,171,172,173,174,175,176],"counts",{"_160":63,"_161":138,"_162":63,"_163":164,"_165":166},"contents",[131,132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":154,"_32":155,"_30":156,"_137":-5,"_41":42,"_40":138,"_139":59,"_38":157,"_13":63,"_33":158,"_35":-5,"_24":25,"_143":-5,"_27":159},{"_43":148,"_32":149,"_30":150,"_137":-5,"_41":42,"_40":138,"_139":59,"_38":151,"_13":63,"_33":20,"_35":152,"_24":25,"_143":-5,"_27":153},{"_43":145,"_32":28,"_30":31,"_137":-5,"_41":42,"_40":14,"_139":59,"_38":146,"_13":138,"_33":34,"_35":37,"_24":25,"_143":-5,"_27":147},{"_43":135,"_32":136,"_30":57,"_137":-5,"_41":42,"_40":138,"_139":25,"_38":140,"_13":63,"_33":141,"_35":142,"_24":25,"_143":-5,"_27":144},"87213997-e928-41f7-86f4-6f949b82be0c","main.tsx","parentId",1,"latest",["D",1788456546221],"http","/** @jsxImportSource npm:hono/jsx */\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport FormPage from \"./components/FormPage.tsx\";\nimport SubmissionsPage from \"./components/SubmissionsPage.tsx\";\nimport { addSubmission, listSubmissions } from \"./db.ts\";\n\nconst app = new Hono();\n\napp.get(\"/\", (c) => c.html());\n\napp.post(\"/submit\", async (c) => {\n const form = await c.req.formData();\n const name = String(form.get(\"name\") ?? \"\").trim();\n const email = String(form.get(\"email\") ?? \"\").trim();\n const message = String(form.get(\"message\") ?? \"\").trim();\n if (!name || !email || !message) {\n return c.text(\"Name, email, and message are all required.\", 400);\n }\n await addSubmission(name, email, message);\n return c.redirect(\"/submissions\");\n});\n\napp.get(\"/submissions\", async (c) => {\n const submissions = await listSubmissions();\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",[136],"3fa66a25-0714-4a5e-b0ed-ce482d46a5d6",["D",1788456602836],[28],"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",[149],"a1138fe6-5441-4a00-9ea7-7ddf58060e0b","components","01a06851-302f-749c-af36-35a6166f97ac",["D",1788456546221],"directory",[155],"pulls","branches","forks","envVars",{"_167":14,"_169":63},"connections",{"_167":63,"_168":63},"count","unfilledCount","emptyCount",{"_43":154,"_32":155,"_30":156,"_137":-5,"_41":42,"_40":138,"_139":59,"_38":208,"_13":63,"_33":158,"_35":-5,"_24":25,"_143":-5,"_178":209,"_27":210},{"_43":201,"_32":202,"_30":203,"_137":156,"_41":42,"_40":138,"_139":25,"_38":204,"_13":63,"_33":34,"_35":205,"_24":25,"_143":-5,"_178":206,"_27":207},{"_43":194,"_32":195,"_30":196,"_137":156,"_41":42,"_40":138,"_139":25,"_38":197,"_13":63,"_33":34,"_35":198,"_24":25,"_143":-5,"_178":199,"_27":200},{"_43":187,"_32":188,"_30":189,"_137":156,"_41":42,"_40":138,"_139":25,"_38":190,"_13":63,"_33":34,"_35":191,"_24":25,"_143":-5,"_178":192,"_27":193},{"_43":148,"_32":149,"_30":150,"_137":-5,"_41":42,"_40":138,"_139":59,"_38":184,"_13":63,"_33":20,"_35":152,"_24":25,"_143":-5,"_178":185,"_27":186},{"_43":145,"_32":28,"_30":31,"_137":-5,"_41":42,"_40":14,"_139":59,"_38":181,"_13":138,"_33":34,"_35":37,"_24":25,"_143":-5,"_178":182,"_27":183},{"_43":135,"_32":136,"_30":57,"_137":-5,"_41":42,"_40":138,"_139":25,"_38":177,"_13":63,"_33":141,"_35":142,"_24":25,"_143":-5,"_178":179,"_27":180},["D",1788456546221],"children",[],[136],["D",1788456602836],[],[28],["D",1788456546221],[],[149],"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",[],[155,188],"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",[],[155,195],"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",[],[155,202],["D",1788456546221],[171,172,173],[155],["D",1788456546221],["D",1789501263826],{"_100":99,"_108":104},{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":25},{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"ctx",{"_82":-5,"_128":249,"_250":251,"_252":253,"_254":25,"_255":25,"_256":25,"_257":59,"_258":-5,"_259":-7,"_260":-7,"_261":63,"_262":25,"_263":25,"_264":-5,"_265":25,"_266":25,"_267":25,"_268":-5},"ENV",{"_220":221,"_222":223,"_224":90,"_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"]

Diff · v2