Community Interest Email Capture App

Transform the current talk submission system into a community interest collection platform that captures potential organizers and attendees for location-based events.

• Dynamic routing: /SF, /LA, /NYC, etc.
• Location-specific branding: Each path displays the corresponding city name
• Customizable cover images: Full-width background images per location
• Fallback handling: Default page for unrecognized paths

Form Fields:

• Full Name (required)
• Email Address (required)
• Phone Number (optional)
• Interest Type (dropdown):
  • "I want to organize events"
  • "I want to attend events"
  • "Both organizing and attending"
• Additional Comments (optional text area)
• Location (auto-populated from URL path)

Form Behavior:

• Simple, clean design matching current aesthetic
• Immediate feedback on submission
• Email validation
• Duplicate email handling per location

Database Schema:

• Table: community_interest
• Fields:
  • id (primary key)
  • name (text)
  • email (text)
  • phone (text, nullable)
  • interest_type (text)
  • comments (text, nullable)
  • location (text)
  • created_at (timestamp)

Features:

• Protected admin route (/admin)
• View all submissions by location
• Filter by interest type
• Download CSV export functionality
• Basic analytics (total counts per location/type)

• Responsive design: Mobile-first approach
• Full-width cover images: Hero section with location imagery
• Minimal form design: Clean, accessible form styling
• Success states: Clear confirmation after submission
• Loading states: Form submission feedback

1. Visit location-specific URL (e.g., /SF)
2. See San Francisco-branded page with cover image
3. Fill out interest form
4. Submit and receive confirmation
5. Data stored in database

1. Visit /admin (protected)
2. View dashboard with all submissions
3. Filter by location or interest type
4. Download CSV export of selected data

• Maintain current Val Town architecture
• Use existing SQLite database approach
• Preserve simple deployment model
• Ensure mobile responsiveness
• Implement basic security for admin access

• Number of signups per location
• Organizer vs attendee interest ratio
• Email validation success rate
• Admin usage for data export

• Email notification system
• Location-specific customization admin
• Integration with event creation tools
• Automated follow-up sequences