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

null
    • Jorg
    • 4 yrs ago
    • Reported - view

    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