Skip to main content
Mylah_D
Level 4
Feb 14, 2023 5:34 PM UTC
Solved

Putting Project Owner HomeTeam Name in a Calculated Field

I'd like to put the Project Owner's Home Team Name in a Calculated field in a Form at the Project Level. This is to make it easy for our end users to create a report where the value is ready for them to use without having to go into Text Mode. 

 

I've tried text mode in the calculated field expression, but can't seem to figure out the correct expression for a calculated field that will allow me to get from Project to OwnerID to HomeTeamID to Team Name. Is this supported in Forms? 

 

Thank you!

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Madalyn_Destafney
    Madalyn_DestafneyAccepted solution
    Community Advisor
    Feb 14, 2023 6:55 PM UTC

    This is absolutely possible! Add a calculated field (text format) to your project form(s) with this expression:

    {owner}.{homeTeam}.{name}

     
    I tested to be sure, and getting correct result. If this is what you're looking for, please mark this answer correct to help others : )
    If this helped you, please mark correct to help others : )
    View in thread

    2 replies

    Madalyn_Destafney
    Community Advisor
    Madalyn_DestafneyCommunity AdvisorAccepted solution
    Community Advisor
    Feb 14, 2023 6:55 PM UTC

    This is absolutely possible! Add a calculated field (text format) to your project form(s) with this expression:

    {owner}.{homeTeam}.{name}

     
    I tested to be sure, and getting correct result. If this is what you're looking for, please mark this answer correct to help others : )
    Translate
    If this helped you, please mark correct to help others : )
      Mylah_DAuthor
      Level 4
      Mar 7, 2023 5:44 AM UTC

      Thank you so much!

      Translate
        Terms & ConditionsAccessibility statement

        Loading footer...