I’m trying to send notifications while avoiding them being sent at midnight UTC (one of the trigger conditions is the number of days since an event has happened).
I’d like them to be sent at 6pm UTC+2, not at midnight, but I also want them to trigger based on conditions, and can’t use the “Scheduled time” because then it’d run only one time for all the record that matches (I need to run it once per record), as I’m sending one SMS to each user.
Is there a way to have a formula field with the current time of the day (the hour)? Or another way?