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
Search records in Airtable from Integromat
+2Best answer by M_k
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
This topic has been closed for replies.
+8Hi Matteo
I worked on a scenario over the weekend.
I now have a few suggestions and some questions.
Suggestions
-
In the Watch Record, try removing the formula, since you have another formula already in the Search Record.
-
You almost had the formula, in the Search record. You just need to place straight quotes on either side of the blue tag, no spaces.
-
Filter for Create a record, select the ID tag from module 16 then select “Does not exist” condition, second choice from drop down.
Questions:
- Where is your data coming from?
Did you consider using Google Sheets for inputing data? Then you could place the Google Sheets app at the beginning. When you run the scenario it will place all your data into one base, with all of your fields. This way you only need one base.
Just a suggestion.
Can you provide a screenshot of the whole module setup for Create a record, it looks cut off and I would like to see the complete setup.
I did a mock-up of your database, based on your scenario, but when I get your reply, I might have a better idea if it’s going to work.
I am just not sure where the data is coming from and what the flow is.
Thank you,
Mary
Hi @M_k,
I have a few deadlines to meet this week but I will look into your solution asap.
In the meantime I just want to express how grateful I am that you have invested so much time and thought to help me.
You are truly generous and inspiring!
Thank you,
Matteo
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.