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

    [Time field] Showing the total (time range duration) value in submissions results

    Asked by SFDCERT on July 29, 2013 at 04:30 PM

    Since apparently EVERY question asked must have it's very own thread (even though the question relates directly to the one in other threads)...here, we'll make a WHOLE NEW thread.

    If you have a date range field, why don't you make the calculation on that field display as it's own data field in the reports?  If you calculate it on the form, why do you not carry that over to the report?

    Having both the Start and End time in one field makes it difficult later to extract the total amount of time indicated...you have to parse the field into two and do calculations afterwards (in excel, etc.)...if you select to display the time range duration, why not carry that over to the report?  That way, if you need it you have it already calcuated...if you don't need it, you can simply ignore it on your final report.

    It seems a waste to create that calculation to display on the form then not make it available on the report.

    date range Reports excel calculations create time field
  • Profile Image
    JotForm Support

    Answered by Mike_T on July 29, 2013 at 05:53 PM

    Thank you for posting this thread and your reasonable suggestion. I have created a feature request ticket and escalated it to our Development Team.

    We can not provide any ETA for now, but we will definitely let you know once the request is implemented.

  • Profile Image
    JotForm Founder

    Answered by aytekin on July 30, 2013 at 08:32 AM

    Thanks for opening a new thread. I have assigned a feature ticket for your request. 

  • Profile Image

    Answered by JLTransporte on December 26, 2013 at 05:47 AM

    hello JotForm,

    it is possible in JotForm to calculate the day of order to the date the customer orderes my service?-

    For example:

    the customer ordered today but he ordered my service start on the 4th day between day of order and startdate - so i want to calculate diffrent prices for this;-

     

    If a customer orderes shortly to the first startday of my service it is a higher price-, if he ordered me later it is a lower price - can i do this with JotForm and how?-

    i used it in a other formular but i want to go to JOTForm because it is better and more modern in style as the one i used :

    In the other formular i can range between two dates-, so there is the startdate and the enddate and a hidden datefield - this is ever the date on which the customer fill out my formular it is automaticly and ever the date of fill out the formular;- So now the formular calculate the days of fill out the formular to the first startdate;-

     

    if is for exampel = 7 days - it is a higher price as if is 10 days because i have much less time to manage the service for the customer!-

     

    Can i do the same thing with JotForm- or like this maybe over the CSS - Style type functions and how?-

     

  • Profile Image
    JotForm Support

    Answered by jonathan on December 26, 2013 at 07:43 AM

    @ JLTransporte

    Hi,

    I suggest you create a new separate thread regarding your question so that we can properly provide the support for it.

    Please use this link to do this http://www.jotform.com/contact/

    You can just copy your message from here into the new thread and just add the appropriate title/subject.

    We will attend to your question at once.

    Thanks.