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","label",[170,66],"components","pulls","branches","forks","envVars",{"_178":26,"_180":26},"connections",{"_178":26,"_179":26},"count","unfilledCount","emptyCount",{"_32":228,"_13":170,"_64":162,"_42":-5,"_34":35,"_163":39,"_164":86,"_36":229,"_38":26,"_67":230,"_166":-5,"_69":24,"_168":-5,"_194":231,"_17":232},{"_32":221,"_13":222,"_64":223,"_42":162,"_34":35,"_163":39,"_164":86,"_36":224,"_38":26,"_67":68,"_166":225,"_69":24,"_168":-5,"_194":226,"_17":227},{"_32":214,"_13":215,"_64":216,"_42":162,"_34":35,"_163":39,"_164":86,"_36":217,"_38":26,"_67":68,"_166":218,"_69":24,"_168":-5,"_194":219,"_17":220},{"_32":161,"_13":66,"_64":65,"_42":162,"_34":35,"_163":39,"_164":86,"_36":211,"_38":26,"_67":68,"_166":167,"_69":24,"_168":-5,"_194":212,"_17":213},{"_32":204,"_13":205,"_64":206,"_42":-5,"_34":35,"_163":39,"_164":86,"_36":207,"_38":26,"_67":21,"_166":208,"_69":24,"_168":-5,"_194":209,"_17":210},{"_32":197,"_13":198,"_64":199,"_42":-5,"_34":35,"_163":39,"_164":86,"_36":200,"_38":26,"_67":68,"_166":201,"_69":24,"_168":-5,"_194":202,"_17":203},{"_32":188,"_13":189,"_64":84,"_42":-5,"_34":35,"_163":39,"_164":86,"_36":190,"_38":26,"_67":191,"_166":192,"_69":24,"_168":193,"_194":195,"_17":196},"1546a392-d258-4146-9fee-0ea725c960eb","main.tsx",["D",1786978814750],"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","mathan-form","children",[],[189],"3833e973-911c-4791-8f1f-fb764dea3946","db.ts","01a0103c-cb92-777b-83f7-742dc6f93fb5",["D",1786978814750],"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",[],[198],"b914d108-96fc-4f2e-b2bb-842a41196236","README.md","01a0103c-cb92-777b-83f7-70485bcce184",["D",1786978814750],"# 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",[],[205],["D",1786978814750],[],[170,66],"89bd7747-c30d-483e-9084-488065e46b88","Layout.tsx","01a0103c-cb92-777b-83f7-64de03a2e1a0",["D",1786978814750],"/** @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",[],[170,215],"85e5b826-2c47-4a6f-80fb-2906418d566e","FormPage.tsx","01a0103c-cb92-777b-83f7-6044613bfa6f",["D",1786978814750],"/** @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",[],[170,222],"2cd28e90-f894-45ea-b7e1-576ce61ec8b9",["D",1786978814750],"directory",[182,183,184],[170],["D",1786978814750],["D",1789498239291],{"_11":12,"_127":72},{"_11":12,"_122":123,"_71":72,"_30":70,"_124":125,"_126":24},{"_38":39,"_13":16,"_32":35,"_112":74,"_113":62,"_114":39,"_115":78,"_116":117,"_118":119,"_120":14,"_121":12},"ctx",{"_51":-5,"_148":271,"_272":273,"_274":275,"_276":24,"_277":24,"_278":24,"_279":86,"_280":-5,"_281":-7,"_282":-7,"_283":26,"_284":24,"_285":24,"_286":-5,"_287":24,"_288":24,"_289":24,"_290":-5},"ENV",{"_242":243,"_244":245,"_246":16,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264,"_265":266,"_267":268,"_269":270},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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"]

History · SubmissionsPage.tsx