Mar 29, 2018 06:15 AM
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.
Solved! Go to Solution.
Jun 30, 2019 02:18 PM
How? Can you share please for other people to see it too?
Oct 01, 2019 12:17 PM
the chatfuel tutorial you shared @Sridhar_Rajendran works with Google Sheets and not with Airtable. So this is not a response to the issue raised :slightly_smiling_face:
Anyone share what the filter formula looks like? I am using:
{Airtable Column Name}=variable
but it results in “The formula for filtering records is invalid: Unknown field names: false” :frowning:
update: got it to work. the formula needs to go in () and the variable needs to be defined as string ‘variable’.
here you go:
({Airtable Column Name}=‘variable’)
Oct 12, 2019 03:05 PM
Hoping someone can help me with this formula – I use Integromat to schedule moving my records between bases when a “Send” checkbox is checked (which has a corresponding “Send Last Modified” date field).
Right now, the first record in my scenario is a Watch Records trigger, where the Trigger Field is “Send Last Modified”.
I want to set it up so that I can trigger this with Webhooks instead, but I’m not sure what the formula would be to replicate the “Send is checked” but only include the new results from “Send Last Modified”.
Any help greatly appreciated!! Thank you!!!
Adam
May 28, 2020 09:54 PM
This is the true answer. UPVOTE!!!
May 29, 2020 03:27 AM
Hi @Sridhar_Rajendran and @Kristina_Traeger1
This is in response to your posts.
You would use thIs basic Integromat scenario and then you can expand on it to suit your own use case:
Airtable=> Watch Records only use this if you are not using an app before this one
Airtable=>Search Records
The formula:
{type keyword/unique ID} = “use the value/blue tag of the field name”. **use straight quotes
Use Router
Airtable=>Update Record. **secod branch, filter before the app: chose blue tag (ID) and Record Updates
Airtable=>Create Record **first branch, filter before app: chose blue tag (ID) and Exists
Here are screenshots to illustrate how to setup a basic scenario to a update and create records and how to setup Gmail module. You can add on and expand the scenario for your use case.
Images 5 and 6 shows how to setup the formula, you would just use your own unique key.
Hope this can help.
Mary Kay
Sep 10, 2020 05:11 PM
I tried this configuration and just about every other variation of it, and am still getting ‘The formula for filtering records is invalid: Invalid formula. Please check your formula text.’ Any other suggestions? When using your approach above it shows:
INPUT
And in other iterations: StateCode = AK (which I tested in Airtable directly as a formula column, and it evaluates correctly).
Any other suggestion would be much appreciated.
Sep 10, 2020 06:55 PM
Welcome to the community, @DKott1! :grinning_face_with_big_eyes: Two questions:
"AK"
vs “AK”
If you use the wrong type in Integromat, my gut says that wrong type will be passed to Airtable, and could be the cause of the error.
Is that exactly how the formula field looks in Integromat, parentheses included? If so, the parentheses shouldn’t be there, so perhaps that’s causing a hiccup of some kind.
Sep 11, 2020 09:32 AM
Double quotes and removing the parentheses worked … thank you so much!
Mar 03, 2021 06:34 AM
Hi Mary Kay,
Thank you, your solution worked for me.
When I had to create the filter to update the record, I chose the blue tag (ID) but I couldn’t find the Record Updates option so I set it up as “it doesn’t exist”. Not sure why, maybe I was looking for it in the wrong place? Or maybe Integromat changed something since May?
When I had to Create Record, I was able to go for your approach.
It looks I am getting the desired results, I will keep an eye on it and post here if anything weird happens.
Thank you!
Mar 03, 2021 11:33 AM
I’m glad it worked for you!
There has been a new update/version for Airtable.
You could check this at Integromat.com
Or you could do a Google search and find the link for app/module descriptions.
Hope this helps!
Mary Kay