
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 24, 2023 01:44 PM
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!!!
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 24, 2023 11:15 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 24, 2023 11:15 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 25, 2023 04:48 AM
Perfect! I used the following and it worked great:
DATETIME_DIFF(Start,NOW(),'hours')
Thanks for the help!
