How to search an Airtable table with multiple Item IDs in Make when the formula only works for single ID lookups?

Marko Guzvic asked July 02, 2024 22:12

Answered

Can someone please help me with MAKE?
Need to search Airtable table with 5 Item IDs to get all 5 items matching those IDs.
How do I structure the formula?
I've tried everything I could think of but it's searching by just 1 ID for some reason..
Really would appreciate some help with this!

3 comments

A J July 02, 2024 22:13

Hey Marko Guzvic, its best if you could iterate the search 5 times for this dynamically using the IDs.

0
Marko Guzvic OP July 02, 2024 22:13

I’ve been trying to do that as well but no luck. Never used iterator before. Could you explain shortly how I would go about doing that? Thanks!

0
A J July 02, 2024 22:16
A detailed setup showcase for this:
Marko Guzvic You can use this setup instead.
1. Webhook module has the category information
2. Set a variable which creates an array of all the category variables that you want to fetch airtable records for
3. Set an iterator module to iterate through each element of the category array
4. For showcase, I have set the last module as a variable module, in your case you need to setup an Airtable search module where the search formula will be {field name} = 'Value from the iterator'
The result will be as you require, i.e. the airtable category record and you can then link the result to the webflow items.

https://memberstack.slack.com/files/U05SLAL5X9V/F06SVK1GGJ3/aj_-_screenshare_-_2024-04-08_7_56_21_pm.mp4
0

Please sign in to leave a comment.