Creating Interations From Multiple Arrays

[dilipborad]

Hello,
Use filterByFormula API Function with Airtable’s original functions.

Check some reference posts of articles about how to use filterByFormula.
Posts in Make Community:

AirTable module formula error

What are you trying to achieve? I have a webhook that receives an email address. I have two Airtable tables: Customers and Accounts. They have a one-to-one relationship and link fields have been setup correctly between the two. In Accounts, I have the following fields: Email (from Customers) - a lookup field Expiry - a date field storing dates in DD/MM/YYYY format Credits - a number field I’m trying to Search for a Record using an Airtable module in Make where the email equals the email con…

Airtable: Column ID & Search Formula

I am trying to automate the capture of my inventory in Airtable. I am using the Airtable Upsert module to either create a new record or update the existing. I am using my SKU as the identifier and its the primary field in my table. With Upsert I need to identify a Record ID or else it will create a new record. OK, search for the record in my table using the SKU to get the Record ID. I’ve encountered two things that I can find no explanation for in the Make.com documentation (which is something …

Other Posts:

Airtable Web API - Using filterByFormula or sort parameters

https://community.airtable.com/t5/development-apis/how-to-search-for-specific-value-through-api-filterbyformula/td-p/116189

Is there a way to use filterByFormula in Airtable to filter by a specific field value by date without it defaulting to the first entry in the table?