Search records in Airtable from Integromat


#1

I am trying to search for records in Airtable from Integromat and unable to figure out how.
I have created a scenario where I get a unique id to be searched for in Airtable via a webhook. After linking the webhook to Airtable, I selected the option “Search records”. There is a field called “Formula” and I am not able to figure out what it means.


#2

Here’s what Airtable’s API documentation says about ‘Filter by formula’:

filterByFormula: string: optional

A formula used to filter records. The formula will be evaluated for each record, and if the result is not 0, false, “”, NaN, [], or #Error! the record will be included in the response.

If combined with view, only records in that view which satisfy the formula will be returned.

For example, to only include records where Name isn’t empty, pass in: NOT({Name} = ‘’)

It also directs users to the main Airtable formula reference page for additional information.


#3

Thanks for the link @W_Vann_Hall.

Basically I want to retrieve the records that match the field “Customer ID”.

From the API reference page I am not able to figure out how to compare a string that I have received from webhook with the field “Customer ID”. Any idea how to do it?


#4

did you manage to make it work? I tried integromat and had similair problems. compared to zapier setup is much harder.


#5

Yup I was able to make it work. Thanks for checking in.
I wrote a tutorial for Google Sheets and the steps are same for Airtable as well.


#6

@Sridhar_Rajendran
What exactly was your formula? That’s the part I’m having some issues with.

UPDATE: Nevermind, I just got it to work!


#7

That’s a great write-up of the process, BTW. I’ve been struggling¹ with automating some processes with Integromat, and I think you’ve lit enough of a fire under me to send me back to the task.


  1. By ‘struggling,’ I mean, 'trying not to have to read the documentation — but at least there is documentation, thankfully, and not just improvised tutorials on YouTube…