How do I keep a running total of a subform element?

---

For the updated instructions on the new Form Builder, click here.

Subform Aggregation (Addition) allows you to keep a running total of a particular subform element, and display that total on the Parent form.

To setup Subform Aggregation (Addition) on your form, please follow the instructions below.

---

STEP 1: Create your subform.  For more detailed info on creating a form, click here.

STEP 2: Add a Number Widget to the form.  In this example we will give the Number Widget a data column name of element_on_subform.  

NOTE:  You will refer to this data column name on your Parent Form.

STEP 3: Click the Smart Control tab (A) and put element_on_subform="" in the Dynamic Value field (B).

STEP 4: Create the Parent form.

STEP 5: Add a Subform element to the form.  In this example the data column name is aggregation_totals.

STEP 6: Click the Smart Paging tab (A) and choose the Aggregation Subform you created in the previous steps (B).

STEP 7: For Link Mode, choose Multiple (A) and click Save (B).

STEP 8: Add a Text or Read-Only element to the form.  In this example the data column name of the element is subform_aggregation_addition.

STEP 9: Click the Smart Control tab (A) and in the Dynamic Value (B), you will put syntax similar to the following:

iformbuilder.math.sum(table_name.subform_element_dcn, 'element_on_subform')

REPLACE THE FOLLOWING WITH YOUR DATA COLUMN NAMES

table_name: This is the Parent form Table Name which is located on the Edit Form Properties page.  (parent_aggregation_addition)

subform_element_dcn: This is the data column name of the Subform element on the Parent form (aggregation_totals).  PLEASE NOTE: This is the data column name of the Subform element and NOT the table name of the Subform.

element_on_subform: The data column name of the element you want the total for on the Subform. (element_on_subform)

---

iForm Tip: Download the Form Package at the bottom for a sample form of this functionality.

---