Input Table: Pass the Time Value From One Column to Another

Dear support,

I have an Input Table with numeric values. There are four textboxes: start, end, hours (read only), and minutes (read only).

How can I automatically calculate hours and minutes?

The time must be 24 hours. Example:

Start 12:00 p.m. - End 3:30 p.m. = 3 hours 30 minutes

Thank you so much

Hi Singreo,

Thanks for reaching out to Jotform Support. Unfortunately, you can't separate the hours and minutes from the Start and End date hours and pass the value to the Hours and Minutes columns. The workaround I would suggest is to remove the Hours and Minutes and make it a Duration column for the Start and End columns. Then, create a condition to pass the value of Start and End date for the Duration. Let me walk you through it:

1. In Form Builder, click the Gear icon on the right side of the Input Table to open Input Table Properties.

2. Go to the Fields tab, and under Columns, remove the Hours and Minutes columns.

3. Click Add Column and add the Duration column.

4. Now, click on Add Element on the left side of the page.

5. In the Form Elements menu, under the Widgets tab, enter Form Calculation in the search bar, and drag and drop the widget to your form.

6. Click on the Wand icon on the right side of the widget to open Widget Settings.

7. Click the Add Field button and select the Call Logs of the input table.

8. Now, select the Start and Date columns and add the Minus between these columns.

9. Finally, click on Save at the bottom, and that's it.

After you set it up, we'll now create an Update/Calculate Field condition. Let me show you how to set that up:

1. In Form Builder, in the orange navigation bar at the top of the page, click on Settings.

2. Click on Conditions in the menu on the left side of the page.

3. Select Update/Calculate Field condition.

4. Finally, create the same condition below, and you're done.

Here's the result:

Give it a try and let us know if you need any help.

Thank you for the reply.

One more thing, when entering input into “Start” & “End”, should the output include a period (.)? For example, when I enter 1200, the exact same number appears, but I want the format to be 12.00 and the user cannot enter more than 4 digits because the time format is only 00.00

Thank you.

Hi Singreo,

The period (.) is required for the form calculation to work, since you are getting a time value. Unfortunately, I tested the form and currently there is no option to limit entry on input tables unlike single properties fields like short text element. To avoid your users to enter more than 4 digits, you can add a sub-label for instructions or a Paragraph Element. Let me show you how:

1. In Form Builder, click on Add Element on the left side of the page. In the Form Elements menu, under the Basic tab, scroll down to Paragraph, and drag and drop a Paragraph element to your form and add the instruction or message.

Give it a try and let us know if you have any other questions.