Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

How to do a group in a report that is based on multiple user name form fields


Level 2

I have a custom form that has multiple Typeahead fields referencing users. (user1; user2; user3) I have a report but i want to group them by the user names.

So if there were 4 instances of John H. it would group them together no matter if his name was entered in some or all of those custom fields (user1, user2 or user3).

is there a way to do this?


Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply


Level 10

I have an idea, but it is clunky (using a CONCAT field, then a calculated field using CONTAINS); I want to see if the Community has something easier or more direct.