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

  • Profile Image
    Kagera
    Asked on November 12, 2021 at 06: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.JPG

    Screenshot
  • Profile Image
    Christopher_T
    Answered on November 12, 2021 at 06: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