Skip to main content

Automating Airtable With Make.com...

M
  • M_k
  • Inspiring
  • 614 replies

 

[SOLVED]  Thank you for your help!

UPDATE:

I resolved the syntax issue.

Hi Everyone!
 
I just need help with the search filters.  TY
I am getting an error message, when I run my scenario:
 
“The operation failed with an error. [422] The formula for filtering records is invalid: Unknown field names: 321”
 
I need help with:
  1. Airtable filter in the Search module
I don’t know what the make.com filter syntex is for searching records. I am not a programmer, so I will need step by step instructions. The unique ID is SCOTT #. TY
 
2. Creating filters to avoid duplicate records in my Airtable base, in Make.com for:
 
1. New Records
 
2. Update records
 
These search filters will be in the same scenario.
 
I am using a Google sheet for all record data, there are new records and existing records in one Google Sheet.
 
I am attaching screenshots.
 
Any help would be appreciated. I am just starting to use make.com a bit more now and to me, it seems to be a bit of a learnng curve.

3 replies

TheTimeSavingCo
Forum|alt.badge.img+18

Hmm, I couldn't see where you're setting the formula via your screenshots, sorry if I missed it!

Here's a Make scenario I set up that watches a Google Sheet and searches an Airtable table based on the value from cell A of the new row:

I think you could do this fully within Airtable if you had the automations to spare as well

Adam, Consultant @ The Time Saving Co
M
  • M_k
  • Author
  • Inspiring
  • 614 replies
  • February 21, 2024
TheTimeSavingCo wrote:

Hmm, I couldn't see where you're setting the formula via your screenshots, sorry if I missed it!

Here's a Make scenario I set up that watches a Google Sheet and searches an Airtable table based on the value from cell A of the new row:

I think you could do this fully within Airtable if you had the automations to spare as well


Hi Adam!

Thank you!

So I managed to get the syntax filter set up.

I am just not sure about the filters to not create duplicates for:

1. Create a new record

and 

2. Update a record

Also, what values do I put into the Create and Update a record in the Airtable modules?

For the Unique key, it’s SCOTT #, do I use the value from the Airtable Search module?

For the field values, ie Stamp Description field, in Create and Update a record in Airtable modules, is it the Google sheet values?

Any help would be appreciated!

TheTimeSavingCo
Forum|alt.badge.img+18
M_k wrote:

Hi Adam!

Thank you!

So I managed to get the syntax filter set up.

I am just not sure about the filters to not create duplicates for:

1. Create a new record

and 

2. Update a record

Also, what values do I put into the Create and Update a record in the Airtable modules?

For the Unique key, it’s SCOTT #, do I use the value from the Airtable Search module?

For the field values, ie Stamp Description field, in Create and Update a record in Airtable modules, is it the Google sheet values?

Any help would be appreciated!


Hmm, you say you've got the syntax for the filter set up, so I'm assuming you've got a working "Search Records" module that outputs the number of records it found based on your unique ID

If so, use a router to determine whether you should then create a record or update a record?

Are you trying to create like a one to one copy of the Google Sheet in Airtable or something?  Sorry, I don't really know what you're trying to do and so I don't know what values to use and stuff

 
Adam, Consultant @ The Time Saving Co

Reply


Most helpful members this week

Terms & Conditions