I need to identify the assigned Project Manager in our company projects. I am trying to create that column in a view but can't seem to find the correct text mode fields/sequences for this. Has anyone done this or similar designation by role in projec

Thank you all for the input! I was able to get a code snippet for this! It can be changed to designate any role. You would have to change the role ID numerical string in the valueexpression line and of course the display name. We may take out the bulleted list option but at the moment it helps with multiple PM's on larger projects and we are happy with how this turned out!

displayname=Designer(s)

listdelimiter=<div>

listmethod=nested(projectUserRoles).lists

textmode=true

type=iterate

valueexpression=IF({roleID}='5099307b0034c9a378f9fd7434914b9c',CONCAT("•",{user}.{name}))

valueformat=HTML

Gotcha!

My recommendation would be to use a custom field on the project's custom form. We use it for Account Lead and Finance Contact. You have two options:

1. Just create a single line of text field
2. Use the Typeahead field and have it set to look at your users

Personally I like Option 2 because then you don't have to worry about spelling errors or nicknames being used. Please you can build reports to easily filter on the PM.

However, if you ever have two PMs, you will need to use options 1 as the typeahead field only allows one option.

Once you have the custom field created on the form, you will then see it "out of the box" in your choices on reports.

First question: Is the project manager not the Project Owner?

Secondly, if the are the Project Owner, what object type are you looking at?

If it is a list of projects, the valuefield=owner:name (which should be out of box though, so you might not need text mode)

If you are looking at a list of tasks or issues, you want the valuefield to be valuefield=project:owner:name

Hope that helps. Let me know if that doesn't quite cover it. :)