Need to map user ID to user name in reports using text mode

[NishaPatel]

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

[Madalyn_Destafney]

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?

[NishaPatel]

Hi @Madalyn_Destafney : Yes, the manager ID from User's 'reports to' field.

[Madalyn_Destafney]

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.

[Kundanism · Accepted solution]

@NishaPatel 

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

[NishaPatel]

Thank you very much, this really helped

[Madalyn_Destafney]

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 : )