How to exclude weekends when using dynamic date selections?

  • VCSIT
    Asked on December 11, 2020 at 7:15 PM

    Hi,

    I've created a form for work in which students can request a transcript. We advise them that the requests take no less than 3 business days to process. We ask them to tell us their desired date to pick up their transcript. I am using the calendar picker in the form and i have excluded weekends since these are not business days. I learned that i can use Dynamic Date Selections and choose today+x (where x is the number of days to be added to today). This mostly works, except it counts the weekend days. How can i exclude the weekends in this calculation?

    Thanks in advance for your help!

    Mike



    Page URL: https://form.jotform.com/203456921905154
  • Vick_W Jotform Support
    Replied on December 11, 2020 at 11:08 PM

    Hi Mike,

    For the Date field settings, all the days that will result in a working day when 3 working days are added we will use the date field with the following settings.

    1607743815 5fd43947daf04 Screenshot 10

    Here is how the result will show. The user will only get one day to pick. You can change it based on your requirement.

    1607743963 5fd439db76b95 Screenshot 21

    Now the most important step is to add a date field and activate the CURRENT DATE option in it. This field will remain hidden and it will be used as the main trigger point for all the conditions.

    1607745933 5fd4418d01795 Screenshot 32

    Now you'll have to add multiple date fields in order to avoid showing the weekends using conditions. For example, if the day is Wednesday then the 3rd day will be Saturday. But to show the next working day which is Monday you'll have to add +5. You can use this one condition for Wednesday, Thursday, and Friday.

    Here is how you will create the show/hide condition.

    1607744437 5fd43bb5593cb Screenshot 43

    1607744488 5fd43be80c2a1 Screenshot 54

    Now for example, if someone is placing the order on a Saturday then you'll need the date to add +4, so you'll need another date field in which you'll use Today+4 for both start and end date. You'll have to add conditions for this as well.

    I've created a clone for you. You can test it and clone it from the link below.

    https://www.jotform.com/203458083155960

    You can clone it using the guide below.

    https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    Please try it and if you have any questions then please let us know.

    Thanks