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

Post author
Marko Guzvic

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!

 

Comments

3 comments

  • Comment author
    A J

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

    0
  • Comment author
    Marko Guzvic

    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
  • Comment author
    A J

    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.