How to Count Rows in a Table or Loop Screen in the Builder

Counting the rows in a Table or Loop Screen is a popular workaround that only takes a few steps to set up.

Count Rows in a Table

This can be applied to many different scenarios but some examples include:

• Counting passed and/or failed inspection items,
• Counting correct answers in a quiz (alternatively, this can also be done with Reference Data),
• 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. Below is step-by-step instructions for counting every row of a table or loop screen. This solution requires one Number field and one Calculation field.

1. Locate an existing Table or Loop Screen or create a new one.
2. Add a Number field to the Table or Loop Screen and on a proceeding Screen, add a Calculation field, using your preferred method.

   Note

   The calculation field must be placed on a separate screen located after the table or loop screen in order to properly count every row.

3. Label both the number field and calculation field something descriptive (i.e. "First Floor Count" and "First Floor Summary" in our example).
4. Select the number field to open the Field Settings in the left panel and add a Default Value of 1.
5. Expand the Advanced menu and click the blue toggle beside Mobile Visible to hide the field on mobile.

   

6. Select the calculation field to open the Field Settings in the left panel.
7. Click Sum next to Calculation Type.
8. Sum Field will appear below Calculation Type in the Field Settings. Expand the drop down and scroll to find the table or loop screen where the count field is located (i.e. "First Floor" in our example).
9. Select the number field we configured above (i.e. "First Floor Count" in our example).

   

Now you have a field that will summarize every row in a table or loop screen. Save and Test in your browser or Publish to test on mobile.