I would like to set up a sort of competition. For example, let’s say I would like to keep track of the number of pushups someone does and reward the person with the most push-ups (assume that no one will lie). I was thinking of the following setup. One table hosting the user’s information, and a second table that contains entries for every single day. I can’t really do a normal linked column because that reveals all of the information of the other participants when I make a form. I tried doing something using the incrementing number field on the users table and then having an ID column on the pushups table but I can’t really find a way to do something like
SELECT * FROM pushups WHERE ID=1. Is this too complex for Airtable?
I can provide any more information if you need. Thanks
Solved! Go to Solution.
Yes it is:
When making an Airtable form, you can use prefill_ parameters in the URL of the form to prefill specific fields. Find the URL for the form you wish to prefill. Once you get the form URL, you can ...