Search for a data record and enter further data there

[user2100]

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?

[Pascal_Gallais- · Accepted solution]

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

[TheTimeSavingCo]

If everything's linked up you could also try using a lookup field to display the latest form submission data too:

Lookup field setup:

Link to base