Need to map user ID to user name in reports using text mode | Community
Skip to main content
N
NishaPatel
Level 3
May 8, 2023
Solved

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

  • May 8, 2023
  • 4 replies
  • 1671 views

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

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 Kundanism

@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

4 replies

Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity Advisor
Community Advisor
May 8, 2023

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 : )
N
NishaPatelAuthor
Level 3
May 9, 2023

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

Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity Advisor
Community Advisor
May 9, 2023

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 : )
Kundanism
KundanismAccepted solution
Level 10
May 9, 2023

@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

    N
    NishaPatelAuthor
    Level 3
    May 10, 2023

    Thank you very much, this really helped 🙂

      Madalyn_Destafney
      Community Advisor
      Madalyn_DestafneyCommunity Advisor
      Community Advisor
      May 10, 2023

      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 : )
      Terms & ConditionsAccessibility statement

      Loading footer...