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)?
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!