-
kv1sogAsked on February 27, 2018 at 11:19 PM
how to use formula in a table
-
tina JotForm DeveloperReplied on February 28, 2018 at 6:26 AM
In order to perform a calculation on input table, you can use the update/calculate field conditional logic or form calculation widget.
I have prepared an example form that includes input table with calculate field conditional logic:
https://www.jotform.com/80582046023954
the condition for the first row (d1=a1+b1+c1):
the condition for the second row (d1=(a1+b1)-c1):
Also, I kindly recommend you to check these guides below in order to learn more about form calculation :
Calculate Values in the Input Table Through Condition
How to Perform Form Calculation in the Matrix Field?
Smart Forms Using Conditional Logic
Also, we have Spreadsheet widget that allows you to set formulas to the table cells.
you can check the example form by visiting the given link below: