How to Count Rows in a Table in Builder BETA

A neat trick that many GoCanvas users have implemented in their forms is counting rows in a Loop Screen or Table. This can be applied to many different scenarios but some examples that we see often are counting passed or failed inspection items or assessing risk in the field by assigning hazard ratings that can be summarized for quick reference. Our customers have found many ways to benefit from this trick and perhaps your team could benefit from this automation!

Setting it Up

1. Navigate to the Forms page in your portal and either edit an existing form or start from scratch.

2. Navigate to an existing table or add a new one.

3. Add a Number field and give it a descriptive name, i.e. “First Floor Count” in our example.

4. Select the gear icon to open Field Settings and add a Default Value of 1. 

5. An optional step is to uncheck Mobile Visible under the More toggle to reduce confusion for users in the field. 

6. On another screen, add a Calculation field and give it a descriptive name, i.e. “First Floor Summary” in our example. 

7. In Field Settings, toggle to Calculation and select the Table Calculation radio button and Sum will automatically be selected. 

8. Under "Sum up values in..." expand the Table drop down and select the table where the count field is located, i.e. "First Floor" in our example.

9. Expand the Column drop down and select the field that will be summarized, i.e. "First Floor Count" in our example.

Now you have a summary field that will count every row in the loop screen. We also have a Webinar where we cover Counts & Summaries with a condition for an extra level of specificity in your count. There are many ways to apply this trick and conditions open up even more possibilities!