calculate estimated completion date based on current date - static text, not a field?

  • Profile Image
    houndandbone
    Asked on June 11, 2020 at 07:38 AM

    Hello!

     

    I have been reading this thread and it's VERY close to what I'm wanting to achieve, however my needs are slightly different.
    We will be using Jotform as an order form, and I am wanting the form to display some text that will display the estimated completion date window. This is typically 3-5 business days (excluding weekends) from the date that the order is placed. The form above does something similar, however it calculates the date as a field in the form, and not text information on the page.

    I have attached a quick screenshot of what I'm hoping to achieve in the hopes it might help. As you can see, it's just text on the order form itself, rather than a date selector field like the one in the aforementioned thread.

    Is this possible?

    Thank you in advance!

    Screenshot
  • Profile Image
    houndandbone
    Answered on June 11, 2020 at 08:40 AM

    It seems as though something like this could be the answer, except that instead of todays date I need it to calculate 3 business days (ideally a 3-5 day window) from the current date. Any ideas?

  • Profile Image
    IvayloK
    Answered on June 11, 2020 at 10:08 AM

    Unfortunately, it is not possible to exclude weekends when using date calculations.

    Let's take the second ticket, which you posted. In order to add 3 or 5 days, you should just add additional Date Picker fields. Then you should create conditions, which will calculate the dates. Then you will be able to post the dates (Date Picker fields) anywhere in a Text field.

    Your conditions should look like this:

    1591883916chrome_L3OLIDoD1N.png

    Let us know if you need any further assistance.

     

  • Profile Image
    PSGM
    Answered on June 11, 2020 at 12:49 PM

    I have attempted this multiple times and my second date never changes. Can you please show the screen shots of this working? 

  • Profile Image
    Bojan_J
    Answered on June 11, 2020 at 01:58 PM

    Greetings and thank you for your reply.

    Unfortunately, I was not able to use my colleague's solution, but here is an alternative. I have created a test form for you. You can test it on the following link:
    https://jotform.com/201625008633043

    You can add a date input, and set a default value to be today. Then you need to add a form calculation widget. In it, you need to add dateString function, and in it to add the date field with the number of days you wish to increase the current day. You can add functions by clicking the three dots at the widgets keypad:

    Then you need to find the field's unique name. This can be found in the Advanced tab under the Field Details:

    Then you can add the unique name (between curly brackets) in the paragraph, and the value of the field will be replaced with the name:

    If you wish, you can hide the date and calculation fields so they are not visible for the user.

    Feel free to clone my form to see in detail how it was created. You can click here to see how to clone the form.

    Let us know if this solution will work for you.

  • Profile Image
    houndandbone
    Answered on June 14, 2020 at 08:19 AM

    Hi Bojan,

     

    Unfortunately that formula isn't working for me - I have set it up just as you described but I'm getting the following in the paragraph box.

    1592137284Screen Shot 2020-06-14 at 10.2

  • Profile Image
    Niko_N
    Answered on June 14, 2020 at 10:10 AM

    Greetings,

    As I understand, reason behind getting that paragraph box it that you have manually typed dateString function in form calculation widgets. To fix that, please follow my screencast given below:

    Hope this helps.

    Please let us know if you need any further assistance.

    Thank you!


  • Profile Image
    houndandbone
    Answered on June 14, 2020 at 10:28 AM

    Thank you!