Hi,
I have an hour report that I would like to add the manager name so we can filter or sort. I am able to pull in the manager id for a user but not seeing a field for a name. Does anyone know how the manager name can be shown instead of the id?
Thanks
Heather
Hey @heatherte -
You can change any ID to a Name by using Text Mode. Edit your report, click your ID column, Click "Switch to Text Mode" in the top right, then paste this in.
displayname= Manager Name
linkedname=owner
namekey=view.relatedcolumn
namekeyargkey.0=owner
namekeyargkey.1=managerID
querysort=owner:managerID
textmode=true
valuefield=owner:manager:name
valueformat=HTML
On a user or project level report (where you are not jumping databases) can simply revise the "managerID" to be "manager.name" to get the same effect.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.