Context: automation of appointment setting for a clinic. Working hours from Monday to Friday, 8:30 to 17:00.
Scenario: I am receiving a bundle from Google calendar (snip below) and I put a router with 2 routes: (a) filtering within working hours (and workflow follows to next steps) and (b) filtering outside working hours, followed by a webhook with a message to user to pick another date/time.
My challenge: Not finding a way to filter out the working hours, the text operators in teh drop-down menu don’t have option like “greater than” and I was told I should not use time/datetime operators, because I transformed the data into a string. (snip below).
Any help is appreciated.
I got something for you, maybe its not the best but it will work 
Setup the base of you Event Time with this formula like this :
Here in gave me the hour of the day of 1st January of 2000 like this :
Then (you can do this directly in the filter but me I used varible to work it out) with another formula, set up the bases of your working hours like this :
This gave me the bases of working time like this :
Now you can easily compare dates with Datetime operators like this :
And here you go 
2 Likes
Nice! smart workaround… I will definitely try it and let you know here… super appreciate!
1 Like
Why not block the hours in Calendly directly so they cant schedule appointments outside of working hours?
Sure - but I want to send a msg back to user saying is picking a time slot is outside the working hours and ask to pick another slot. Makes sense? If there is another easier/+elegant way to do it I’m all ears.. thanks for your interest here @Stoyan_Vatov
Yes, you can set the working hours directly in Calendly so they cant choose outside of working hours to begin with. Then you dont need to send them a message to rebook. Which they can still pick a time outside of working hours, then get another message, then enter a loop and decide the hastle is not worth it and find someone else instead.
Not sure I want the customer to keep trying without success - if they are distracted and pick a time outside working hours, I want to send a msg back, then offer a couple of time slots that are in fact available.
@Victorus you are f*%king genius, followed your instructions and it worked!! Thank you !! Now, going to next phase (offer 2 time slots proactively when customer pick a time that is already busy or outside working hours)..
If you set the working hours in Calendly then the customer will not be able to pick a time outside of working hours to begin with. Then you don’t need this integration at all. There is no reason to let them pick a spot outside of working hours and then bother messaging them to reschedule.
Hi @Stoyan_Vatov , in this case the inquiry is coming from a bot built with Voiceflow, so customer can freely type any time slot, that is why doing this - perhaps there is a way to “display” (not using calendry, my client uses Google) way to “display” Google calendar availability directly on voiceflow, so they can “see” the calendar itself (for maybe a whole week) and pick a time that serves them better..? if that what you mean? I’m sorry, I’m new to this and I am trying to find the best logic/approach to this - sincerely appreciate your help
