Help

photo contest application in Airtable

Topic Labels: Base design
296 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Sanjiovani
5 - Automation Enthusiast
5 - Automation Enthusiast

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

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

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

  3. Voting Results Dashboard: A dashboard for tracking and displaying current vote counts for each contestant, including graphs or charts for quick visualization.

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

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

  6. Sponsor Section: A section to highlight contest sponsors, with their logos and details displayed alongside the contestants.

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

1 Reply 1

Hey @Sanjiovani! Your basic setup should def include:
User Table
Photos Table
Votes Table
Sponsors Table (might or might not be needed)
Contests Table (if you are planning to use this system for multiple contests throughout time).
Formulas and Rollups will be needed to handle Voting Restrictions.

Furthermore, depending on how robust this needs to be, you might want to create a user-portal solution (connected to your Airtable base) using Softr, Noloco, Fillout, or any other similar solution.

I've built some relatable projects lately (using the above mentioned systems in addition to Airtable), and would be happy to hop on a brief call if you believe that would be helpful.

Mike, Consultant @ Automatic Nation