Expand my Community achievements bar.

SOLVED

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

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Level 10

@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

View solution in original post

6 Replies

Avatar

Community Advisor

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?

If this helped you, please mark correct to help others : )

Avatar

Level 2

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

Avatar

Community Advisor

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.

If this helped you, please mark correct to help others : )

Avatar

Correct answer by
Level 10

@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

Avatar

Community Advisor

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

If this helped you, please mark correct to help others : )