Skip to content
Template Sum Tables
Tables
One Table & Multiple Forms
Validation Logic
More
Share
Explore

Validation Logic

Defining the conditions to a response to be good to go
Christiaan Huizer
The most interesting cases are the onces with multiple non working days.
There is a scenario in which blend holidays with non working days and you are not aware. As HR manager you don’t want to ask for a second submission because the first one, was empty. I came across these use cases while testing a lot for a client. I noticed I picked non working dates to ask for time off. This made me decide to avoid this scenario. Nota bene, once there is one working day in range, you are good to go. The days off are filtered out in the calculation and only the working days are taken into account.
In the example below the non working days are printed a s result of function generated for new rows.
DB Vacation Planning
1
from
until
theWeekdays
holidays
nonWorkingdays
backUp
1
Mon, May 29, 2023
Sun, May 28, 2023
21
5/29/2023, 7/4/2023, 9/4/2023, 11/23/2023, 12/24/2023, 12/25/2023, 12/26/2023,01/01/2024
2,3
the until date is always equal or greater than the start date
2
Mon, May 29, 2023
Sun, Jun 4, 2023
2345671
5/29/2023 7/4/2023 9/4/2023 11/23/2023 12/24/2023 12/25/2023 12/26/202301/01/2024
7,1
OKAY
3
Mon, May 29, 2023
Thu, Jun 1, 2023
2345
5/29/2023, 7/4/2023, 9/4/2023, 11/23/2023, 12/24/2023, 12/25/2023, 12/26/2023,01/01/2024
3,4,5
You cannot take time off on days you don't work
4
Mon, May 29, 2023
Sun, Jun 4, 2023
2345671
5/29/2023, 7/4/2023, 9/4/2023, 11/23/2023, 12/24/2023, 12/25/2023, 12/26/2023,01/01/2024
1,3,5,7
OKAY
5
Sun, Jul 30, 2023
Wed, Aug 2, 2023
1234
5/29/2023, 7/4/2023, 9/4/2023, 11/23/2023, 12/24/2023, 12/25/2023, 12/26/2023,01/01/2024
2
Please split your request in two: days before and including 7/31/2023 and the second request days after 7/31/2023
6
Sun, Dec 24, 2023
Wed, Dec 27, 2023
1234
5/29/2023, 7/4/2023, 9/4/2023, 11/23/2023, 12/24/2023, 12/25/2023, 12/26/2023,01/01/2024
6
OKAY
7
Fri, Jun 2, 2023
Sat, Jun 3, 2023
67
5/29/2023, 7/4/2023, 9/4/2023, 11/23/2023, 12/24/2023, 12/25/2023, 12/26/2023,01/01/2024
1
OKAY
There are no rows in this table
⁠

View of DB Vacation Planning
1
from
*
until
*
feedback
​
Submit
⁠
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.