Hi,
I have a repeating group that is currently filtered by a single Dropdown containing a “Status” Option Set (7 options). Very basic setup–nothing fancy.
I’d like to add to the ‘Option caption’ the number of items each “Status” contains. I managed to do it using individual searches in the option caption, but this seems a bit slow and inefficient, even on a fairly small database. Is there a better way to do this?
I played around with doing a custom state and some advanced filtering, but couldn’t get something that validated.