-
jaronneviAsked on May 25, 2020 at 11:01 PM
I'm trying to make an element that allows one to input the duration (time it takes to complete a task) With hours, minutes and seconds fields. I created a configurable list widget which is perfect for the one submitting the form but when I export an excel log of the submissions that field shows as: Hours:0, Minutes:30, Seconds:0. Is there a way to have it show in the excel sheet as hh:mm:ss automatically? Otherwise I will have to do this manually.
-
roneetReplied on May 25, 2020 at 11:40 PM
You may consider using a Fixed Format widget to let the user enter the time in the time format with seconds.
https://widgets.jotform.com/widget/fixed_format
Let us know how it goes.
Thanks.
-
jaronneviReplied on May 26, 2020 at 11:52 AM
roneet,
This worked out perfectly. Thank you so much man.
-
jaronneviReplied on May 26, 2020 at 12:30 PM
roneet,
One more question about this. How can you require the user to fill each field with 2 characters? i.e. hh=01 not hh=1
-
Anita_KReplied on May 26, 2020 at 1:39 PM
Hi there,
you may use underscores to represent characters.
So if you set the widget to __/__/__/ it will limit each box to two characters.
Please give it a go and let us know if you're happy with the result.
-
jaronneviReplied on May 26, 2020 at 1:52 PM
That didn't work. It does limit each field to 2 characters but doesn't enforce the entry of 2 characters. So you can just enter 1 and it will accept it. Here is what shows when I pull the excel. I need it to be more like 01:02:03
-
Kevin Support Team LeadReplied on May 26, 2020 at 3:36 PM
It seems like indeed the widget limits the entry to 2 characters as a max entry, but it allows submissions with one character only.
I would recommend you to try using a short text entry field instead and set up a mask, here is how:
Here's an example of the result: https://form.jotform.com/201465947341053
I hope this helps.