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

      L
      Leah28850075mvkt
      Level 5
      January 4, 2022

      This is great! I am really unfamiliar with text mode. So what do I need to do if I don't want "Designer:" to show up before the name? I just want the name to appear.

      L
      Leah28850075mvkt
      Level 5
      January 4, 2022

      Nevermind - I think I just figured it out!

      Terms & ConditionsAccessibility statement

      Loading footer...