How to pull in Home Team ID name vs code in report grouping

Question

Created a task report, filtering and grouping by Home Team ID. However, the groupings are showing as a random string of numbers and letters. Any way to pull in the actual Home Team ID so we know which drop down is which?

skyehansen · Accepted Answer

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/grouping-project-report-by-requestor-home-team-name/m-p/493620

while you're able to edit your grouping to pull in the home team name, you'll find that there are downstream problems with this, like not being able to make a chart, or perhaps not being able to see it in a summary view. So I'd like to recommend that you consider putting a custom form on your users that will record their home team name and then group by that field.

Madalyn_Destafney · Answer

This is an easy text mode switch to get name instead of ID. Go to the text mode of the grouping and where it says homeTeamID, you're changing it to homeTeam:name. Like this:

textmode=true
group.0.linkedname=assignedTo
group.0.namekey=view.relatedcolumn
group.0.valuefield=assignedTo:homeTeam:name
group.0.namekeyargkey.0=assignedTo
group.0.namekeyargkey.1=homeTeam:name
group.0.valueformat=string

Sign up

Login with SSO

Login to the community

Login with SSO