Edit cells only with a form

Topic Labels: Automations Data
334 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hello. I am new to airtable.


I have created a base for a gymnastics club to enter competition scores.


I would like to be able to create a form where the "name" field would be a drop-down list that would allow the judges to update the gymnasts' scores. Without changing the names, the category or the club. Just the scores by apparatus but I am blocked.

1 Reply 1
18 - Pluto
18 - Pluto

Hm, each form submission will create a new record, leaving you with something like the following:

Screenshot 2023-03-14 at 12.27.57 PM.png

Screenshot 2023-03-14 at 12.27.53 PM.png

Screenshot 2023-03-14 at 12.27.49 PM.png

Link to base


You could then create lookup fields in the 'People' table to display the scores if you'd like? 

Screenshot 2023-03-14 at 12.28.47 PM.png
You can also check out this support article about updating records via form submissions to see if it helps