Skip to main content
Solved

Airtable formula error in 'search records' module in Make.com


Forum|alt.badge.img+10

Hi. I am trying to construct a formula in a Make.com search records module. The module is the trigger and I've been trying:

AND({Ind Doc}!=BLANK(),(DATETIME_DIFF(NOW(),{Record Created}(),"days")=14))

('Ind Doc' is an attachment field)

Any help would be appreciated. TIA. 😊

Best answer by ScottWorld

You have an extra set of parenthesis after your field named Record Created. Also, remember that Make’s search module for Airtable only support valid Airtable formulas, so you can test your formulas by creating a formula field in Airtable and seeing if it works there.

View original
Did this topic help you find an answer to your question?

ScottWorld
Forum|alt.badge.img+33

You have an extra set of parenthesis after your field named Record Created. Also, remember that Make’s search module for Airtable only support valid Airtable formulas, so you can test your formulas by creating a formula field in Airtable and seeing if it works there.


Forum|alt.badge.img+10
  • Inspiring
  • February 26, 2024
ScottWorld wrote:

You have an extra set of parenthesis after your field named Record Created. Also, remember that Make’s search module for Airtable only support valid Airtable formulas, so you can test your formulas by creating a formula field in Airtable and seeing if it works there.


Thank you @ScottWorld. Much appreciated. 😀


Reply