How can i show my table overall total into a separate element?

  • Kagera
    Asked on November 12, 2021 at 6:04 AM

    How can i show my table overall total into a separate element?

    I want to be able to see the table total in another form element as soon as someone is entering the values

    I want the total of 30000 to be reflected in the Total Request field

    1636715024 618e4a10d186f Capture Screenshot 10

    Jotform Thread 3505804 Screenshot
  • Christopher JotForm Support
    Replied on November 12, 2021 at 6:20 AM

    Hi,

    This is not possible with the Spreadsheet widget using form calculation and conditional logic since you cannot retrieve data from a specific cell.

    However, it is possible with the Form Element Input Table by replicating the behavior of Spreadsheet widget using Conditional Logic to calculate the values in the cell and display the total value to a specific field you want.

    Guides:
    How to Perform Form Calculation in the Input Table Field?
    Calculate Values in the Input Table Through Condition