Project report with a custom field from a User? | Community
Skip to main content
MegFl
Level 2
Oct 25, 2022 6:16 PM UTC

Project report with a custom field from a User?

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.

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

2 replies

William--
William--
New Participant
Oct 26, 2022 2:28 PM UTC

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
Translate
If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf
MegFlAuthor
Level 2
Oct 26, 2022 7:14 PM UTC

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

Translate
Terms & ConditionsAccessibility statement

Loading footer...