Expand my Community achievements bar.

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


Level 3

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.