Skip to main content

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.

Hi Matteo


I worked on a scenario over the weekend.


I now have a few suggestions and some questions.


Suggestions




  1. In the Watch Record, try removing the formula, since you have another formula already in the Search Record.




  2. 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.




  3. Filter for Create a record, select the ID tag from module 16 then select “Does not exist” condition, second choice from drop down.




Questions:



  1. 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

Reply


Terms & Conditions