Need help with a view field. Trying to pull specific Role ID out of a Project Users and display in Project report. Where have I gone wrong? I've tried a few variations of below: | Community
Skip to main content
J
JaneSt1
Level 2
July 1, 2020
Solved

Need help with a view field. Trying to pull specific Role ID out of a Project Users and display in Project report. Where have I gone wrong? I've tried a few variations of below:

  • July 1, 2020
  • 1 reply
  • 1040 views

displayname=Producer

listdelimiter=‍

listmethod=nested(projectUsers).lists

textmode=true

type=iterate

valueexpression=IF({role}.{ID}="5dbb54400030340ee1511ad57582e6e7",CONCAT("Producer:"," ",{name}),"")

valueformat=HTML

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

    You were close. The issue is that for the Project Users object, you can only reference the project, customer, or user. So you needed to go to the user first before you could get to role ID or name.

    Try

    displayname=Producer

    listdelimiter=<div>

    listmethod=nested(projectUsers).lists

    textmode=true

    type=iterate

    valueexpression=IF({user}.{roleID}="5dbb54400030340ee1511ad57582e6e7",CONCAT("Producer:"," ",{user}.{name}),"")

    valueformat=HTML

    1 reply

    imgrund
    Adobe Employee
    imgrundAdobe EmployeeAccepted solution
    Adobe Employee
    July 2, 2020

    You were close. The issue is that for the Project Users object, you can only reference the project, customer, or user. So you needed to go to the user first before you could get to role ID or name.

    Try

    displayname=Producer

    listdelimiter=<div>

    listmethod=nested(projectUsers).lists

    textmode=true

    type=iterate

    valueexpression=IF({user}.{roleID}="5dbb54400030340ee1511ad57582e6e7",CONCAT("Producer:"," ",{user}.{name}),"")

    valueformat=HTML

      J
      JaneSt1Author
      Level 2
      July 2, 2020

      GENIUS!! Thank you so much.

      Terms & ConditionsAccessibility statement

      Loading footer...