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 Fields calculation - no result when not all fields are filled

    Asked by cnaleid on June 25, 2014 at 02:41 PM

    We use a form for daily job reports and a time only field to estimate each employees hours for the day. Is there an option to calculate the multiple selections giving us a total hours minutes calculation for the crew?

    Page URL:
    http://form.jotform.us/form/41375918100147

    Reports Time only time only field time calculations hour calculator
  • Profile Image
    JotForm Support

    Answered by Mike_T on June 25, 2014 at 04:00 PM

    Thank you for contacting us.

    Yes, this is possible. You will need to add a Form Calculation widget field, and add all the Time values on that widget.

    If you need any further assistance on this, please let us know. We will be happy to help.

  • Profile Image

    Answered by cnaleid on June 25, 2014 at 04:29 PM

    Thank you, I followed your instruction but am not getting a calculation as hours and minutes are selected.

     

  • Profile Image
    JotForm Support

    Answered by jonathan on June 25, 2014 at 05:49 PM

    Hi,

    It actually work when I also tried it on a test form http://www.jotformpro.com/form/41756553047963 (try the last 2 time field in the test form)

     

    just for testing, I added only the last 2 Time field in the calculation

     

    Can you please try adding the Calculation Widget again and retry adding the fields. Enclosed also the calculations within brackets "()"

     

    Please inform us if still not working on your end.

    Thanks!

     

     

  • Profile Image

    Answered by cnaleid on June 25, 2014 at 06:36 PM

    I tested on my end and can only get two entries to calculate. I have tried multiple ways of entering the list, but can not get past the two.

  • Profile Image
    JotForm Support

    Answered by Welvin on June 25, 2014 at 08:49 PM

    I noticed that if time field is used, the calculation widget requires you to fill all the field in order to show the total. Not sure if this is a bug, but let me forward this thread to our developers so they can further check this. 

    You can test this form: http://www.jotformpro.com/form/41758367896980. Fill all the time field to have a result.

    Thanks

  • Profile Image

    Answered by cnaleid on June 26, 2014 at 08:31 AM

    I think I have solved this by going to the advanced options on the Wizard and have Read Only Checked and Ignore hidden fields checked. Any other default setting checked creates issues. I have set up the time entry as a hidden field which expands after the employee is selected.