Is there a way to display multiple users home group/team names in a view? | Community
Skip to main content
K
KatherineCh
Level 2
September 17, 2020
Question

Is there a way to display multiple users home group/team names in a view?

  • September 17, 2020
  • 1 reply
  • 1025 views

We are trying to create a view that includes the home group/team of the assigned users. At the moment, we can only get it to pull in the home group/team name of the primary contact. We would like to have the home group/team name of all users assigned to the task/request. Does anyone know how 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

    imgrund
    Adobe Employee
    imgrundAdobe Employee
    Adobe Employee
    September 18, 2020

    I have a field in a view that is Home Team and hours for the users.

    displayname=Assignment Breakdown

    listdelimiter=<br>

    listmethod=nested(assignments).lists

    textmode=true

    type=iterate

    valueexpression=CONCAT({assignedTo}.{name}," (",{assignedTo}.{homeTeam}.{name},") - ",{workRequired}/60,IF({workRequired}/60>ABS(1)," Hours"," Hour"))

    valueformat=HTML

    Hope that helps

      K
      KatherineChAuthor
      Level 2
      September 18, 2020

      You are amazing! Thank you so much!

      For those wondering, I used the following to display only the Home Team:

      displayname=Home Team

      listdelimiter=<br>

      listmethod=nested(assignments).lists

      textmode=true

      type=iterate

      valueexpression={assignedTo}.{homeTeam}.{name}

      valueformat=HTML

      imgrund
      Adobe Employee
      imgrundAdobe Employee
      Adobe Employee
      September 18, 2020

      Word of warning - I see you are not displaying the assignees' names as well. Just so you know, the sorting on collections is not always consistent. I had a local agency admin try where the name and job role were in two different columns, but they didn't always match up. (Meaning the first job role listed didn't match the first assignee listed). So you might want to do a combined column.

      Terms & ConditionsAccessibility statement

      Loading footer...