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

  • Profile Image
    SFDCERT
    Asked 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.

  • Profile Image
    Mike_T
    Answered 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
    aytekin
    Answered 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
    JLTransporte
    Answered 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
    jonathan
    Answered 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.