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
Solved! Go to Solution.
Views
Replies
Total Likes
Hey @HTSchlegel -
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.
Hey @HTSchlegel -
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.
Hi Daniel,
That worked perfectly! Thanks so much.
Heather
Views
Replies
Total Likes
Views
Likes
Replies