- KryinixAsked on February 28, 2018 at 04:43 AM
i just had a quick question to see if there is any widget or a way that a can do a summary of column with multiple rows ( like excels auto sum / sum function ) that will then auto fill a box with a total , the closest i have found to use is the matrix dynamic but there isn't a way to sum the total entered within a column,
I am trying to replicate the screenshot attached,
- JotForm SupportKevin_GAnswered on February 28, 2018 at 09:34 AM
It's not possible to perform calculations with widgets, but you may use an input table to perform calculations:
This guide will help you performing calculations based on this table: https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget
Please note that the input table element can have different field types that can be changed on the settings section of the field, but it's not possible to have a mix of all the fields.