How can I craate a sum of two tables

Hello Jotform team.

I want to integrate two tables, each containing a quote, into a single form. Each table has 10 rows with the following fields: Description, Units, Unit Cost, Total (excluding taxes), and Total (including taxes). At the end of the table, I've included a sum of the Total (excluding taxes) and Total (including taxes) fields.

I've managed to do this so far using a spreadsheet.

Now I need to sum the Total (excluding taxes) and Total (including taxes) fields from both tables. I've tried using the Form Calculation widget, but I haven't been able to do it.

How can I do this?

Thanks

-----------------------------------------

ESPAÑOL
Hola equipo de Jotform.

Quiero integrar en un formulario dos tablas sencillas de dos presupuesto. Son 10 filas por tabla con los siguientes campos: Descripción, unidades, coste unitario, total sin impuestos, total con impuestos. Al final de la tabla he incluido un sumatorio de los campos total sin impuestos y total con impuestos.

Hasta aquí lo he conseguido hacer con una Hoja de Cálculo.

Ahora necesito sumar los campos total sin impuestos y total con impuestos de las dos tablas. Lo he intentado con el Widget Calculo de Formulario pero no lo he conseguido.

¿como lo puedo hacer?

Gracias

Hi Francisco,

Thanks for reaching out to Jotform Support. I'm an AI assistant here to assist you.

Let me help you with summing the Total (excluding taxes) and Total (including taxes) fields from two tables in your form using the Form Calculation widget.

Here’s how to do it:

1. Add a Form Calculation widget to your form where you want to display the combined sum.
2. Open the widget settings by clicking the wand icon on the widget.
3. Use the Add Field button in the formula editor to add the sum fields from both tables. For example, if you have two calculation fields representing the totals of each table, add both of them in the formula editor separated by a plus sign (+).
4. Make sure the fields are set to number format (0-9) in the formula editor so their values are included in the calculation.
5. Save the widget settings. The widget will now show the sum of the totals from both tables.

If you have multiple calculation widgets for each table’s totals, you can add one more Form Calculation widget to sum those calculation widgets. You can hide this final widget if you don’t want it displayed.

This approach allows you to sum the Total (excluding taxes) and Total (including taxes) fields from both tables effectively within your form.

Give it a try and let us know how it goes.

La función de agregar campo en el widget no permite seleccionar campos en la hoja de cálculo.

Hi Francisco,

Thanks for your follow-up. You mentioned that the Add Field button in the Form Calculation widget does not allow selecting fields inside the Spreadsheet widget (tables), which is expected behavior because the Form Calculation widget cannot directly access or select individual fields within Spreadsheet widgets.

Here’s how you can sum the totals from two tables in your form:

1. Use separate Form Calculation widgets to calculate the total (excluding taxes) and total (including taxes) for each table individually. These widgets will sum the values inside each table.
2. Add a new Form Calculation widget where you want to display the combined sum of both tables.
3. In this new widget’s settings, use the Add Field button to add the two previous Form Calculation widgets (each representing the total of one table) and add them together using the plus sign (+) in the formula editor.
4. Ensure all calculation fields are set to number format (0-9) in the formula editor so their values are included correctly in the calculation.
5. Save the widget settings. This final widget will now show the sum of the totals from both tables.

This approach works because while you cannot select individual fields inside Spreadsheet widgets directly, you can sum each table’s totals separately with Form Calculation widgets and then sum those results.

Give this method a try and let us know if you need further assistance.