Contact Form

\n \n \n

\n Success! Your message has been submitted successfully.\n

\n\n \n

\n Error! \n

\n\n \n \n\n \n

Recent Submissions

Loading submissions...

\n\n \n\n",[],[89,97],["D",1754338658766],[106,107,108],[19],{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":51,"_47":48,"_49":124,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_85":125,"_18":126},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":112,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_85":113,"_18":114},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":109,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_85":110,"_18":111},["D",1754338719472],[],[19,38],["D",1754338672141],[115],[19,61],{"_36":116,"_13":117,"_39":118,"_41":62,"_43":44,"_45":63,"_47":48,"_49":119,"_17":65,"_52":120,"_54":121,"_56":57,"_58":-5,"_85":122,"_18":123},"1933748e-7170-11f0-b3c3-0224a6c84d84","submissions.ts","1933756a-7170-11f0-b3c3-0224a6c84d84",["D",1754338672141],"script","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { createSubmission, getAllSubmissions } from \"../database/queries.ts\";\n\nconst app = new Hono();\n\n// Get all submissions\napp.get(\"/\", async (c) => {\n try {\n const submissions = await getAllSubmissions();\n return c.json(submissions);\n } catch (error) {\n console.error(\"Error fetching submissions:\", error);\n return c.json({ error: \"Failed to fetch submissions\" }, 500);\n }\n});\n\n// Create new submission\napp.post(\"/\", async (c) => {\n try {\n const body = await c.req.json();\n \n // Validate required fields\n if (!body.name || !body.email || !body.message) {\n return c.json({ error: \"Name, email, and message are required\" }, 400);\n }\n\n // Basic email validation\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n if (!emailRegex.test(body.email)) {\n return c.json({ error: \"Invalid email format\" }, 400);\n }\n\n const submission = await createSubmission({\n name: body.name.trim(),\n email: body.email.trim().toLowerCase(),\n message: body.message.trim()\n });\n\n return c.json(submission, 201);\n } catch (error) {\n console.error(\"Error creating submission:\", error);\n return c.json({ error: \"Failed to create submission\" }, 500);\n }\n});\n\nexport default app;",[],[19,61,117],["D",1754338658766],[127,128],[19,69],{"_36":137,"_13":138,"_39":139,"_41":70,"_43":44,"_45":51,"_47":48,"_49":140,"_17":65,"_52":120,"_54":141,"_56":57,"_58":-5,"_85":142,"_18":143},{"_36":129,"_13":130,"_39":131,"_41":70,"_43":44,"_45":132,"_47":48,"_49":133,"_17":65,"_52":120,"_54":134,"_56":57,"_58":-5,"_85":135,"_18":136},"14a21d08-7170-11f0-8696-0224a6c84d84","queries.ts","14a21d9e-7170-11f0-8696-0224a6c84d84",2,["D",1754338664485],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAME, FormSubmission } from \"./migrations.ts\";\n\nexport async function createSubmission(submission: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (name, email, message) VALUES (?, ?, ?) RETURNING *`,\n [submission.name, submission.email, submission.message]\n );\n \n return result.rows[0] as FormSubmission;\n}\n\nexport async function getAllSubmissions(): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} ORDER BY created_at DESC`);\n return result.rows as FormSubmission[];\n}\n\nexport async function getSubmissionById(id: number): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} WHERE id = ?`, [id]);\n return result.rows[0] as FormSubmission || null;\n}",[],[19,69,130],"1139a7e4-7170-11f0-afe7-0224a6c84d84","migrations.ts","1139a8c0-7170-11f0-afe7-0224a6c84d84",["D",1754338658766],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nexport const TABLE_NAME = 'form_submissions_1';\n\nexport interface FormSubmission {\n id?: number;\n name: string;\n email: string;\n message: string;\n created_at?: string;\n}\n\nexport async function initializeDatabase() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n message TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n}",[],[19,69,138],"ff03692a-716f-11f0-8ab5-0224a6c84d84",["D",1754338628214],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","019866c1-0cc7-754e-aedf-a14149adb38a","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019866c1-0cc7-754e-aedf-a65187b0b0e5","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_196":192},"org",{"_11":12,"_190":-5,"_191":192,"_153":154,"_193":194,"_195":57},"branch",{"_17":46,"_13":16,"_36":44,"_182":144,"_183":-5,"_184":-5,"_185":-5,"_186":-5,"_187":-5,"_188":14,"_189":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zMGhDbVE4R2tXVDgyU1VoaW1xWndSVEhyZGcifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":144,"_13":14,"_49":262,"_146":-5,"_147":57,"_148":149,"_150":149,"_151":-5,"_152":-5,"_153":154,"_155":40,"_156":48,"_157":48,"_158":-5,"_159":65,"_160":161,"_162":-5,"_163":-5,"_164":-5,"_165":-5,"_166":167,"_168":167,"_169":170,"_171":170,"_172":170,"_173":167,"_174":167,"_175":263,"_177":264,"_179":265,"_181":57},[232,239,241],"files",[232,233,234,235,236,237,238,239,240,241],"counts",{"_223":65,"_224":132,"_225":65,"_32":226,"_227":228},[217,218,219],{"_36":73,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":51,"_47":48,"_49":74,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_18":216},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":51,"_47":48,"_49":71,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_18":222},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":64,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_18":221},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_18":220},[19,38],[19,61],[19,69],"pulls","branches","forks",{"_229":65,"_231":65},"connections",{"_229":65,"_230":65},"count","unfilledCount","emptyCount",{"_36":73,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":51,"_47":48,"_49":103,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_85":260,"_18":261},{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":51,"_47":48,"_49":124,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_85":258,"_18":259},{"_36":137,"_13":138,"_39":139,"_41":70,"_43":44,"_45":51,"_47":48,"_49":140,"_17":65,"_52":120,"_54":141,"_56":57,"_58":-5,"_85":256,"_18":257},{"_36":129,"_13":130,"_39":131,"_41":70,"_43":44,"_45":132,"_47":48,"_49":133,"_17":65,"_52":120,"_54":134,"_56":57,"_58":-5,"_85":254,"_18":255},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":112,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_85":252,"_18":253},{"_36":116,"_13":117,"_39":118,"_41":62,"_43":44,"_45":63,"_47":48,"_49":119,"_17":65,"_52":120,"_54":121,"_56":57,"_58":-5,"_85":250,"_18":251},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":109,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_85":248,"_18":249},{"_36":88,"_13":89,"_39":90,"_41":-5,"_43":44,"_45":91,"_47":48,"_49":92,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_85":246,"_18":247},{"_36":96,"_13":97,"_39":98,"_41":90,"_43":44,"_45":91,"_47":48,"_49":99,"_17":65,"_52":24,"_54":100,"_56":57,"_58":-5,"_85":244,"_18":245},{"_36":79,"_13":80,"_39":81,"_41":-5,"_43":44,"_45":82,"_47":48,"_49":83,"_17":65,"_52":24,"_54":84,"_56":57,"_58":-5,"_85":242,"_18":243},[],[80],[],[89,97],[240],[89],[],[19,38],[],[19,61,117],[237],[19,61],[],[19,69,130],[],[19,69,138],[234,235],[19,69],[233,236,238],[19],["D",1754338628214],{"_11":12,"_196":192},{"_11":12,"_190":-5,"_191":192,"_153":154,"_193":194,"_195":57},{"_17":46,"_13":16,"_36":44,"_182":144,"_183":-5,"_184":-5,"_185":-5,"_186":-5,"_187":-5,"_188":14,"_189":12},"ctx",{"_175":-5,"_213":299,"_300":301,"_302":303,"_304":57,"_305":57,"_306":57,"_307":48,"_308":-5,"_309":-7,"_310":-7,"_311":65,"_312":57,"_313":57,"_314":-5,"_315":57,"_316":57,"_317":57,"_318":-5},"ENV",{"_270":271,"_272":273,"_274":16,"_275":276,"_277":278,"_279":280,"_281":282,"_283":284,"_285":286,"_287":288,"_289":290,"_291":292,"_293":294,"_295":296,"_297":298},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5a709144666c9e69e88140f015c586412f0fd8d3","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"]