Setting Up a Competition?

#1

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

0 Likes

#2

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:

1 Like

#3

That’s great! Is it also possible to prefill the linked field?

0 Likes

#4

Yes it is:

0 Likes

#5

I’m able to fill in numbers and text fields but I’m unsure how to fill linked fields

0 Likes

#6

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.

0 Likes

#7

Got it working. Thank you!

0 Likes