Is there anyway to replicate an excel table with a sum calculation ?

  • Kryinix
    Asked on February 28, 2018 at 4:43 AM

    Hi,


    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,


    Thank you,


    RSG

    Jotform Thread 1399660 Screenshot
  • Kevin Support Team Lead
    Replied on February 28, 2018 at 9:34 AM

    It's not possible to perform calculations with widgets, but you may use an input table to perform calculations: 

    Is there anyway to replicate an excel table with a sum calculation ? Image 10

    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.