Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: I am trying to set an automation but it's not working

Solved
Jump to Solution
175 0
cancel
Showing results for 
Search instead for 
Did you mean: 
tsallis
6 - Interface Innovator
6 - Interface Innovator

Hi 🙂
I am trying to set an automation that will update a specific field based on the information that is on another table. The field I want to update is called Relatorio as shown bellow.
I want to bring a field from another table that has the same number as the fiel (Item LV) from this table.

Captura de Tela 2025-02-11 às 15.49.05.png

Here is the picture from the table I want to retrieve the content from.
Captura de Tela 2025-02-11 às 15.49.13.png

I want to compare the ITEM LV from the first table and compare it to the ITEM from the last table and update the field RELATORIO from the first table with the content found on RESSALVA from the second. 

So every time ITEM = ITEM LV it should the update.

The first table should be completed with aaaa on the first line, ddddd on the second and eeee on the third line.

I setup the automation like this but it finds no records.


Captura de Tela 2025-02-11 às 15.57.49.png

Tks for the help

1 Solution

Accepted Solutions
Kenneth_Raghuna
8 - Airtable Astronomer
8 - Airtable Astronomer

Have you verified that the test record successfully loaded with a value for "Item LV"? In other words, does the "Find Records" test successfully show what it is looking for (it should be the Item LV value from the test record).

See Solution in Thread

5 Replies 5
Kenneth_Raghuna
8 - Airtable Astronomer
8 - Airtable Astronomer

Can you share some screenshots of the automation run history?

When records are created in Teste LV, are you craeting them from a form, or are you typing values directly into the table? If you're doing the latter, it is possible that the automation runs immediately when the record is created, before you submit the value in Item LV. If this is the case, the automation run history will show 'Find Records' action looking for records with a blank value in the Teste referencia table.

tsallis
6 - Interface Innovator
6 - Interface Innovator

I am not running the automation yet. When I test it, it brings zero results as if there were no records with the same number in the table I am trying to find the value. 

Imagine a table with the numbers from 1 to 10 in each line but the numbers are not in sequence and another table with also numbers from 1 to 10 but beside each number there is an animal name. I would like an automation that would populate the first table with the correspondent animal using as a reference the number beside it.

 

Kenneth_Raghuna
8 - Airtable Astronomer
8 - Airtable Astronomer

Have you verified that the test record successfully loaded with a value for "Item LV"? In other words, does the "Find Records" test successfully show what it is looking for (it should be the Item LV value from the test record).

DisraeliGears01
7 - App Architect
7 - App Architect

Depending on how you're using this base, you may also want to change the trigger for this automation from on Record Creation to something else. On Record Creation is when you create a new row, but the moment you create it, it usually lacks content and will give you an error. 

Oh, and from what it sounds like, have you tried using linked records among the tables instead of this automation? Then you could just use a lookup field.

I redid the automation and now it works. Thanks for the support!