New submission for \"${form.title}\"

You have received a new form submission:

\n ${formattedData.split('\\n').map(line => `

${line.split(':')[0]}: ${line.split(':').slice(1).join(':')}

`).join('')}\n

Submitted at: ${response.submittedAt}

\n `\n });\n } catch (emailError) {\n console.error(\"Failed to send email notification:\", emailError);\n // Don't fail the submission if email fails\n }\n }\n\n return c.json({\n success: true,\n message: form.settings.responseMessage || \"Thank you for your submission!\",\n responseId: response.id\n });\n } catch (error) {\n console.error(\"Error submitting form:\", error);\n return c.json({ error: \"Failed to submit form\" }, 500);\n }\n});\n\n// Get form responses\napp.get(\"/:id/responses\", async (c) => {\n try {\n const formId = c.req.param(\"id\");\n \n // Verify form exists\n const form = await getForm(formId);\n if (!form) {\n return c.json({ error: \"Form not found\" }, 404);\n }\n\n const responses = await getFormResponses(formId);\n return c.json(responses);\n } catch (error) {\n console.error(\"Error fetching responses:\", error);\n return c.json({ error: \"Failed to fetch responses\" }, 500);\n }\n});\n\n// Get form statistics\napp.get(\"/:id/stats\", async (c) => {\n try {\n const formId = c.req.param(\"id\");\n \n // Verify form exists\n const form = await getForm(formId);\n if (!form) {\n return c.json({ error: \"Form not found\" }, 404);\n }\n\n const stats = await getFormStats(formId);\n return c.json(stats);\n } catch (error) {\n console.error(\"Error fetching stats:\", error);\n return c.json({ error: \"Failed to fetch stats\" }, 500);\n }\n});\n\n// Export responses to CSV\napp.get(\"/:id/export\", async (c) => {\n try {\n const formId = c.req.param(\"id\");\n \n // Verify form exists\n const form = await getForm(formId);\n if (!form) {\n return c.json({ error: \"Form not found\" }, 404);\n }\n\n const responses = await getFormResponses(formId);\n \n if (responses.length === 0) {\n return c.json({ error: \"No responses to export\" }, 404);\n }\n\n // Create CSV headers\n const headers = [\"Submission ID\", \"Submitted At\", ...form.fields.map(f => f.label)];\n \n // Create CSV rows\n const rows = responses.map(response => [\n response.id,\n response.submittedAt,\n ...form.fields.map(field => {\n const value = response.data[field.id];\n if (Array.isArray(value)) {\n return value.join(\"; \");\n }\n return value || \"\";\n })\n ]);\n\n // Generate CSV content\n const csvContent = [\n headers.join(\",\"),\n ...rows.map(row => row.map(cell => `\"${String(cell).replace(/\"/g, '\"\"')}\"`).join(\",\"))\n ].join(\"\\n\");\n\n return new Response(csvContent, {\n headers: {\n \"Content-Type\": \"text/csv\",\n \"Content-Disposition\": `attachment; filename=\"${form.title.replace(/[^a-zA-Z0-9]/g, \"_\")}_responses.csv\"`\n }\n });\n } catch (error) {\n console.error(\"Error exporting responses:\", error);\n return c.json({ error: \"Failed to export responses\" }, 500);\n }\n});\n\nexport default app;","deleted","label",[170,171,153],"backend","routes","permalink","https://www.val.town/x/kyumz/Forms/code/backend/routes/forms.ts","extension","actionData","errors"]