Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 22, 2024 09:29 AM
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. 😊
Solved! Go to Solution.
Feb 22, 2024 04:45 PM - edited Feb 26, 2024 08:41 PM
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.
Feb 22, 2024 04:45 PM - edited Feb 26, 2024 08:41 PM
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.
Feb 25, 2024 10:18 PM
Thank you @ScottWorld. Much appreciated. 😀