Using the New Builder?
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.
- Navigate to the Forms page in your portal and either edit an existing form or start from scratch.
- Add a new screen and loop it, or select the inner screen of an existing loop screen.
- Add a Number field and give it a descriptive name, i.e. “First Floor Count” in our example.
- In the Field Settings, add a Default Value of 1.
- An optional step is to uncheck Mobile Visible under the More menu to reduce confusion for users in the field.
- On another screen, add a Summary field and give it a descriptive name, i.e. “First Floor Summary” in our example.
- In Field Settings, the Summary Screen is where the field is located, i.e. “First Floor” in our example.
- The Summary Field will automatically populate with the first number field in the screen, which is “First Floor Count” in our example.
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!
Comments
0 commentsPlease sign in to leave a comment.