Re: Integromat - search records - Arrays with multi records

1059 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I am trying to retrieve several records for which I know the ID but not the number of records:

I tried to use Airtable’s search records but I don’t know how to fill in the Formula part :

Can you help me ?

1 Reply 1

Each Airtable record has a unique ID, so searching by an ID will always return a single record, never multiple records. If you have three IDs, those relate to three records.

As explained in the text below that field, it needs to be a valid Airtable formula, the same type of formula you would create directly in a formula field. The advantage here, though, is that you can insert data from previous steps in the scenario. For example, if a previous step outputs a record ID, you could use something like this:

RECORD_ID() = "insert record ID data from previous step here"

For any record where its ID matches the ID from your previous step, it will be collected and passed on to the next step.