Triggers based on 2 or more bookings or calendar

Status: Requested 1 Vote
Ed T
Jan 24, 2024 5:45 PM
Joined Nov, 2023 24 posts

Based on availability I'd like to send a notification so that we opt in/out of pest control treatment that day.  This applies to maintenance days, lawn care, and other servics as well.   

What is requested is a compound query that allows me to combine into one.   This currently can be done with 2 triggers but unfortunately, we cant compare the trigger results to each other.

ACTION 

     Occurs  a) event   b) time

     Time  a)  #,    Days,   <Before/After>     <Booking ...> option

      Send Template    custom template

 

Add a conjunctive   AND/OR to the code

 

and a 2nd ACTION 

     Occurs  a) event   b) time

     Time  a)  #,    Days,   <Before/After>     <Booking ...> option

      Send Template    custom template

 

Alternatively, if the option for the trigger was date-based.  Instead of setting the window relative to booking we have an option to be relative to a <Date>.   If <Date> was selected an option to select hours between <beginning> and <ending>.

I'd like to check to see if a property is occupied or not on a specific date.    I find I can use the trigger tools and bookings to do anything around a single property but I can't figure out how to determine what's going on between 2 bookings.   In other words, if booking A checks out Monday and Booking B checks in Thursday I want to notify pest control to service.   But if Booking A checks out Tuesday I can't tell if Booking B also check in Tuesday.

 

Problem 2: Taking the scenario in step 1 a step further,  I'd like to find all properties available on Wednesday and prepare a single unified email to the pest control service saying Please service units A, C, D.  DO NOT service units B & E.