Skip to main content
Solved

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

  • February 22, 2024
  • 2 replies
  • 28 views

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.

2 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • Answer
  • February 23, 2024

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
  • Author
  • Inspiring
  • February 26, 2024

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