Hello group, I want to be able to pull in a Project level typahead field into a task level report. Anyone know the text mode? Thanks!Tim | Community
Skip to main content
T
TimBr1
Level 4
June 9, 2020
Question

Hello group, I want to be able to pull in a Project level typahead field into a task level report. Anyone know the text mode? Thanks!Tim

  • June 9, 2020
  • 2 replies
  • 1066 views

Have a person typeahead field we call analysis lead. I would want to add this project level field into a task level report.

Thanks!

Tim

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    2 replies

    D
    Adobe Employee
    DustinMaAdobe Employee
    Adobe Employee
    June 10, 2020

    Hello Tim,

    On a Task report, you can search for the project level field when adding a new column.

    Or, you can use basic text mode such as this:

    valuefield=project:Field Name querysort=DE:project:Field Name valueformat=customDataLabelsAsString displayname=Project level custom field

    Best of luck!

    imgrund
    Adobe Employee
    imgrundAdobe Employee
    Adobe Employee
    June 10, 2020

    Hi @Dustin Martin‚ -

    I tried your code and I got back the below. Is there a way to just get the name?

    {"objCode":"USER","name":"Anthony Imgrund","ID":"532376910024d8443277c3e46ed5330a"}

    imgrund
    Adobe Employee
    imgrundAdobe Employee
    Adobe Employee
    June 10, 2020

    Huh... that's interesting. It doesn't seem to be tied to the actual project object type so you can't just reference it.

    I tried both:

    1. valuefield=project:Account Lead/Supervisor:name
    2. valueexpression={project}.{DE:Account Lead/Supervisor}.{name}

    Just in case anyone else has other ideas. ;)

    D
    Adobe Employee
    DustinMaAdobe Employee
    Adobe Employee
    June 10, 2020

    Ya know, I had it wrong.

    I remember now, too.

    You have to have a calculated field at the same level as the typeahead field, that calls to it.

    {Typeahead field name:name}

    It'll look like this: https://drop.workfront.com/YEup8R2b

    Then your task report will look like this:

    https://drop.workfront.com/nOueYojE

    With the column looking like this (though I built it via the GUI, I just switched to text mode to display the example.): https://drop.workfront.com/v1ueAbZz

    imgrund
    Adobe Employee
    imgrundAdobe Employee
    Adobe Employee
    June 10, 2020

    OH! Duh! So funny, I have a calculated field on my project for Portfolio Name and Program Name, and totally didn't think about doing that for Typeahead. Thanks, Dustin!

    Terms & ConditionsAccessibility statement

    Loading footer...