Display Home Team Name instead of Home Team ID in a report | Community
Skip to main content
A
AngieSt1
August 27, 2019
Question

Display Home Team Name instead of Home Team ID in a report

  • August 27, 2019
  • 1 reply
  • 602 views
Hello, I am creating a Project Report that I need to download to excel in a list style in order to run some analytics against the Workfront Data. I would like one of the columns to be the Project Owner's Home Team Name. However, I can only find Home Team ID to choose from in the report columns tab. I know that you can use text mode to convert the numeric string of the ID into actual text, but I cannot find the code to do so. Can someone please provide the text mode syntax to do this? Thanks, Angie Stockton Nielsen OH
    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    T
    TimBr1
    Level 4
    August 27, 2019
    Try this: displayname= linkedname=owner namekey=view.relatedcolumn namekeyargkey.0=owner namekeyargkey.1=homeTeam:name querysort=owner:homeTeam:name textmode=true valuefield=owner:homeTeam:name valueformat=HTML Tim Brooks Invicro
    Terms & ConditionsAccessibility statement

    Loading footer...