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.
Time Fields calculation - no result when not all fields are filledAsked 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?
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.
Thank you, I followed your instruction but am not getting a calculation as hours and minutes are selected.
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.
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.
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.
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.