HELP for extract from : URL CREATOMATE to AIRTABLE data

[Alain_Caviggia]

What are you trying to achieve?

Hello, I am trying to solve a problem in my MAKE automation scenario. This scenario allows me to create personalized CREATOMATE videos for prospects by combining a Heygen video sequence in my CREATOMATE template. Then, after rendering the CREATOMATE video, CREATOMATE creates a unique URL for me to retrieve this video. My problem is to be able to place this URL in my AIRTABLE table via MAKE knowing that the link that allows me to place the CREATOMATE URL to the right prospect in my AIRTABLE database is the Heygen URL included in the run once status of the CREATOMATE module. I have not been able to extract the CREATOMATE URL so far. I connected a search records from CREATOMATE Render a template, I inserted an Inspector filter between the two modules to properly link the CREATOMATE and AIRTABLE heygen URL data. I implemented the formula: {{19.video.heygen.source}} = {{20.modifications.video_heygen.source}} from Search AIRTABLE. But still the same error:

untimeError

[422] The formula for filtering records is invalid: Invalid formula. Please check your formula text.

Origin

Airtable

Automatic error handler

Any idea?

Thank you

Alain

[dilipborad]

Hello @Alain_Caviggia,
Welcome to the community.

Airtable Search is working with FilterByFormula.

I’ve already given multiple answers on this topic about how to use Airtable FilterByFormula with Make.
Please check this answers where I’ve also attached multiple related to it.

I cant fix the formula in the airtable "Search Records"

Hello @Santos, The formula you write on the Airtable Formula box in Make, Is not the same as you write on Airtable Formula Field. This formula in the make follows the specific syntax of the airtable formula that you can check here. https://support.airtable.com/docs/airtable-web-api-using-filterbyformula-or-sort-parameters As of now try to remove the surrounded if and use AND() only. Also, please check my answers related to this topic. :light_bulb:P.S.: Always search first, Check Make Ac…

[422] The formula for filtering records is invalid: Unknown field names: false

Hello @cleanbooks, There are 2 solutions you can do. As per Current Setup The Airtable Search Module formula field needs a formula syntax based on the airtable formula check this Airtable Web API - Using filterByFormula or sort parameters In your case, you need to use airtable functions AND, SEARCH or any of the Regular Expression. Please try both of these because the field {temp4} returns a boolean(true or false). Not sure that quote ("), is needed. Add these to your airtable field formula…

Airtable: [422] Unknown field name: true

Hello @Scottinabox, Instead of that try this AND({Status}='Done') Instead of AND you can use OR, SEARCH, or REGEX_MATCH. But it all depends on the requirements. The things you’ve tried were not matched with the Airtable formula structure. You need to match with airtable formula syntax. Read more on these help docs and community articles.

---

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!