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.
Comments
0 comments
Please sign in to leave a comment.