How to Create a Mileage Log Table with Auto Total in Jotform

I would like to create a mileage log table in my form where users can enter multiple rows of data with the following fields:

• Date
• Starting Location
• Ending Location
• Total Miles

I also want the form to automatically calculate the sum of all “Total Miles” entries and display the grand total at the bottom of the form. Also if there is option I can give a chance to user to add row only if they have more dates to enter their milage

Can you please advise what is the best way to set this up in Jotform? Should I use the Input Table, Configurable List Widget, or another option to allow users to add multiple rows and still have the total miles calculation work?

https://www.jotform.com/build/251904438683060

Hi mritunjay2_mkumar,

Thanks for reaching out to Jotform Support. The best way to set this up in Jotform depends on whether you prioritize calculation or flexibility. If your main goal is to calculate the sum of all Total Miles entries and display a running grand total, the Input Table with Calculation Values would be the most reliable option, since it allows you to assign numeric values and perform calculations easily within the form. But note that the Input Table doesn’t allow users to dynamically add new rows.

If you need the option for users to add more rows as needed, the Configurable List Widget provides that flexibility, but it does not support built-in calculations on the entries. In that case, a workaround would be to use multiple Short Text + Number fields with the Add Row button logic, by duplicating a row and conditionally showing more when needed, and then summing those number fields with a Form Calculation Widget. This way, you can give users the option to add mileage entries only when necessary while still ensuring that the total miles are automatically calculated at the bottom of the form.

Let us know if you need any more help.