What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

  • Profile Image

    Getting calculated fields for calendar and costs.

    Asked by jtjohnson on August 24, 2016 at 12:21 AM

    I am trying to perform two different calculations:

    1) Form has a "submit" date generated by the calendar function.  I am trying to take that date and generate another date three WEEKDAYS later on which the agency has to respond to the request.  Is there a way to do such a calculation?  In a similar fashion, I need to generate a similar field but 15 days after the original date of submission.

    2) This one should be easy, but I guess not easy enough for me.  I have a field where a specific quantity will be entered, i.e. "Number of copies" , and that number will be multiplied by a per-page price, which might be changed from time to time.

    You folks have been great at support thus far.  I really appreciate it.  But do you have any any suggestions about this current challenge?



    Page URL:

  • Profile Image
    JotForm Support

    Answered by Chriistian on August 24, 2016 at 03:51 AM

    The values that you see from your screenshot is the specific number of days from 1/1/1970 (this is the date that computers use as the starting point) up to the date 23/08/2016 plus 3 and 15 days respectively.

    To see the month, day and year in the calculation, simply follow the steps below.

    1. Open the calculation wizard and click the ... button.

    2. Select the dateString option from the list to add it in the formula. Setup the formula as seen in the screenshot below.

    3. Click finish to save and you're all set.

    The result should now look like the one below. (Date selected is 24/8/16)

    To better assist you, I have moved your other question to a new thread. We shall answer your second question there. Here's the link: https://www.jotform.com/answers/914322.