Appointment check availability for attenders for pivot calendar

Ask your questions here.
Post Reply
Eric
Posts: 43
Joined: 25 Jun 2020, 13:40
Name: Eric Henrich
Location: Germany

Appointment check availability for attenders for pivot calendar

Post by 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.

User avatar
support
Site Admin
Posts: 3442
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Appointment check availability for attenders for pivot calendar

Post by 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.

Post Reply