Skip to main content

Hi there,



I am trying to use an automation with the following setup :





  • Trigger : When a record is created (in Table 1)


  • Action 1 : Find record (in Table 2), where Name = Field 1 from Trigger


  • Action 2 : Update record (in Table 1), with Record ID = Airtable Record ID from Trigger




In this action 2, I am trying to update several fields using field values from Action 1.



However, I noticed that the automation is only working when ALL fields from Action 1 used in Action 2 are not empty. If at least one of these fields is empty, the automation will fail with the following error message : Failed to construct the value for “Fields”.



I suspect that the Find Record action only bring fields with non empty data and ignore the others.



Is it the expected behaviour ? Any workaround that doesn’t involve creating a formula field for each field that I am trying to get the value from in Action 2 (because I really have a lot of them) ?



Thanks.

You'll need to setup a dynamic find request by scrolling to the right of the Find Action step, and clicking on the little gear icon. Then you can setup a repeating action to loop through the found results.

Alternatively, you can do this with Make's advanced automations for Airtable. If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread.

For example, here is one of the ways that you could instantly trigger a Make automation from Airtable.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld


Reply