Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

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

Topic Labels: Formulas Integrations
Solved
Jump to Solution
911 2
cancel
Showing results for 
Search instead for 
Did you mean: 
hauwi
6 - Interface Innovator
6 - Interface Innovator

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

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

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.

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

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