Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Looking to create a viewable leaderboard that's linked to a form

Topic Labels: Base design Views
1400 2
cancel
Showing results for 
Search instead for 
Did you mean: 
emma_c
4 - Data Explorer
4 - Data Explorer

I'm looking to create a leaderboard that's linked to a form customers can submit whenever they complete some action. Each logged action gets counted as 1 point, and moves the individual up or down the leaderboard. So I guess this has two components: A form and a leaderboard that updates in real-time based on how many actions each individual has logged. Any ideas for how I can accomplish this in Airtable?

I'm also a bit stuck on this: When someone fills out the form to log an action, how can I make sure each submission is linked to their specific record in our leaderboard (rather than it creating a new record each time they submit)? 

2 Replies 2
Airbid
6 - Interface Innovator
6 - Interface Innovator

create a user, form and leaderboard table. Have the form only be submittable if the user is logged into Airtable (log responses). When a form is submitted, create an automation that maps created by -> create / update user, and add a record to leaderboard. Pretty simple!

Does this solution only work if every customer is an airtable user? Is there a solution where the customer doesn't have to create an airtable login?