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

Project report with a custom field from a User?

Avatar

Level 2

Hi,

 

I want to create a project report of all the projects with the requestor and their division.  The division is part of a custom field under users.  I can see it in a user report but not in a project report.  

 

This is the text from the user report.

displayname=
linkedname=direct
namekey=Division
querysort=DE:Division
valuefield=Division
valueformat=customDataLabelsAsString

 

 

Any help much apprecited.

2 Replies

Avatar

Level 9
Level 9

If Division is a field on your User form, and you are wanting to display the Division of the user who submitted the original request before it was converted to a project, this should work: 

displayname=Requester Division
linkedname=convertedOpTask
textmode=true
valuefield=convertedOpTask:owner:DE:Division
valueformat=HTML

Avatar

Level 2

That only sort of worked.  We often have projects where the requestor is added or changed after the request has been converted.

 

I'm looking for using the requestor assigned in workload balancer or on the task tab.

I've been trying something like this but it hasn't worked.

I can see the information on a user report but can't translate it to a project report.

 

displayname=Requester Division
listdelimiter=/
textmode=true
type=iterate
valueexpression=IF(CONTAINS("Requestor / Client",{DE:Division}.{DE:Division}))
valueformat=HTML