Hi All,
I am creating a report on task level where I need to map the user's "Reports To" (Manager name) added into the column next to user name. I do find Manager ID field in the reports directly, however I have no idea how we can map the Manager ID to his name. I assume there must be a text mode script which can help me map the ID to name. Can someone please help me? Sorry this might be a silly question, but I am a beginner and I need some guidance to set this up. Hopefully this will be a great learning for me to build greater reports next time.
Thanks,
Nisha
Solved! Go to Solution.
Views
Replies
Total Likes
May be you can try this text code in one of your column;
valuefield=assignedTo:manager:name
querysort=assignedTo:manager:name
valueformat=HTML
displayname=Manager Name
linkedname=assignedTo
namekey=view.relatedcolumn
namekeyargkey.0=assignedTo
namekeyargkey.1=manager:name
Hi there! The manager ID comes from a user's profile in the 'reports to' field. Is that what you're asking, where that field populates from?
Views
Replies
Total Likes
Hi @Madalyn_Destafney : Yes, the manager ID from User's 'reports to' field.
Views
Replies
Total Likes
Correct. This can pull into a report, as you said. Sorry I think I'm confused about your question. If you're saying it's pulling an ID/numeric value, you can replace 'ID' to ':name' in text mode.
Views
Replies
Total Likes
May be you can try this text code in one of your column;
valuefield=assignedTo:manager:name
querysort=assignedTo:manager:name
valueformat=HTML
displayname=Manager Name
linkedname=assignedTo
namekey=view.relatedcolumn
namekeyargkey.0=assignedTo
namekeyargkey.1=manager:name
Thank you very much, this really helped
Great! changing 'ID' to ':name' is applicable in other ways too, like pulling program name instead of program ID (one of the reports only natively pulls ID, forgetting which at the moment). To help others, please mark the answer correct : )
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies