Someone fills out a form, it makes a new record. Can it update existing?

Topic Labels: Base design
730 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a table that is basically a homework submission table. I made a form for it.

Say a record lists the assignment (Homework #1) and I have 3 records for this. One each for Peter, Paul, and Mary.

My idea was that they would submit the form, pick Homework #1 and their name from the dropdown, and that when they finished submitting it, that record would go into the record that was waiting. Instead, it maks a new record.

How could I have that information go into the existing record?

1 Reply 1
8 - Airtable Astronomer
8 - Airtable Astronomer