0
Is there a way to find overlapping appointments?
I would like to create a formula that shows / checks if an appointment is overlapping with another appointment.
Is this possible?
Thanks!
1 reply
-
Hi Andre,
You could use the following formula to check that and show a coloured warning:
let mystart := start(Appointment);
let myend := endof(Appointment);
let over := cnt(select myAppointments where start(Appointment) < mystart and endof(Appointment) > mystart) + cnt(select myAppointments where start(Appointment) < myend and endof(Appointment) > myend) + cnt(select myAppointments where start(Appointment) >= mystart and endof(Appointment) <= myend);
if over > 1 then
styled("Overlapping", "orange", "warn")
end
Please adjust the table and field name to your database.
Best, Jörg
Content aside
- 4 yrs agoLast active
- 1Replies
- 1091Views