Count Unique Values in Repeat Field

Blevins_Mark — Wed, 18 Dec 2024 17:31:31 GMT

How can you return the count of unique values in a repeat?

Repeat question is geopoint.
Based on where user clicks on map i am pulling both town and county using pulldata function.
I then have two questions in parent table...number of locations and number of counties.
I want the total # of locations, so simply use the count function to get that.
I want the county count to be unique...so if there are 5 repeat locations, and 3 are in smith county and 2 are in webb county, the count for the county field should be 2.

Thanks

Re: Count Unique Values in Repeat Field

abureaux — Thu, 19 Dec 2024 23:09:45 GMT

Maybe javascript could help here.

Built-in features is a little more annoying, but may still be possible.

I quickly tossed this together:

It excludes the current item, and checks for that current item in a string.