E-Forms
      Back to home
      1. IMS Knowledge Base
      2. FileBound
      3. E-Forms

      Table Calculations in the E-Forms Designer

      How to use a table column total in a calculation

      Use a table column total in a calculation

      When designing a web form with a table that contains a total row, you may want to use the value in the column total row for a calculation elsewhere on the form. The total row does not have an ID separate from the table in table properties, so you need to locate the ID attribute in the HTML.

      1. Add a table control to the form and configure it so that it has a column total row.
      2. Click Web Preview to preview the web form.

      3. In your browser, right-click the table column total row, and select Inspect.

      4. In the Elements window, locate the ID attribute on the <td> element for the column total.

        Note: IDs are of the form Table#_X_ColumnTotal where Table# is the ID used by the Table and X is the column corresponding to the desired total, starting with A, B, C...
      5. In the Forms Designer, add a calculation control to the form, then click Configure.

      6. Build the equation for the calculation field using the ID attribute above for the column total.

      7. Click Save.