I have a table with fixed license plates, the cars should be checked regularly and a form is filled out. When the form is submitted, all data from the form should be entered in the correct place in the table.
Example:
Registration number: ABC-123 in table
Vehicle inspection was carried out on a vehicle with a license plate (ABC-123) and now the data should be entered in the table where the license plate "ABC-123" is located. how do I do that?
Best answer by Pascal_Gallais-
Hello,
You can't directly update a record using an Airtable form, they are made to create new records. But you can have another table, with the same structure than the one you want to update, to get the data provided through the form and the set up an automation to update the "real table".
Here is an example to illustrate.
Table "Registration"
Primary key is the license plate
2 single select fields to decsribe the state on the interior on one hand and the state of the tyres on the other hand.
Table "Registration Update"
Same structure than table "Registration" (at least for the fields that we want to update through the form)
Form Registration
Form is built on table "Registration update":
Automation
When a record is created in table "Registration Update", we search for the corresponding record in table "Registration" and update it if found
Trigger: when a record is created in "Registration Update":
Find recors in table registration with the same "registration_id":
Check if a record has been found:
If yes, update record in table "Registration":
Regards,
Pascal
Hello,
You can't directly update a record using an Airtable form, they are made to create new records. But you can have another table, with the same structure than the one you want to update, to get the data provided through the form and the set up an automation to update the "real table".
Here is an example to illustrate.
Table "Registration"
Primary key is the license plate
2 single select fields to decsribe the state on the interior on one hand and the state of the tyres on the other hand.
Table "Registration Update"
Same structure than table "Registration" (at least for the fields that we want to update through the form)
Form Registration
Form is built on table "Registration update":
Automation
When a record is created in table "Registration Update", we search for the corresponding record in table "Registration" and update it if found
Trigger: when a record is created in "Registration Update":
Find recors in table registration with the same "registration_id":
Check if a record has been found:
If yes, update record in table "Registration":
Regards,
Pascal
+18If everything's linked up you could also try using a lookup field to display the latest form submission data too:
Lookup field setup:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
