Looking for text mode for job roll assignments column in project report | Community
Skip to main content
DeborahLeigh123
New Participant
January 17, 2024
Solved

Looking for text mode for job roll assignments column in project report

  • January 17, 2024
  • 1 reply
  • 1069 views

Hello There - Is there text code for a column in a projects report to display a summary of all the assignments in the project? Thank You!

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

You can try this.

 

displayname=Task Job Roles
listdelimiter=<div>
listmethod=nested(roles).lists
namekey=jobrole.plural
textmode=true
type=iterate
valuefield=name
valueformat=HTML

 

This gives a list of all job role assignments in the project

1 reply

KellieGardner
KellieGardnerAccepted solution
New Participant
January 17, 2024

You can try this.

 

displayname=Task Job Roles
listdelimiter=<div>
listmethod=nested(roles).lists
namekey=jobrole.plural
textmode=true
type=iterate
valuefield=name
valueformat=HTML

 

This gives a list of all job role assignments in the project

DeborahLeigh123
New Participant
January 18, 2024

Thank you! Is there a way to add the assigned people to the job role in the project? This is great for listing just the job roles. I'd love to be able to see who's assigned. And, if they aren't assigned, it's just the job role listed. Thank you so much!

KellieGardner
New Participant
January 18, 2024

I don't believe you could pull those details together in a project report, it would be too many jumps of where/how the data is stored. You could get the assignment string of those assigned to tasks in one column and then the list of job roles but I don't know of a way you could align them into a single column as they each reference different stored objects. Essentially, what we are doing with this is reporting on a collection of data that is linked to another object. 

 

Does it need to be a project report? An Assignment report might be more beneficial to get that data since it will break down if multiple users are assigned to a task and you can report on each assignees details or even a task report with collection references to assignments might be able to get you there.