Help

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

Topic Labels: Base design Views
557 1
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)? 

1 Reply 1
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!