Admin Dashboard

\n );\n }\n\n return (\n

Val Town Hall Admin Dashboard

\n \n

Summary

Attendees

{data?.attendees.length || 0}

Speakers

{data?.speakers.length || 0}

Total

{data?.totalCount || 0}

\n \n

Interest Popularity

\n \n \n \n \n \n \n \n \n {interestCounts.map((item, index) => (\n \n \n \n \n ))}\n {interestCounts.length === 0 && (\n \n \n \n )}\n \n

Interest	Count
{item.interest}	{item.count}
No interest data available

\n\n

Speakers

\n \n \n \n \n \n \n \n \n \n \n \n \n {data?.speakers.map((speaker) => (\n \n \n \n \n \n \n \n \n ))}\n {(!data?.speakers || data.speakers.length === 0) && (\n \n \n \n )}\n \n

Name	Email	Username	Talk Description	Interests	Date
{speaker.name}	{speaker.email}	{speaker.username \|\| \"N/A\"}	\n \n {speaker.talk_description \|\| \"N/A\"}\n \n	\n {parseInterests(speaker.interests)}\n {speaker.interest_custom && Custom: {speaker.interest_custom} }\n	{formatDate(speaker.created_at)}
No speakers found

\n\n

Attendees

\n \n \n \n \n \n \n \n \n \n \n \n \n {data?.attendees.map((attendee) => (\n \n \n \n \n \n \n \n \n ))}\n {(!data?.attendees || data.attendees.length === 0) && (\n \n \n \n )}\n \n

Name	Email	Company	Website	Interests	Date
{attendee.name}	{attendee.email}	{attendee.company \|\| \"N/A\"}	{attendee.website \|\| \"N/A\"}	\n {parseInterests(attendee.interests)}\n {attendee.interest_custom && Custom: {attendee.interest_custom} }\n	{formatDate(attendee.created_at)}
No attendees found

\n\n

Email Lists for Gmail

\n \n \n \n

\n \n

Copy and paste these emails into Gmail's recipient field:

\n \n

\n \n Copy to Clipboard\n \n {copySuccess && (\n {copySuccess}\n )}\n

\n\n

\n setIsAuthenticated(false)}\n className=\"bg-gray-200 text-gray-800 py-2 px-4 rounded-md hover:bg-gray-300 focus:outline-none focus:ring-2 focus:ring-gray-500\"\n >\n Logout\n \n

\n );\n}",[],[151,171,178],{"_103":187,"_95":188,"_152":189,"_154":172,"_155":137,"_156":136,"_158":159,"_105":190,"_100":191,"_162":182,"_164":192,"_165":22,"_166":-5,"_167":193,"_98":194},"d4d485d0-4d1b-11f0-a74e-76b3cceeab13","App.tsx","962017ec-3005-11f0-87f4-569c3dd06744",["D",1750344237852],7,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport { EventDetails } from \"./EventDetails.tsx\";\nimport { CancellationMessage } from \"./CancellationMessage.tsx\";\nimport { AdminDashboard } from \"./AdminDashboard.tsx\";\n\nexport function App() {\n const [isAdminRoute, setIsAdminRoute] = useState(false);\n\n // Check if the current route is /admin\n useEffect(() => {\n const checkRoute = () => {\n const path = window.location.pathname;\n setIsAdminRoute(path === \"/admin\");\n };\n\n // Check on initial load\n checkRoute();\n\n // Listen for route changes\n const handleRouteChange = () => {\n checkRoute();\n };\n\n window.addEventListener(\"popstate\", handleRouteChange);\n \n return () => {\n window.removeEventListener(\"popstate\", handleRouteChange);\n };\n }, []);\n\n // If we're on the admin route, show the admin dashboard\n if (isAdminRoute) {\n return ;\n }\n\n // Otherwise show the regular app\n return (\n

Val Town Hall

\n \n

\n\n \n\n \n

\n );\n}",[],[151,171,188],{"_103":196,"_95":197,"_152":198,"_154":172,"_155":137,"_156":199,"_158":159,"_105":200,"_100":201,"_162":182,"_164":202,"_165":22,"_166":-5,"_167":203,"_98":204},"24c5551c-300f-11f0-b10f-569c3dd06744","AttendeeForm.tsx","646d69ae-300d-11f0-97d2-569c3dd06744",90,["D",1747150204794],4,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\n\n// Define the available interest options\nconst INTEREST_OPTIONS = [\n { id: \"qa\", label: \"Q&A session with the Val Town Team\" },\n { id: \"demos\", label: \"Demos of new features\" },\n { id: \"roadmap\", label: \"Learn more about the Val Town roadmap\" },\n { id: \"breakout\", label: \"Breakout rooms to connect with fellow Val Town users\" }\n];\n\ninterface FormData {\n name: string;\n email: string;\n company: string;\n website: string;\n isSpeaker: boolean;\n username: string;\n talkDescription: string;\n interests: string[];\n interestCustom: string;\n}\n\ninterface AttendeeFormProps {\n onSubmitSuccess: () => void;\n onSubmitError: (message: string) => void;\n}\n\nexport function AttendeeForm({ onSubmitSuccess, onSubmitError }: AttendeeFormProps) {\n const [formData, setFormData] = useState({\n name: \"\",\n email: \"\",\n company: \"\",\n website: \"\",\n isSpeaker: false,\n username: \"\",\n talkDescription: \"\",\n interests: [],\n interestCustom: \"\",\n });\n const [isSubmitting, setIsSubmitting] = useState(false);\n\n const handleChange = (\n e: React.ChangeEvent\n ) => {\n const { name, value, type } = e.target as HTMLInputElement;\n \n if (type === \"checkbox\") {\n const checked = (e.target as HTMLInputElement).checked;\n \n // Handle interest checkboxes specially\n if (name.startsWith(\"interest-\")) {\n const interestId = name.replace(\"interest-\", \"\");\n const interestLabel = INTEREST_OPTIONS.find(opt => opt.id === interestId)?.label || \"\";\n \n setFormData(prev => {\n if (checked) {\n // Add to interests array if not already present\n return {\n ...prev,\n interests: prev.interests.includes(interestLabel) \n ? prev.interests \n : [...prev.interests, interestLabel]\n };\n } else {\n // Remove from interests array\n return {\n ...prev,\n interests: prev.interests.filter(i => i !== interestLabel)\n };\n }\n });\n } else {\n // Handle other checkboxes normally\n setFormData(prev => ({ ...prev, [name]: checked }));\n }\n } else {\n setFormData(prev => ({ ...prev, [name]: value }));\n }\n };\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setIsSubmitting(true);\n\n try {\n const response = await fetch(\"/submit\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(formData),\n });\n\n const result = await response.json();\n\n if (response.ok && result.success) {\n onSubmitSuccess();\n window.scrollTo({ top: 0, behavior: \"smooth\" });\n } else {\n onSubmitError(result.message || \"Something went wrong. Please try again.\");\n setIsSubmitting(false);\n }\n } catch (error) {\n onSubmitError(\"Network error. Please check your connection and try again.\");\n setIsSubmitting(false);\n }\n };\n\n // Helper function to check if an interest is selected\n const isInterestSelected = (interestLabel: string) => {\n return formData.interests.includes(interestLabel);\n };\n\n return (\n

\n \n Name *\n \n \n

\n\n

\n \n Email *\n \n \n

\n\n

\n \n Company (optional)\n \n \n

\n\n

\n \n Personal Website (optional)\n \n \n

\n\n {/* Event Interests Section */}\n

\n What would you like to see at the event?\n

\n {INTEREST_OPTIONS.map(option => (\n

\n \n \n {option.label}\n \n

\n ))}\n \n

\n \n Other suggestions or topics you'd like to see:\n \n \n

\n\n

\n \n \n I'd like to give a 90-second lightning talk\n \n

\n Share your Val Town project, idea, or experience in a quick lightning talk!\n

\n\n {formData.isSpeaker && (\n <>\n

\n \n Val Town Username *\n \n \n

\n\n

\n \n What would you like to talk about? *\n \n \n \n

\n \n )}\n\n

\n \n {isSubmitting \n ? \"Submitting...\" \n : formData.isSpeaker \n ? \"Submit Speaker Application\" \n : \"Register for Event\"}\n \n

\n );\n}",[],[151,171,197],{"_103":206,"_95":207,"_152":208,"_154":172,"_155":137,"_156":136,"_158":159,"_105":209,"_100":32,"_162":182,"_164":210,"_165":22,"_166":-5,"_167":211,"_98":212},"d4d46bf4-4d1b-11f0-a74e-76b3cceeab13","CancellationMessage.tsx","d4d46cda-4d1b-11f0-a74e-76b3cceeab13",["D",1750344237852],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nexport function CancellationMessage() {\n return (\n

\n We've decided to postpone this event\n

\n We want to make sure we have more exciting updates and features to share with you all.\n

\n We'll be hosting another Val Town Hall in a couple of months when we have more to show. \n Stay tuned for the announcement!\n

Thanks for your interest in Val Town! 🏘️

\n );\n}",[],[151,171,207],{"_103":214,"_95":215,"_152":216,"_154":172,"_155":137,"_156":217,"_158":159,"_105":218,"_100":219,"_162":182,"_164":220,"_165":22,"_166":-5,"_167":221,"_98":222},"8837f912-407f-11f0-96c9-76b3cceeab13","ErrorMessage.tsx","bc167f18-3005-11f0-8087-569c3dd06744",100,["D",1748957693879],2,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\ninterface ErrorMessageProps {\n message: string;\n onDismiss: () => void;\n}\n\nexport function ErrorMessage({ message, onDismiss }: ErrorMessageProps) {\n return (\n \n Oops!\n {message}\n \n ×\n \n \n );\n}",[],[151,171,215],{"_103":224,"_95":225,"_152":226,"_154":172,"_155":137,"_156":136,"_158":159,"_105":227,"_100":228,"_162":182,"_164":229,"_165":22,"_166":-5,"_167":230,"_98":231},"d4d4894a-4d1b-11f0-a74e-76b3cceeab13","EventDetails.tsx","9c71c38e-3005-11f0-ba57-569c3dd06744",["D",1750344237852],9,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nexport function EventDetails() {\n return (\n

\n \n Event Cancelled\n \n

\n Date: Wednesday, June 25\n
\n Time: 12pm ET\n
\n Location:{\" \"}\n Virtual (Zoom or Discord)\n

\n );\n}",[],[151,171,225],{"_103":233,"_95":234,"_152":235,"_154":172,"_155":137,"_156":236,"_158":159,"_105":237,"_100":238,"_162":182,"_164":239,"_165":22,"_166":-5,"_167":240,"_98":241},"8650cf48-407f-11f0-9551-76b3cceeab13","ThankYouMessage.tsx","abe47c1c-3005-11f0-8087-569c3dd06744",99,["D",1748957690686],3,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nexport function ThankYouMessage() {\n return (\n

🎉

\n Thanks for registering!\n

\n We're looking forward to seeing you at the event!\n

\n If you applied to speak, we'll be in touch about your talk soon.\n

\n );\n}",[],[151,171,234],[151,171],{"_103":244,"_95":245,"_152":246,"_154":153,"_155":137,"_156":247,"_158":159,"_105":248,"_100":161,"_162":249,"_164":250,"_165":22,"_166":-5,"_167":251,"_98":252},"bc03a9c8-3006-11f0-bd2b-569c3dd06744","index.html","8d08d838-3005-11f0-865b-569c3dd06744",68,["D",1747146593069],"file","\n\n \n \n \n Val Town Hall Speaker Application\n \n \n \n \n

\n \n \n",[],[151,245],{"_103":254,"_95":255,"_152":256,"_154":153,"_155":137,"_156":257,"_158":159,"_105":258,"_100":161,"_162":182,"_164":259,"_165":22,"_166":-5,"_167":260,"_98":261},"cd215800-3005-11f0-8978-569c3dd06744","index.tsx","8fbcdaac-3005-11f0-84ea-569c3dd06744",51,["D",1747146192284],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client?deps=react@18.2.0,react-dom@18.2.0\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = createRoot(document.getElementById(\"app\")!);\nroot.render();",[],[151,255],[151],{"_103":264,"_95":99,"_152":265,"_154":-5,"_155":137,"_156":136,"_158":159,"_105":266,"_100":267,"_162":249,"_164":268,"_165":22,"_166":-5,"_167":269,"_98":270},"d4d476b2-4d1b-11f0-a74e-76b3cceeab13","8323ef42-3000-11f0-abaf-569c3dd06744",["D",1750344237852],8,"# Val Town Hall - Event Cancelled\n\n~~A simple form for collecting attendee registrations and speaker applications for the Val Town Hall event.~~\n\n**This event has been cancelled.** We've decided to postpone the Val Town Hall to a later date when we have more exciting updates and features to share. We'll be hosting another event in a couple of months - stay tuned for the announcement!\n\n## Current Status\n\n**Event Cancelled** - The Val Town Hall originally scheduled for Wednesday, June 25 at 12pm ET has been cancelled. The registration form has been replaced with a cancellation notice.\n\n## Historical Features\n\nThe original registration system included:\n\n- Clean, modern form design\n- Supports both general attendee registration and speaker applications\n- Collects attendee interests and preferences for event content\n- SQLite database storage for all submissions\n- Email notifications for new submissions\n- Mobile-responsive design\n- Client-side validation\n- Available in both HTML and React versions\n- Admin dashboard for viewing attendees and speakers\n\n## Project Structure\n\n- `/frontend/` - React implementation\n - `/frontend/index.html` - HTML container for React app\n - `/frontend/index.tsx` - React entry point\n - `/frontend/components/` - React components\n - `/frontend/components/AdminDashboard.tsx` - Admin dashboard component\n\n## How It Works\n\n1. The form collects attendee information including name, email, company (optional), and website (optional).\n2. Attendees can select what content they'd like to see at the event:\n - Q&A session with the Val Town Team\n - Demos of new features\n - Learn more about the Val Town roadmap\n - Breakout rooms to connect with fellow Val Town users\n - Custom suggestions via a text field\n3. Users can optionally apply to give a 90-second lightning talk by toggling the speaker option.\n4. If applying as a speaker, additional fields appear for Val Town username and talk description.\n5. On submission, the data is sent to the server endpoint.\n6. The server validates the data, stores it in SQLite, and sends an email notification.\n7. A thank you message is displayed to the user upon successful submission.\n\n## Admin Dashboard (Still Available)\n\nThe admin dashboard remains functional at `/admin` for viewing historical registration data from before the cancellation. The dashboard:\n\n1. Requires a password for authentication (set via the `ADMIN_PASSWORD` environment variable)\n2. Displays a list of all attendees and speakers\n3. Shows a summary with total counts\n4. Provides a table showing the popularity of each interest option\n5. Allows viewing detailed information about each registration\n6. Includes an email list tool for easily copying emails to Gmail\n\nTo access the admin dashboard:\n1. Navigate to `/admin` in your browser\n2. Enter the admin password when prompted\n3. View and manage all registrations\n\nThe interest popularity table helps organizers understand which topics are most requested by attendees, allowing for better planning of the event content.\n\nThe email list tool provides a convenient way to:\n- View all emails in a format ready for Gmail\n- Filter between all participants, attendees only, or speakers only\n- Copy the entire list to clipboard with one click\n\n## Database Schema\n\n```sql\nCREATE TABLE IF NOT EXISTS val_town_hall_attendees_v3 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n company TEXT,\n website TEXT,\n is_speaker BOOLEAN NOT NULL,\n username TEXT,\n talk_description TEXT,\n interests TEXT,\n interest_custom TEXT,\n created_at TEXT NOT NULL\n)\n```\n\nThe `interests` field stores a JSON array of selected interests.\n\n## Email Notifications\n\nEmail notifications are sent in plain text format and include all the information submitted through the form. Different email subjects are used depending on whether the submission is a general registration or a speaker application.",[],[99],{"_103":272,"_95":273,"_152":274,"_154":-5,"_155":137,"_156":275,"_158":159,"_105":276,"_100":277,"_162":278,"_164":279,"_165":22,"_166":96,"_167":280,"_98":281},"64b94d4c-407f-11f0-91b8-76b3cceeab13","index.ts","626b63e8-3000-11f0-8353-569c3dd06744",96,["D",1748957634327],16,"http","import { Hono } from \"https://esm.sh/hono@3.12.6\";\nimport { email } from \"https://esm.town/v/std/email\";\nimport { serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Initialize Hono app\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err) => {\n console.error(\"Hono error:\", err);\n throw err;\n});\n\n// Middleware to verify admin password\nconst verifyAdminPassword = async (c, next) => {\n const authHeader = c.req.header(\"Authorization\");\n\n if (!authHeader || !authHeader.startsWith(\"Bearer \")) {\n return c.json({ success: false, message: \"Unauthorized\" }, 401);\n }\n\n const password = authHeader.substring(7); // Remove \"Bearer \" prefix\n const adminPassword = Deno.env.get(\"ADMIN_PASSWORD\");\n console.log(password);\n\n if (!adminPassword || password !== adminPassword) {\n return c.json({ success: false, message: \"Invalid password\" }, 401);\n }\n\n await next();\n};\n\nconst TABLE_NAME = \"val_town_hall_2_attendees\";\n\n// Create the attendees table if it doesn't exist\nasync function initializeDatabase() {\n console.log(\"Initializing database...\");\n try {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n company TEXT,\n website TEXT,\n is_speaker BOOLEAN NOT NULL,\n username TEXT,\n talk_description TEXT,\n interests TEXT,\n interest_custom TEXT,\n created_at TEXT NOT NULL\n )\n `);\n console.log(\"Database initialized successfully\");\n } catch (error) {\n console.error(\"Database initialization error:\", error);\n throw error;\n }\n}\n\n// Initialize database on startup\ninitializeDatabase();\n\n// Serve React static files\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n// Serve the main page - using the React version\napp.get(\"/\", (c) => serveFile(\"/frontend/index.html\", import.meta.url));\n\n// Serve the admin page - also using the React version\napp.get(\"/admin\", (c) => serveFile(\"/frontend/index.html\", import.meta.url));\n\n// Handle form submissions\napp.post(\"/submit\", async (c) => {\n console.log(\"Received form submission request\");\n try {\n const formData = await c.req.json();\n console.log(\"Parsed form data:\", formData);\n\n // Extract form fields\n const {\n name,\n email: userEmail,\n company,\n website,\n isSpeaker,\n username,\n talkDescription,\n interests,\n interestCustom,\n } = formData;\n\n console.log(\"Extracted fields:\", {\n name,\n userEmail,\n company,\n website,\n isSpeaker,\n username,\n talkDescriptionLength: talkDescription?.length,\n interests,\n interestCustom,\n });\n\n // Validate required fields\n if (!name || !userEmail) {\n console.log(\"Validation failed - missing required fields\");\n return c.json(\n { success: false, message: \"Missing required fields\" },\n 400,\n );\n }\n\n // Validate speaker-specific fields if the user wants to speak\n if (isSpeaker && (!username || !talkDescription)) {\n console.log(\"Validation failed - missing required speaker fields\");\n return c.json({\n success: false,\n message: \"Missing required speaker information\",\n }, 400);\n }\n\n // Get current timestamp\n const createdAt = new Date().toISOString();\n console.log(\"Created timestamp:\", createdAt);\n\n // Serialize interests array to JSON string\n const interestsJson = JSON.stringify(interests || []);\n\n // Insert into database\n console.log(\"Attempting to insert into database...\");\n try {\n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} \n (name, email, company, website, is_speaker, username, talk_description, \n interests, interest_custom, created_at) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n name,\n userEmail,\n company || null,\n website || null,\n isSpeaker ? 1 : 0,\n isSpeaker ? username : null,\n isSpeaker ? talkDescription : null,\n interestsJson,\n interestCustom || null,\n createdAt,\n ],\n );\n console.log(\"Database insert successful\");\n } catch (dbError) {\n console.error(\"Database error:\", dbError);\n throw dbError;\n }\n\n // Send email notification\n console.log(\"Sending email notification...\");\n try {\n const subject = isSpeaker\n ? \"New Val Town Hall Speaker Application\"\n : \"New Val Town Hall Attendee Registration\";\n\n let emailText = `\nNew ${isSpeaker ? \"speaker application\" : \"attendee registration\"} received:\n\nName: ${name}\nEmail: ${userEmail}\nCompany: ${company || \"Not provided\"}\nWebsite: ${website || \"Not provided\"}\n`;\n\n if (isSpeaker) {\n emailText += `\nVal Town Username: ${username}\nTalk Description:\n${talkDescription}\n`;\n }\n\n // Add interests section\n emailText += `\nInterests:\n${\n interests && interests.length > 0\n ? interests.map((interest) => `- ${interest}\\n`).join(\"\")\n : \"- No specific interests selected\\n\"\n }`;\n\n if (interestCustom) {\n emailText += `- Custom suggestion: ${interestCustom}\\n`;\n }\n\n emailText += `\nSubmitted at: ${createdAt}\n `;\n\n await email({\n subject,\n text: emailText,\n });\n console.log(\"Email notification sent successfully\");\n } catch (emailError) {\n console.error(\"Email sending error:\", emailError);\n // Continue even if email fails - we've already saved to database\n }\n\n console.log(\"Returning success response\");\n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error processing submission:\", error);\n return c.json({ success: false, message: \"Server error\" }, 500);\n }\n});\n\n// Admin API endpoint to fetch attendees and speakers data\napp.get(\"/api/admin/data\", verifyAdminPassword, async (c) => {\n try {\n // Fetch all attendees\n const attendees = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} WHERE is_speaker = 0 ORDER BY created_at DESC`,\n );\n\n // Fetch all speakers\n const speakers = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} WHERE is_speaker = 1 ORDER BY created_at DESC`,\n );\n\n // Return the data\n return c.json({\n success: true,\n data: {\n attendees: attendees.rows,\n speakers: speakers.rows,\n totalCount: attendees.rows.length + speakers.rows.length,\n },\n });\n } catch (error) {\n console.error(\"Error fetching admin data:\", error);\n return c.json({ success: false, message: \"Server error\" }, 500);\n }\n});\n\n// Export the Hono app\nexport default app.fetch;",[],[273],"files",[149,169,176,186,195,205,213,223,232,243,253,263,271],"counts",{"_286":32,"_287":238,"_288":32,"_289":161},"pulls","branches","forks","envVars","contents",[],{"_103":264,"_155":137,"_152":265,"_95":99,"_164":268,"_162":249,"_100":267,"_154":-5,"_105":293,"_156":136,"_166":-5,"_98":294},["D",1750344237852],[99],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_93":94,"_95":96,"_97":43,"_98":99,"_101":303,"_249":308,"_311":312,"_355":356,"_367":-7,"_368":32,"_369":22},{"_103":104,"_95":96,"_105":304,"_107":-5,"_108":22,"_109":110,"_111":-5,"_112":-5,"_14":113,"_114":-5,"_115":22,"_116":-5,"_117":32,"_16":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":305,"_131":306,"_134":307,"_146":22},["D",1747143312277],{"_93":94,"_129":130},{"_93":94,"_133":130},{"_100":136,"_95":43,"_103":137,"_138":104,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":96,"_145":94},{"_103":264,"_95":99,"_152":265,"_154":-5,"_155":137,"_156":136,"_158":159,"_105":309,"_100":267,"_162":249,"_164":268,"_165":22,"_166":-5,"_98":310},["D",1750344237852],[99],"history",[313,315,319,325,331,336,341,346,351],{"_103":264,"_155":137,"_152":265,"_95":99,"_164":268,"_162":249,"_100":267,"_154":-5,"_105":314,"_156":136,"_166":-5},["D",1750344237852],{"_103":316,"_155":137,"_152":265,"_95":99,"_164":317,"_162":249,"_100":191,"_154":-5,"_105":318,"_156":180,"_166":-5},"27fc81fa-34ca-11f0-8080-9e149126039e","# Val Town Hall Registration Form\n\nA simple form for collecting attendee registrations and speaker applications for the Val Town Hall event.\n\n## Features\n\n- Clean, modern form design\n- Supports both general attendee registration and speaker applications\n- Collects attendee interests and preferences for event content\n- SQLite database storage for all submissions\n- Email notifications for new submissions\n- Mobile-responsive design\n- Client-side validation\n- Available in both HTML and React versions\n- Admin dashboard for viewing attendees and speakers\n\n## Project Structure\n\n- `/frontend/` - React implementation\n - `/frontend/index.html` - HTML container for React app\n - `/frontend/index.tsx` - React entry point\n - `/frontend/components/` - React components\n - `/frontend/components/AdminDashboard.tsx` - Admin dashboard component\n\n## How It Works\n\n1. The form collects attendee information including name, email, company (optional), and website (optional).\n2. Attendees can select what content they'd like to see at the event:\n - Q&A session with the Val Town Team\n - Demos of new features\n - Learn more about the Val Town roadmap\n - Breakout rooms to connect with fellow Val Town users\n - Custom suggestions via a text field\n3. Users can optionally apply to give a 90-second lightning talk by toggling the speaker option.\n4. If applying as a speaker, additional fields appear for Val Town username and talk description.\n5. On submission, the data is sent to the server endpoint.\n6. The server validates the data, stores it in SQLite, and sends an email notification.\n7. A thank you message is displayed to the user upon successful submission.\n\n## Admin Dashboard\n\nThe application includes an admin dashboard that can be accessed at `/admin`. The dashboard:\n\n1. Requires a password for authentication (set via the `ADMIN_PASSWORD` environment variable)\n2. Displays a list of all attendees and speakers\n3. Shows a summary with total counts\n4. Provides a table showing the popularity of each interest option\n5. Allows viewing detailed information about each registration\n6. Includes an email list tool for easily copying emails to Gmail\n\nTo access the admin dashboard:\n1. Navigate to `/admin` in your browser\n2. Enter the admin password when prompted\n3. View and manage all registrations\n\nThe interest popularity table helps organizers understand which topics are most requested by attendees, allowing for better planning of the event content.\n\nThe email list tool provides a convenient way to:\n- View all emails in a format ready for Gmail\n- Filter between all participants, attendees only, or speakers only\n- Copy the entire list to clipboard with one click\n\n## Database Schema\n\n```sql\nCREATE TABLE IF NOT EXISTS val_town_hall_attendees_v3 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n company TEXT,\n website TEXT,\n is_speaker BOOLEAN NOT NULL,\n username TEXT,\n talk_description TEXT,\n interests TEXT,\n interest_custom TEXT,\n created_at TEXT NOT NULL\n)\n```\n\nThe `interests` field stores a JSON array of selected interests.\n\n## Email Notifications\n\nEmail notifications are sent in plain text format and include all the information submitted through the form. Different email subjects are used depending on whether the submission is a general registration or a speaker application.",["D",1747670330728],{"_103":320,"_155":137,"_152":265,"_95":99,"_164":321,"_162":249,"_100":322,"_154":-5,"_105":323,"_156":324,"_166":-5},"2f329320-300f-11f0-a83f-569c3dd06744","# Val Town Hall Registration Form\n\nA simple form for collecting attendee registrations and speaker applications for the Val Town Hall event.\n\n## Features\n\n- Clean, modern form design\n- Supports both general attendee registration and speaker applications\n- Collects attendee interests and preferences for event content\n- SQLite database storage for all submissions\n- Email notifications for new submissions\n- Mobile-responsive design\n- Client-side validation\n- Available in both HTML and React versions\n\n## Project Structure\n\n- `/frontend/` - React implementation\n - `/frontend/index.html` - HTML container for React app\n - `/frontend/index.tsx` - React entry point\n - `/frontend/components/` - React components\n\n## How It Works\n\n1. The form collects attendee information including name, email, company (optional), and website (optional).\n2. Attendees can select what content they'd like to see at the event:\n - Q&A session with the Val Town Team\n - Demos of new features\n - Learn more about the Val Town roadmap\n - Breakout rooms to connect with fellow Val Town users\n - Custom suggestions via a text field\n3. Users can optionally apply to give a 90-second lightning talk by toggling the speaker option.\n4. If applying as a speaker, additional fields appear for Val Town username and talk description.\n5. On submission, the data is sent to the server endpoint.\n6. The server validates the data, stores it in SQLite, and sends an email notification.\n7. A thank you message is displayed to the user upon successful submission.\n\n## Database Schema\n\n```sql\nCREATE TABLE IF NOT EXISTS val_town_hall_attendees_v3 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n company TEXT,\n website TEXT,\n is_speaker BOOLEAN NOT NULL,\n username TEXT,\n talk_description TEXT,\n interests TEXT,\n interest_custom TEXT,\n created_at TEXT NOT NULL\n)\n```\n\nThe `interests` field stores a JSON array of selected interests.\n\n## Email Notifications\n\nEmail notifications are sent in plain text format and include all the information submitted through the form. Different email subjects are used depending on whether the submission is a general registration or a speaker application.",6,["D",1747150222284],91,{"_103":326,"_155":137,"_152":265,"_95":99,"_164":327,"_162":249,"_100":328,"_154":-5,"_105":329,"_156":330,"_166":-5},"f2bdabbe-300e-11f0-ba32-569c3dd06744","# Val Town Hall Registration Form\n\nA simple form for collecting attendee registrations and speaker applications for the Val Town Hall event.\n\n## Features\n\n- Clean, modern form design\n- Supports both general attendee registration and speaker applications\n- Collects attendee interests and preferences for event content\n- SQLite database storage for all submissions\n- Email notifications for new submissions\n- Mobile-responsive design\n- Client-side validation\n- Available in both HTML and React versions\n\n## Project Structure\n\n- `/frontend/` - React implementation\n - `/frontend/index.html` - HTML container for React app\n - `/frontend/index.tsx` - React entry point\n - `/frontend/components/` - React components\n\n## How It Works\n\n1. The form collects attendee information including name, email, company (optional), and website (optional).\n2. Attendees can select what content they'd like to see at the event (Q&A, demos, roadmap) and suggest custom topics.\n3. Users can optionally apply to give a 90-second lightning talk by toggling the speaker option.\n4. If applying as a speaker, additional fields appear for Val Town username and talk description.\n5. On submission, the data is sent to the server endpoint.\n6. The server validates the data, stores it in SQLite, and sends an email notification.\n7. A thank you message is displayed to the user upon successful submission.\n\n## Database Schema\n\n```sql\nCREATE TABLE IF NOT EXISTS val_town_hall_attendees_v2 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n company TEXT,\n website TEXT,\n is_speaker BOOLEAN NOT NULL,\n username TEXT,\n talk_description TEXT,\n interest_qa BOOLEAN,\n interest_demos BOOLEAN,\n interest_roadmap BOOLEAN,\n interest_custom TEXT,\n created_at TEXT NOT NULL\n)\n```\n\n## Email Notifications\n\nEmail notifications are sent in plain text format and include all the information submitted through the form. Different email subjects are used depending on whether the submission is a general registration or a speaker application.",5,["D",1747150120858],87,{"_103":332,"_155":137,"_152":265,"_95":99,"_164":333,"_162":249,"_100":201,"_154":-5,"_105":334,"_156":335,"_166":-5},"7df0ee14-300d-11f0-9563-569c3dd06744","# Val Town Hall Registration Form\n\nA simple form for collecting attendee registrations and speaker applications for the Val Town Hall event.\n\n## Features\n\n- Clean, modern form design\n- Supports both general attendee registration and speaker applications\n- SQLite database storage for all submissions\n- Email notifications for new submissions\n- Mobile-responsive design\n- Client-side validation\n- Available in both HTML and React versions\n\n## Project Structure\n\n- `/frontend/` - React implementation\n - `/frontend/index.html` - HTML container for React app\n - `/frontend/index.tsx` - React entry point\n - `/frontend/components/` - React components\n\n## How It Works\n\n1. The form collects attendee information including name, email, company (optional), and website (optional).\n2. Users can optionally apply to give a 90-second lightning talk by toggling the speaker option.\n3. If applying as a speaker, additional fields appear for Val Town username and talk description.\n4. On submission, the data is sent to the server endpoint.\n5. The server validates the data, stores it in SQLite, and sends an email notification.\n6. A thank you message is displayed to the user upon successful submission.\n\n## Database Schema\n\n```sql\nCREATE TABLE IF NOT EXISTS val_town_hall_attendees (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n company TEXT,\n website TEXT,\n is_speaker BOOLEAN NOT NULL,\n username TEXT,\n talk_description TEXT,\n created_at TEXT NOT NULL\n)\n```\n\n## Email Notifications\n\nEmail notifications are sent in plain text format and include all the information submitted through the form. Different email subjects are used depending on whether the submission is a general registration or a speaker application.",["D",1747149495403],80,{"_103":337,"_155":137,"_152":265,"_95":99,"_164":338,"_162":249,"_100":238,"_154":-5,"_105":339,"_156":340,"_166":-5},"7f12f2b2-3006-11f0-be21-569c3dd06744","# Val Town Hall Speaker Application Form\n\nA simple form for collecting speaker applications for the Val Town Hall event.\n\n## Features\n\n- Clean, modern form design\n- SQLite database storage for all submissions\n- Email notifications for new submissions\n- Mobile-responsive design\n- Client-side validation\n- Available in both HTML and React versions\n\n## Project Structure\n\n- `/frontend/` - React implementation\n - `/frontend/index.html` - HTML container for React app\n - `/frontend/index.tsx` - React entry point\n - `/frontend/components/` - React components\n\n## How It Works\n\n1. The form collects speaker information including name, email, Val Town username, company (optional), website (optional), and talk description.\n2. On submission, the data is sent to the server endpoint.\n3. The server validates the data, stores it in SQLite, and sends an email notification.\n4. A thank you message is displayed to the user upon successful submission.\n\n## Database Schema\n\n```sql\nCREATE TABLE IF NOT EXISTS val_town_hall_speakers (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n username TEXT NOT NULL,\n company TEXT,\n website TEXT,\n talk_description TEXT NOT NULL,\n created_at TEXT NOT NULL\n)\n```\n\n## Email Notifications\n\nEmail notifications are sent in plain text format and include all the information submitted through the form.",["D",1747146490829],66,{"_103":342,"_155":137,"_152":265,"_95":99,"_164":343,"_162":249,"_100":219,"_154":-5,"_105":344,"_156":345,"_166":-5},"7c360a66-3006-11f0-be21-569c3dd06744","# Val Town Hall Speaker Application Form\n\nA simple form for collecting speaker applications for the Val Town Hall event.\n\n## Features\n\n- Clean, modern form design\n- SQLite database storage for all submissions\n- Email notifications for new submissions\n- Mobile-responsive design\n- Client-side validation\n- Available in both HTML and React versions\n\n## Project Structure\n\n- `/frontend/` - React implementation\n - `/frontend/index.html` - HTML container for React app\n - `/frontend/index.tsx` - React entry point\n - `/frontend/components/` - React components\n\n## How It Works\n\n1. The form collects speaker information including name, email, Val Town username, company (optional), website (optional), and talk description.\n2. On submission, the data is sent to the server endpoint.\n3. The server validates the data, stores it in SQLite, and sends an email notification.\n4. A thank you message is displayed to the user upon successful submission.\n\n## Database Schema\n\n```sql\nCREATE TABLE IF NOT EXISTS val_town_hall_speakers (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n username TEXT NOT NULL,\n company TEXT,\n website TEXT,\n talk_description TEXT NOT NULL,\n created_at TEXT NOT NULL\n)\n```\n\n## Email Notifications\n\nEmail notifications are sent in plain text format and include all the information submitted through the form.\n\n## Accessing the Application\n\n- `/` - React version of the application (default)\n- `/original` - Original HTML/CSS/JS version of the application",["D",1747146486024],65,{"_103":347,"_155":137,"_152":265,"_95":99,"_164":348,"_162":249,"_100":161,"_154":-5,"_105":349,"_156":350,"_166":-5},"c93c44f2-3005-11f0-8087-569c3dd06744","# Val Town Hall Speaker Application Form\n\nA simple form for collecting speaker applications for the Val Town Hall event.\n\n## Features\n\n- Clean, modern form design\n- SQLite database storage for all submissions\n- Email notifications for new submissions\n- Mobile-responsive design\n- Client-side validation\n- Available in both HTML and React versions\n\n## Project Structure\n\n- `/index.ts` - Main HTTP handler with form submission endpoint\n- `/frontend/` - Original HTML/CSS/JS implementation\n - `/frontend/index.html` - Main HTML page with the form\n - `/frontend/style.css` - CSS styling\n - `/frontend/script.js` - JavaScript for form handling\n- `/frontend-react/` - React implementation\n - `/frontend-react/index.html` - HTML container for React app\n - `/frontend-react/index.tsx` - React entry point\n - `/frontend-react/components/` - React components\n\n## How It Works\n\n1. The form collects speaker information including name, email, Val Town username, company (optional), website (optional), and talk description.\n2. On submission, the data is sent to the server endpoint.\n3. The server validates the data, stores it in SQLite, and sends an email notification.\n4. A thank you message is displayed to the user upon successful submission.\n\n## Database Schema\n\n```sql\nCREATE TABLE IF NOT EXISTS val_town_hall_speakers (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n username TEXT NOT NULL,\n company TEXT,\n website TEXT,\n talk_description TEXT NOT NULL,\n created_at TEXT NOT NULL\n)\n```\n\n## Email Notifications\n\nEmail notifications are sent in plain text format and include all the information submitted through the form.\n\n## Accessing the Application\n\n- `/` - React version of the application (default)\n- `/original` - Original HTML/CSS/JS version of the application",["D",1747146185754],50,{"_103":352,"_155":137,"_152":265,"_95":99,"_164":353,"_162":249,"_100":32,"_154":-5,"_105":354,"_156":328,"_166":-5},"8323ee7a-3000-11f0-abaf-569c3dd06744","# Val Town Hall Speaker Application Form\n\nA simple, animated form for collecting speaker applications for the Val Town Hall event.\n\n## Features\n\n- Clean, modern form with subtle animations\n- SQLite database storage for all submissions\n- Email notifications for new submissions\n- Mobile-responsive design\n- Client-side validation\n\n## Project Structure\n\n- `/index.ts` - Main HTTP handler with form submission endpoint\n- `/frontend/index.html` - Main HTML page with the form\n- `/frontend/style.css` - CSS styling and animations\n- `/frontend/script.js` - JavaScript for form handling and animations\n\n## How It Works\n\n1. The form collects speaker information including name, email, Val Town username, company (optional), website (optional), and talk description.\n2. On submission, the data is sent to the server endpoint.\n3. The server validates the data, stores it in SQLite, and sends an email notification.\n4. A thank you message is displayed to the user upon successful submission.\n\n## Database Schema\n\n```sql\nCREATE TABLE IF NOT EXISTS val_town_hall_speakers (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n username TEXT NOT NULL,\n company TEXT,\n website TEXT,\n talk_description TEXT NOT NULL,\n created_at TEXT NOT NULL\n)\n```\n\n## Email Notifications\n\nEmail notifications are sent in plain text format and include all the information submitted through the form.",["D",1747143920670],"versions",[357,359,360,361,362,363,364,365,366],{"_249":313,"_358":315},"previous",{"_249":315,"_358":319},{"_249":319,"_358":325},{"_249":325,"_358":331},{"_249":331,"_358":336},{"_249":336,"_358":341},{"_249":341,"_358":346},{"_249":346,"_358":351},{"_249":351,"_358":-5},"versionNumber","page","hasNext","actionData","errors"]

History for README.md