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!
13 replies
-
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
-
Hi Kruna,
You do not compare myempl, but you only check if it is != null - so you will get always a true.
It should be like this ... where myempl = EmployeeName and...
Does that help?
Best
Jörg
-
A long time ago you created a code script for me that checks to see if an assigned person had a conflicting assignment and opens a dialog to confirm. Essentially it warns if a conflict has occurred and one can either cancel or accept the new assignment. I am more than happy to post it here if it will help. Obviously, it will require adapting.
Content aside
- 13 days agoLast active
- 13Replies
- 1171Views
-
5
Following