Hi everyone,
I have a Stacker app, linked of course to Airtable, for which my colleagues use to plan events, sync these to internal calendars, etc.
Some of these events run “Out of Hours”, i.e. starting or running into Saturdays or Sundays, or starting or running past 5pm Monday to Friday, and for compliance purposes, these events needs some special email notifications to fire to certain people.
One workaround would be simply to have users mark a checkbox field to say “my event is out of hours”, but this still has the possibility of user error (and I’d like to streamline my Stacker app as much as possible).
So, theorising a workaround, I’ve created four formula fields using DATETIME_FORMAT to extract the Start day, End day, Start time, and End time independently of any date and those values being combined in the date fields, which what my users configure. This has allowed me to get text values for “Saturday” and “Sunday”, and it’s easy enough to configure an automation for these, however, I’m stumped as to if it’s possible to configure an automation to recognise when the Start time or End time fields are greater than 5pm, e.g. “> 16:59”.
I don’t suppose this might be something anyone else has encountered before, or might any ideas for?
Much appreciated,
Matt