Val Town Hall Registration Form

A simple form for collecting attendee registrations and speaker applications for the Val Town Hall event.

• Clean, modern form design
• Supports both general attendee registration and speaker applications
• Collects attendee interests and preferences for event content
• SQLite database storage for all submissions
• Email notifications for new submissions
• Mobile-responsive design
• Client-side validation
• Available in both HTML and React versions
• Admin dashboard for viewing attendees and speakers

• /frontend/ - React implementation
  • /frontend/index.html - HTML container for React app
  • /frontend/index.tsx - React entry point
  • /frontend/components/ - React components
    • /frontend/components/AdminDashboard.tsx - Admin dashboard component

1. The form collects attendee information including name, email, company (optional), and website (optional).
2. Attendees can select what content they'd like to see at the event:
   • Q&A session with the Val Town Team
   • Demos of new features
   • Learn more about the Val Town roadmap
   • Breakout rooms to connect with fellow Val Town users
   • Custom suggestions via a text field
3. Users can optionally apply to give a 90-second lightning talk by toggling the speaker option.
4. If applying as a speaker, additional fields appear for Val Town username and talk description.
5. On submission, the data is sent to the server endpoint.
6. The server validates the data, stores it in SQLite, and sends an email notification.
7. A thank you message is displayed to the user upon successful submission.

The application includes an admin dashboard that can be accessed at /admin. The dashboard:

1. Requires a password for authentication (set via the ADMIN_PASSWORD environment variable)
2. Displays a list of all attendees and speakers
3. Shows a summary with total counts
4. Allows viewing detailed information about each registration

To access the admin dashboard:

1. Navigate to /admin in your browser
2. Enter the admin password when prompted
3. View and manage all registrations

CREATE TABLE IF NOT EXISTS val_town_hall_attendees_v3 (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT NOT NULL,
  email TEXT NOT NULL,
  company TEXT,
  website TEXT,
  is_speaker BOOLEAN NOT NULL,
  username TEXT,
  talk_description TEXT,
  interests TEXT,
  interest_custom TEXT,
  created_at TEXT NOT NULL
)

The interests field stores a JSON array of selected interests.

Email 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.