How to Count Rows in a Loop Screen in Legacy Builder

Have more questions? Submit a request

A neat trick that many GoCanvas users have implemented in their forms is counting rows in a Table. 

Count Rows in a 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.

  1. Navigate to the Forms page in your portal and either edit an existing form or start from scratch.
  2. Add a new screen and loop it, or select the inner screen of an existing loop screen.
  3. Add a Number field and give it a descriptive name, i.e. “First Floor Count” in our example.
  4. In the Field Settings, add a Default Value of 1. AFB_Counts&Summaries_Default Value.png
  5. An optional step is to uncheck Mobile Visible under the More menu to reduce confusion for users in the field.
  6. On another screen, add a Summary field and give it a descriptive name, i.e. “First Floor Summary” in our example.
  7. In Field Settings, the Summary Screen is where the field is located, i.e. “First Floor” in our example.
  8. The Summary Field will automatically populate with the first number field in the screen, which is “First Floor Count” in our example. AFB_Counts&Summaries_Summary Field.png

Now you have a summary field that will count every row in the loop screen.

GoCanvas Tip

GoCanvas experts presented a Webinar where we cover Counts & Summaries with a condition for an extra level of specificity in your count.

Did we answer your question?

Please let us know by voting below. All we ask is if you downvote, please let us know how the content can be improved in the comments!

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share

Comments

0 comments

Please sign in to leave a comment.