search for multiple records in airtable

[edwardzev]

Hello,

I am trying to build automation which will search for records in airtable that have curtain "invoice number" and check them as closed.
Airtable set up is here

The problem is that one invoice number can appear in different records.
So Search record give you some number of records. With all the data related to this record.
How I fetch those records and update them to "Invoice closed."

 

[Supreme]

Hey @edwardzev

Can you share the name of the workflow in which you are having such an issue so that we can look into it and can guide you accordingly?

 

[edwardzev]

closing invoice
This is the name of the workflow.
Step 7 - finds all records that have specific invoice number in curtain.
Step 8 - with line itemizer I manage to extract to records IDs of all relevant records.
Now, how do I update curtain feild in all those records?

​

 

[Supreme]

Hey @edwardzev

In the Airtable action step, there is no line Item support, so to pass the multiple line item you need to use the Iterator action step.