-
ArmaniRestaurantAsked on July 24, 2024 at 8:04 PM
Hello,
Could I add a table to a form which performs row calculations?
Thank you
-
Hilary JotForm SupportReplied on July 24, 2024 at 10:50 PM
Hi Armani,
Thanks for reaching out to Jotform Support. I'll need more time to look into this. I'll circle back in this thread when there's an update.
Thank you for your patience.
-
Hilary JotForm SupportReplied on July 25, 2024 at 1:15 AM
Hi Armani,
You can use Input Table and perform calculation there. Let me show you how to add the Input Table:
- In Form Builder, click on Add Form Element.
- Drag and drop Input Table to the form.
Now, you can set calculation formula in the Input Table.
- In Form Builder, click on Input Table’s gear icon to open properties.
- In the properties panel on the right, go to Options at the top.
- Enter your calculation values according to your table’s dimensions.
- Separate the values with commas for columns and break lines for rows.
Finally, add a Form Calcation Widget to your form.
- In Form Builder, click on Add Form Element.
- Go to Widgets section.
- Drag and drop Form Calculation to the form.
- Select the widget’s wand icon to open settings.
- In the settings panel on the right, select Add Field, then choose your Input Table.
- Choose your table’s sub-fields to use in your calculations, then select Done at the bottom.
- This will add the sub-fields in the calculation editor without operators. Sub-fields are either the rows or cells in your table, depending on the input type.
- Complete your formula in the editor, then select Save at the bottom once you’re done.
Give it a try and let us know if you need any other help.
- In Form Builder, click on Add Form Element.
-
KusaiReplied on July 25, 2024 at 8:05 PM
Thanks you for the instructions, but that does not totally help me. I want to be able to enter variables values in the tables fields and then perform a simple calculations on them. The report I am trying to build is a store daily sales report, so the fields values would be different from day to day. Please see bellow the table I did on Excel and let me know if I can duplicate something like that in the form. Thank you.
-
Mary Eden JotForm SupportReplied on July 25, 2024 at 10:34 PM
Hello Kusai,
Please note that your Table is possible, however, for the Total Cash and Card, we need to use a Form Calculation Widget to get the total sum, similar to the suggestion provided by my colleague. Let me show you how it's done:
1. Add the Input Table along with the description. For the card and cash, we will use two separate input tables.
2. To determine the sum of these two tables, we will use the Form Calculation Widget.
Check out the screencast below to see my results:
Give it a try and reach out again if you have any other questions.