How to do a group in a report that is based on multiple user name form fields | Community
Skip to main content
Dusty_H
Dusty_H
Level 3
November 18, 2021
Question

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

  • November 18, 2021
  • 1 reply
  • 413 views

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?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    K
    KevinQu1
    Level 10
    November 19, 2021

    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.

    Terms & ConditionsAccessibility statement

    Loading footer...