Time Fields calculation - no result when not all fields are filled

  • Profile Image
    cnaleid
    Asked 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?

  • Profile Image
    Mike_T
    Answered 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
    cnaleid
    Answered 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
    jonathan
    Answered 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
    cnaleid
    Answered 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
    Welvin
    Answered 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
    cnaleid
    Answered 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.