Description:
I am looking to create a photo contest application in Airtable for a pageant where users can view contestant profiles, vote for their favorite contestants, and manage the entire contest flow.
Setup
Contestant Profile Section: Each contestant can upload their photos, provide personal details (name, age, hometown, etc.), and add a bio. This section should display contestants’ information for voters to view.
Voting System: A voting mechanism where users can cast their votes for their favorite contestant. Each user can vote once per day, and votes should be tracked and counted in real-time.
Voting Results Dashboard: A dashboard for tracking and displaying current vote counts for each contestant, including graphs or charts for quick visualization.
Admin Panel: A panel for managing contestant entries, approving photos, and monitoring votes. It should also allow the admin to disqualify contestants or flag suspicious voting activity.
Voting Restrictions: Ensure that each user can vote only once per day or per contest, and include any other necessary voting rules to prevent fraud.
Sponsor Section: A section to highlight contest sponsors, with their logos and details displayed alongside the contestants.
Contest Phases: A way to manage different phases of the contest (e.g., photo submissions, voting period, final results), with date-based triggers for each phase.
how to set this up in Airtable, including which tables, columns, and automations would be needed?
