Based on availability I'd like to send a notification so that we opt in/out of pest control treatment that day.
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.
