Skip to main content
Solved

Time to Formula Help

  • April 24, 2023
  • 2 replies
  • 19 views
J
Forum|alt.badge.img+14

I've got an events calendar and an automation set up so that event registrants will get an email 6 hours prior to an event, using a formula field and the TONOW formula:

TONOW({Start})

The automation sends an email when the formula field reads "6 hours".

The trouble is, the field renders "6 hours" twice - once 6 hours before the event and again 6 hours after the event, so it triggers the automation to run again 6 hrs after the event.

Can anyone recommend a better formula to get what I'm looking for here?

Thanks!!!

Best answer by TheTimeSavingCo

Try using `DATETIME_DIFF()` instead? Formula field reference

 

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31
  • TheTimeSavingCo
  • Brainy
  • 6410 replies
  • Answer
  • April 25, 2023

Try using `DATETIME_DIFF()` instead? Formula field reference

 

Adam, Airtable Consultant - thetimesaving.company
J
Forum|alt.badge.img+14
  • Joel_Andrews1
  • Author
  • Inspiring
  • 42 replies
  • April 25, 2023

Try using `DATETIME_DIFF()` instead? Formula field reference

 


Perfect! I used the following and it worked great: 

DATETIME_DIFF(Start,NOW(),'hours')

 Thanks for the help!


Terms & ConditionsAccessibility statement