Question

How to get the Total Number of Sets in a Collection

Forms Version 10 How To

Updated January 17

asked on May 19, 2021

What is the easiest way to get the total number of sets in a Collection (.mycollection) and set that value into another field (.count)? In the example below, the Total # of Attendees (.count) field would say 3 since there are three sets of data fields.

1 0

Answer

SELECTED ANSWER

replied on May 19, 2021

You could use a formula to count the number of non-empty values in one of the columns

=COUNTIF(Collection.Variable,"<> ")

Or you could add a hidden field to track the row number using the formula

=ROW()

And then for your Total use the following

=MAX(Collection.RowVariable)

2 0

replied on January 17 • Show version history

COUNTIF did not work for me. I had to change it to COUNT, then it worked great, also I did not have to put in the "<>". It counted that field in my collection set only if it had been filled.

=COUNT(Collection.Variable)

0 0

Replies

replied on May 19, 2021

Thanks again Jason! I used =COUNTIF(Collection.Variable,"<> ") and it worked perfectly.

1 0

You are not allowed to follow up in this post.

Question

Question

How to get the Total Number of Sets in a Collection

Answer

Replies

Sign in to reply to this post.