I’m having trouble with the Airtable > Search Records module in my scenario. Here’s what’s happening:
Scenario Overview:
I’m using a Google Drive > Watch Files trigger to detect new files in a folder.
For each new file, I create a folder in Google Drive and move the file into it.
I then use the Airtable Search Records module to find a record in Airtable
I used this formula for the Search Record module: RECORD_ID({{4.name}})
But it is still giving me an error.
I think it may be because in my Airtable I track the records with Content ID (eg.C101), however when I upload the file to the Google Drive it automatically uploads as ‘‘C101.png’’.
Welcome to the community.
First of all for explaining things in detail.
This is a direct solution for you. Formula:REGEX_MATCH({Image field},"Stored Image name in Airtable without extension")
To remove file extension from the name you need to use Make’s string functions.
You need to understand things about how the Airtable formula function works here while you use it with API or in make
I’ve also explained on the attached screenshot but you can check more here.
There are lots of Airtable community posts about it. Search and read it.
I hope this helps you.
P.S.: Always search first, Check Make Academy. If this is helpful, Mark Best as Solutions and give If you need expert help or have questions? Contact or comment below!
for explaining things in detail.
P.S.: Always search first, Check 
and give 