Restricing Date selection with holiday list

User Support Form Building
,
1

Hi @Kal_Lam

can you please guide that how i can restrict the calendar selection with specified list of holidays.
The purpose is that one should not be able to select the next date when there is holiday in the organization.

Please guide.

Cheers !

Neeraj

2

Hi @caneeraj,

  1. You need to create a constraint
    in xls-form it is created by adding a column in survey sheet. Like this screenshot:

in KoBo Form Builder it is under the settings of the question,

validation criteria
validation criteria1297Ă—282 11 KB

  1. You need to change the date format of your holidays to YYYY-MM-DD this is how KoBo stores its dates. Today (16 March 2022) is 2022-03-16.

  2. Then you need to write the dates in the KoBo’s date format in the constraint section with or syntax.

This is the help article for you:
https://support.kobotoolbox.org/validation_criteria.html

If you need further help, do not hesitate to ask.
Best,

1 Like