I need to be able to have a three-day minimum setting on the calendar on the form. Is this possible?

  • Profile Image
    kayla_herlihy
    Asked on June 09, 2020 at 08:48 PM

    I need to be able to have a three-day minimum setting on the calendar on the form. Is this possible?

  • Profile Image
    Vanessa_T
    Answered on June 10, 2020 at 12:51 AM

    Please note that you can create another field which will hold the end date. You can either let the user fill it out, or you can calculate the value using conditions.

    How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic

    159176466100504.jpg

    You can then choose that end date as your calendar event's end date.

    159176469300503.jpg

  • Profile Image
    Vanessa_T
    Answered on June 10, 2020 at 12:58 AM

    My apologies, I may have misunderstood your concern as I was thinking of Google Calendar.

    How-to-Use-Google-Calendar-Create-Events-with-Your-Form

    If I understand your form's format correctly, you want them to be able to book a pickup date and a drop-off date, in which, it should be minimum of 3 days apart.

    You can add a Form Calculation widget to calculate the date difference.

    How-to-Perform-Form-Calculation-Using-a-Widget

    159176501900505.jpg

    Then, it will be up to you what you'd like to do if the value is less than 3. If you want them not to be able to submit if days is less than 3, then you can set a condition for that:

    How-to-Show-or-Hide-Fields-Base-on-User-s-Answer

  • Profile Image
    kayla_herlihy
    Answered on June 10, 2020 at 09:27 AM

    I'm sorry, can you explain how to do this a little more in-depth? 

    I am looking to have the boat rental start date and then have it automatically set the end date for at least 3 days from the start date (three-day minimum to rent the boat). 

    I have added the calculation widget in, but unsure what to input. 

    Thank you for your assistance. 


  • Profile Image
    Sonnyfer
    Answered on June 10, 2020 at 10:33 AM

    Hi there - Kindly allow me some time to make a demo form for you. I will be back shortly.

  • Profile Image
    Sonnyfer
    Answered on June 10, 2020 at 11:07 AM

    Thanks for your patience.

    I am looking to have the boat rental start date and then have it automatically set the end date for at least 3 days from the start date (three-day minimum to rent the boat). 

    First, I believe this is the form you're working on - 201596398291062 

    To achieve your requirements, you have to:

    1. Add two Date Picker fields to get the Current Date and the Current Date + 3 days

    First Date picker setup: Default Date > Current

    15918008841st d.png

    Second Date Picker setup: Default, but with CONDITION

    15918010112nd d.png

    Note: Both Date Pickers should be set to HIDDEN

    2. Once we have the Date Picker that displays the Current Date + 3, we can now add a Paragraph Field which would act as the error message if the date is less than 3 days from the start (pick-up) date.

    1591801275parsss.png

    Note: Field should be set to HIDDEN

    3. Add the CONDITION to display the Error Message.

    1591801397showcx.png

    Result:

    1591801544kkdsds.gif

    Here's a link to my demo form. I suggest cloning it to your account to see how it's created.

    Guide: How-to-Clone-an-Existing-Form-from-a-URL 

    Do review and let us know if you need further assistance.

  • Profile Image
    kayla_herlihy
    Answered on June 10, 2020 at 11:23 AM

    Thanks for this, unfortunately, we need this to work from the date they pick on the first calendar to grey out or not be able to select the next three days on the next calendar. This is needed for future reservations, not just the current date, typically people are not booking today then three days out. 

  • Profile Image
    Patrick_R
    Answered on June 10, 2020 at 12:56 PM

    Hi! Allow me some time time to look into it. I'll get back to you with an update shortly.

    Thank you!

  • Profile Image
    Patrick_R
    Answered on June 10, 2020 at 01:54 PM

    Hi! I'll refer to my colleague Vanessa's solution to your problem. Basically, if a difference of two date fields is calculated using the Form Calculation widget, then the difference returned is in days. Please have a look at Vanessa's screensthot (re-posting below for your reference):

    In the above Form Calculation widget, if start date is set to 15th June 2020 and end date is set to 20th June 2020; then the dates difference in the Form Calculation widget "Number of Days" would be 5.

    - I am looking to have the boat rental start date and then have it automatically set the end date for at least 3 days from the start date (three-day minimum to rent the boat).

    There isn't a way to dynamically set the end date limit to atleast 3 days for the Date field (user can always change it) and based on your requirement, setting this field to "read-only" will not be a solution as user should be allowed to choose more than 3 days as well.

    What we can do is display a custom error message if the selected end date is less than 3 days from the start date and also hide the submit button, so that user cannot submit the form (until he chooses a valid date). If this sounds like a solution to your problem, then please have a look at this screencast on how to implement this solution: https://drive.google.com/file/d/12cqo5TUUURFdrI_1L6QZ1ZwyqR0TJRsQ/view?usp=sharing

    If you want to see the demo form prepared (in the screencast) in action, then visit this link: https://form.jotform.com/201615219058956

    Feel free to test it or clone it into your account.

    I hope this helps. For further queries, feel free to get back to us.

  • Profile Image
    FRSmithandSons
    Answered on June 10, 2020 at 02:46 PM

    Perfect! Thank you so much for your assistance.