Hi experts,
We have two calendar lists, one is to keep each person's vacation schedule, the other one tells which area each person covers in a certain period.
The data in vacation calendar list is something like below,
Person | Vacation Start Date | Vacation End Date
Alice | 2020-01-01 | 2020-01-05
Alice | 2020-07-01 | 2020-07-05
Bob | 2020-07-03 | 2020-07-04
Bob | 2020-07-31 | 2020-08-04
The coverage area schedule list looks like this,
Person | Area | Start Date | End Date
Alice | Area 1 | 2020-06-01 | 2020-07-31
Alice | Area 2 | 2020-08-01 | 2020-08-31
Bob | Area 1 | 2020-06-30 | 2020-08-01
Now I need to create a calendar view to show the coverage person in each area, but if a person is on vacation, the calendar will show this person is out of office and he/she won't show as a coverage person. For example, on 2020-7-2, for Area 1, both Alice and Bob are covering Area 1, but Alice is on vacation, so the calendar should look like below,
2020-07-02
all day event: Alice (vacation)
Bob (Coverage)
...
Is this something can be done using JavaScript from client side only?
Thanks,
Michael