[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_222":223,"_224":225},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_167":-5,"_20":168,"_22":169,"_170":171,"_172":173,"_26":174,"_24":175,"_176":-5,"_177":-5,"_178":51,"_179":180,"_181":43,"_182":-5,"_183":-5,"_184":185},"routes/_app.x.$handle.$name.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","NITHISHLUNA","name","Feedback-Hub","branchName","main","version","path","README.md","project",{"_33":109,"_13":14,"_44":110,"_111":-5,"_112":51,"_113":114,"_115":114,"_116":117,"_118":-5,"_119":120,"_121":60,"_122":43,"_123":-5,"_124":-5,"_125":46,"_126":127,"_128":129,"_130":131,"_132":133,"_134":-5,"_135":136,"_137":136,"_138":139,"_140":139,"_141":139,"_142":136,"_143":136,"_144":145,"_146":147,"_148":149,"_150":51},"tree",[54,55,56,57],"file",{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_18":53},"contents",[],"upstream","pull","ahead","behind","envVars","id","1c629899-d081-4960-bb39-77e7f0b906a0","fileId","01a09ac2-2872-767b-b9f7-cabe225ae55f","parentId","branchId","f4fdd35e-e975-4324-a12e-4e6896cd020a","branchVersion",1,"latest",true,"createdAt",["D",1789302810667],0,"fileType","content","# 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","deleted",false,"label",[19],{"_33":78,"_13":79,"_35":80,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":81,"_17":46,"_47":82,"_48":-5,"_50":51,"_52":-5,"_64":83,"_18":84},{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":75,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_64":76,"_18":77},{"_33":67,"_13":68,"_35":69,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":70,"_17":46,"_47":71,"_48":72,"_50":51,"_52":-5,"_64":73,"_18":74},{"_33":58,"_13":59,"_35":60,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":61,"_17":46,"_47":62,"_48":63,"_50":51,"_52":-5,"_64":65,"_18":66},"a81537f2-9085-40a5-a6b6-3019c57685ee","main.tsx","01a09ac2-2872-767b-b9f7-d0248c91b340",["D",1789302810667],"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","children",[],[59],"4b281efc-fc29-468c-8f50-1059d49a3be7","db.ts","01a09ac2-2872-767b-b9f7-cd1a26ccced5",["D",1789302810667],"script","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",[],[68],["D",1789302810667],[],[19],"c3c4f531-6e6d-4831-8fcb-1a400bb39994","components","01a09ac2-2872-767b-b9f7-c62a86686e3e",["D",1789302810667],"directory",[85,86,87],[79],{"_33":102,"_13":103,"_35":104,"_37":80,"_38":39,"_40":41,"_42":43,"_44":105,"_17":46,"_47":71,"_48":106,"_50":51,"_52":-5,"_64":107,"_18":108},{"_33":95,"_13":96,"_35":97,"_37":80,"_38":39,"_40":41,"_42":43,"_44":98,"_17":46,"_47":71,"_48":99,"_50":51,"_52":-5,"_64":100,"_18":101},{"_33":88,"_13":89,"_35":90,"_37":80,"_38":39,"_40":41,"_42":43,"_44":91,"_17":46,"_47":71,"_48":92,"_50":51,"_52":-5,"_64":93,"_18":94},"7210e3bc-b989-40bf-9288-87bd94459c23","SubmissionsPage.tsx","01a09ac2-2872-767b-b9f7-c0a9aeb5dc39",["D",1789302810667],"/** @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",[],[79,89],"727720fc-9092-4a86-8345-dd0dd1eb943a","Layout.tsx","01a09ac2-2872-767b-b9f7-bfb95072ff8e",["D",1789302810667],"/** @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",[],[79,96],"8f971fe8-baec-4bef-a0a0-4e0c943edc03","FormPage.tsx","01a09ac2-2872-767b-b9f7-b9325e4a65c4",["D",1789302810667],"/** @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",[],[79,103],"1ead58a1-d986-4ae8-937e-a84cc6b506d0",["D",1789302810667],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Feedback form with SQLite response storage","imageUrl","userId","db1fe498-e3ce-41c4-9a4b-aadc5f270e6a","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","01a07c20-e282-758d-b417-c7f20f2b254c","tursoName","1ead58a1d9864ae8937ea84cc6b506d0","tursoHostname","1ead58a1d9864ae8937ea84cc6b506d0-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789477238750],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_166":162},"org",{"_11":12,"_159":160,"_161":162,"_119":120,"_163":164,"_165":51},"branch",{"_17":41,"_13":16,"_33":39,"_151":109,"_152":-5,"_153":-5,"_154":-5,"_155":-5,"_156":-5,"_157":14,"_158":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Nithish A","avatar","https://lh3.googleusercontent.com/a/ACg8ocLBGQxmuCLHRSTF1yuHm9tD4J7yNqIAKG1E18bHib3Blbra9m1Z=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":109,"_13":14,"_44":217,"_111":-5,"_112":51,"_113":114,"_115":114,"_116":117,"_118":-5,"_119":120,"_121":60,"_122":43,"_123":-5,"_124":-5,"_125":46,"_126":127,"_128":129,"_130":131,"_132":218,"_134":-5,"_135":136,"_137":136,"_138":139,"_140":139,"_141":139,"_142":136,"_143":136,"_144":219,"_146":220,"_148":221,"_150":51},[196,200,201,202],"files",[196,197,198,199,200,201,202],"counts",{"_187":46,"_188":41,"_189":46,"_32":190,"_191":192},[],{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_18":186},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],"pulls","branches","forks",{"_193":46,"_195":46},"connections",{"_193":46,"_194":46},"count","unfilledCount","emptyCount",{"_33":78,"_13":79,"_35":80,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":81,"_17":46,"_47":82,"_48":-5,"_50":51,"_52":-5,"_64":215,"_18":216},{"_33":102,"_13":103,"_35":104,"_37":80,"_38":39,"_40":41,"_42":43,"_44":105,"_17":46,"_47":71,"_48":106,"_50":51,"_52":-5,"_64":213,"_18":214},{"_33":95,"_13":96,"_35":97,"_37":80,"_38":39,"_40":41,"_42":43,"_44":98,"_17":46,"_47":71,"_48":99,"_50":51,"_52":-5,"_64":211,"_18":212},{"_33":88,"_13":89,"_35":90,"_37":80,"_38":39,"_40":41,"_42":43,"_44":91,"_17":46,"_47":71,"_48":92,"_50":51,"_52":-5,"_64":209,"_18":210},{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":75,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_64":207,"_18":208},{"_33":67,"_13":68,"_35":69,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":70,"_17":46,"_47":71,"_48":72,"_50":51,"_52":-5,"_64":205,"_18":206},{"_33":58,"_13":59,"_35":60,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":61,"_17":46,"_47":62,"_48":63,"_50":51,"_52":-5,"_64":203,"_18":204},[],[59],[],[68],[],[19],[],[79,89],[],[79,96],[],[79,103],[197,198,199],[79],["D",1789302810667],["D",1789477238750],{"_11":12,"_166":162},{"_11":12,"_159":160,"_161":162,"_119":120,"_163":164,"_165":51},{"_17":41,"_13":16,"_33":39,"_151":109,"_152":-5,"_153":-5,"_154":-5,"_155":-5,"_156":-5,"_157":14,"_158":12},"ctx",{"_144":-5,"_183":255,"_256":257,"_258":259,"_260":51,"_261":51,"_262":51,"_263":43,"_264":-5,"_265":-7,"_266":-7,"_267":46,"_268":51,"_269":51,"_270":-5,"_271":51,"_272":51,"_273":51,"_274":-5},"ENV",{"_226":227,"_228":229,"_230":16,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254},"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"]