Hi everyone,
working on an app where users would input holiday, sick leave, time trakcing, etc... I prepare this in multiple SharePoint lists...
List A is the user interface and storing all the requests and their statuses (approved/rejected holiday for example...)
List B is a list with prefilled dates and names, only status for the day should be changed, for example:
1.1.2020 | Jack | at work
2.1.2020 | Jack | HomeOffice
3.1.2020 | Jack | at work
4.1.2020 | Jack | Holliday
5.1.2020 | Jack | Blank
The B list is mainly required for HR so they have a clear view for each person, (in the example above is just one person).
The problem I have is, how to ensure that user will not book with the datepickers (the from date and the to date) a day that is already set to homeoffice or anything else... he should just be able to select those days that are set to "blank".
User | Count |
---|---|
144 | |
97 | |
89 | |
78 | |
56 |
User | Count |
---|---|
194 | |
186 | |
105 | |
99 | |
91 |