Putting Project Owner HomeTeam Name in a Calculated Field | Community
Skip to main content
M
Mylah_D
Level 4
February 14, 2023
Solved

Putting Project Owner HomeTeam Name in a Calculated Field

  • February 14, 2023
  • 1 reply
  • 757 views

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.
    Best answer by Madalyn_Destafney

    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 : )

    1 reply

    Madalyn_Destafney
    Community Advisor
    Madalyn_DestafneyCommunity AdvisorAccepted solution
    Community Advisor
    February 14, 2023

    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 : )
      M
      Mylah_DAuthor
      Level 4
      March 7, 2023

      Thank you so much!

        Terms & ConditionsAccessibility statement

        Loading footer...