Appointment check availability for attenders for pivot calendar

[Eric]

Hi,

not sure where to begin with. So many possible ways to test that could do what i want but i ask before to get some ideas or hopefully a how to do it simple but effective.

What i have now:
- Different tables for vacation from employees, also about sickness days and others who aren't in house.
- A table for appointments which includes the function to add a employees for this appointment.
- Pivot Calendar who displays them.

What i look for:
A way to check when creating an appointment, if chosen employees available for this appointment.

What is a way? Use of php or mysql query or javascript? I am a bit lost in this Case.

[support]

Probably you can use Ajax Request field type https://docs.rukovoditel.net/index.php?p=99
where you can create own queries to database.