Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 19, 2019 02:57 AM
Hello!
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.
Feb 19, 2019 08:29 AM
When you make a form with a linked field, users of the form who do not have permission to access your base will not see anything in the linked records other than the name field:
Feb 19, 2019 08:29 AM
When you make a form with a linked field, users of the form who do not have permission to access your base will not see anything in the linked records other than the name field:
Feb 19, 2019 10:26 AM
That’s great! Is it also possible to prefill the linked field?
Feb 19, 2019 12:06 PM
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 ...
Feb 19, 2019 12:37 PM
I’m able to fill in numbers and text fields but I’m unsure how to fill linked fields
Feb 19, 2019 02:41 PM
Same way — you just have to make sure the text you attempt to prefill exactly matches the formatting of the name field in the linked record.
Feb 19, 2019 03:34 PM
Got it working. Thank you!