Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!
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:

Avatar

Level 3

displayname=Producer

listdelimiter=‍

listmethod=nested(projectUsers).lists

textmode=true

type=iterate

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

valueformat=HTML

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 10

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

View solution in original post

4 Replies

Avatar

Correct answer by
Level 10

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

Avatar

Level 7

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.

Avatar

Level 7

Nevermind - I think I just figured it out!