Creating Subtotals in the Data Grid
Last Updated: December 16, 2021
You can create subtotals for your data grids with a few simple steps of adding your input and operations, and then defining where the total should appear.
After creating the data grid, you must have at least two text fields configured as the Number type.
Alternatively, you can set up dropdowns, radio buttons, or cascading form controls that use the Expression Builder. Check out this article to learn how to setup the Expression Builder in these controls.
Next, you must set up a Label form element to add the two cells you want to add together.
Step 1: Add a label with the Formula Builder enabled to sum up the input fields.
Step 2: Add a text field with the Number type. This is where the total for your grid will appear.
Step 3: Click of the gear icon on the right side of the Data Grid. This will open the settings pop-up for the data grid. Turn on the toggle for Has Totals, and then click on Add Configuration.
Step 4: In the Data Grid Control dropdown, select the column which you want to total.
Step 4: Then, in the Form Control dropdown, select the field where you want the total to be displayed. Click on OK and then publish your workflow app.
The formula builder will automatically compute the total with each row added to the table.
Configuring the Formula Builder Using Label, Dropdown and Radio Button Elements
Configuring the Formula Builder Using Label and Text Field Elements
Creating a Data Grid
Need more help? Send us an email at customersuccess@quickreach.co, or send us a message on the chat widget.
You can create subtotals for your data grids with a few simple steps of adding your input and operations, and then defining where the total should appear.
PREREQUISITES
After creating the data grid, you must have at least two text fields configured as the Number type.
Alternatively, you can set up dropdowns, radio buttons, or cascading form controls that use the Expression Builder. Check out this article to learn how to setup the Expression Builder in these controls.
Next, you must set up a Label form element to add the two cells you want to add together.
SETUP
Step 1: Add a label with the Formula Builder enabled to sum up the input fields.
Step 2: Add a text field with the Number type. This is where the total for your grid will appear.
Step 3: Click of the gear icon on the right side of the Data Grid. This will open the settings pop-up for the data grid. Turn on the toggle for Has Totals, and then click on Add Configuration.
Step 4: In the Data Grid Control dropdown, select the column which you want to total.
Step 4: Then, in the Form Control dropdown, select the field where you want the total to be displayed. Click on OK and then publish your workflow app.
The formula builder will automatically compute the total with each row added to the table.
RELATED ARTICLE(S):
Configuring the Formula Builder Using Label, Dropdown and Radio Button Elements
Configuring the Formula Builder Using Label and Text Field Elements
Creating a Data Grid
Need more help? Send us an email at customersuccess@quickreach.co, or send us a message on the chat widget.
Updated on: 16/12/2021
Thank you!