Program/Portfolio name on Issue custom form using calculated field | Community
Skip to main content
_Manish_Singh
_Manish_Singh
Level 9
June 7, 2022
Solved

Program/Portfolio name on Issue custom form using calculated field

  • June 7, 2022
  • 2 replies
  • 2104 views

Hello,

I'm trying to bring Program/Portfolio names on Issue custom form because text mode grouping (on Program/Portfolio - Issue report) doesn't allow Summary and Charting option.

By using API explorer, I'm able to come up with: {project}.{program}.{name} but it doesn't work. Kindly help!

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

Hi Manish, so close! For Calculated Fields though, you don't use the "tech name" or camel-case. Just the regular name.

For Program... Project.Program.Name

For Portfolio... Project.Portfolio.Name

SIDE NOTE for people who change names for objects: If you rename an object in your terminology setting, the text mode in the report is the same program:name, but for Calculated Fields it uses the new name Campaign.Name

Took me forever to figure that out so want to save people time on that. LOL!

2 replies

imgrund
Adobe Employee
imgrundAdobe EmployeeAccepted solution
Adobe Employee
June 7, 2022

Hi Manish, so close! For Calculated Fields though, you don't use the "tech name" or camel-case. Just the regular name.

For Program... Project.Program.Name

For Portfolio... Project.Portfolio.Name

SIDE NOTE for people who change names for objects: If you rename an object in your terminology setting, the text mode in the report is the same program:name, but for Calculated Fields it uses the new name Campaign.Name

Took me forever to figure that out so want to save people time on that. LOL!

    _Manish_Singh
    _Manish_SinghAuthor
    Level 9
    June 7, 2022

    Ahh.. the first line in this article under Syntax section mislead me: The new Workfront experience | Calculated data expressions. However, the table shows correct info.

    ‚

    "To add a calculated data expression to a custom field on a task form for the Project Name, you use the following text: {project}.{name}"

    ‚

    Thank you! 🙂

    ‚

    imgrund
    Adobe Employee
    imgrundAdobe Employee
    Adobe Employee
    June 7, 2022

    Yeah, I can totally see why that is misleading. They were trying to talk about the fact you didn't need valuefield or valueexpression, but the overall syntax is still wrong.

    @Jonathan Chen‚ - Can we ask someone to please correct this? The table underneath the Tip is correct, but as Manish pointed out, right above it where it says "To add a calculated data expression to a custom field on a task form for the Project Name, you use the following text:" is should say Project.Name

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity Advisor
    Community Advisor
    June 7, 2022

    Hi Anthony and Manish,

    Following, and interested. From the upcoming New syntax for calculations in custom fields video, once it is released, I expect that any (old) formulas with Project.Program.Name will be automatically converted to (new) formulas with {project}.{program}.{name}, and that the latter will then become the norm. I'm not clear whether, at that time, typing Project.Program.Name will then also be automatically converted to {project}.{program}.{name} (e.g. "on the fly"), or whether Project.Program.Name will be treated as an error (e.g. as a Teachable Moment). Also -- thanks for mentioning it, Anthony -- I'd forgotten about the "Campaign.Name" edge case for folks who've changed names for objects, so would expect that (old) functionality to still be the (new) case, with Campaign.Name being translated to {campaign}.{name}...but in the edgier edge case of then renaming the rename (e.g. from Campaign to Initiative), could also see how converting Campaign.Name to {program}.{name} could also be valid.

    I'll ping @Lilit Mkrtchyan‚ to see if she can share some wisdom with us on these.

    Regards,

    Doug

      M
      Miranda_Davis
      Level 3
      October 18, 2022

      I am trying to display program information on a project form with a calculated field, and I cannot get either to work. Example below. The field is on the program form called "Additional Regions". 

       

      {project}.{program}.{DE:Additional Regions}

      Project.Program.{DE:Additional Regions}

       

      Both are saying it's an invalid expression. 

      Terms & ConditionsAccessibility statement

      Loading footer...