Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

1 Reply

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.