Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Search for a data record and enter further data there

Topic Labels: Data
Solved
Jump to Solution
229 2
cancel
Showing results for 
Search instead for 
Did you mean: 
user2100
6 - Interface Innovator
6 - Interface Innovator

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?

1 Solution

Accepted Solutions

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"

Pascal_Gallais_0-1727164824172.png

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)

Pascal_Gallais_1-1727164994102.png

Form Registration

Form is built on table "Registration update":

Pascal_Gallais_2-1727165062794.png

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":

Pascal_Gallais_3-1727165201475.png

Find recors in table registration with the same "registration_id":

Pascal_Gallais_4-1727165255936.png

Check if a record has been found:

Pascal_Gallais_5-1727165303789.png

If yes, update record in table "Registration":

Pascal_Gallais_6-1727165346377.png

Regards,

Pascal

 

See Solution in Thread

2 Replies 2

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"

Pascal_Gallais_0-1727164824172.png

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)

Pascal_Gallais_1-1727164994102.png

Form Registration

Form is built on table "Registration update":

Pascal_Gallais_2-1727165062794.png

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":

Pascal_Gallais_3-1727165201475.png

Find recors in table registration with the same "registration_id":

Pascal_Gallais_4-1727165255936.png

Check if a record has been found:

Pascal_Gallais_5-1727165303789.png

If yes, update record in table "Registration":

Pascal_Gallais_6-1727165346377.png

Regards,

Pascal

 

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

Screenshot 2024-09-24 at 5.53.46 PM.png

Screenshot 2024-09-24 at 5.53.48 PM.png

Lookup field setup:

Screenshot 2024-09-24 at 5.53.52 PM.png

Link to base