Concat Fields for Project name. | Community
Skip to main content
N
NickSkidmore
Level 3
November 3, 2023
Question

Concat Fields for Project name.

  • November 3, 2023
  • 1 reply
  • 594 views

Hello all,
I'm looking for a way to concatenate the project reference number with the 2 digit year from the planned start date and the project name.
Ex. 12345-23 Project Name
I'm sure it can be done with Fusion but I have not worked in it enough to feel comfortable. Additionally, I would need it to check current projects for this naming first before applying it since we have been and are currently adding this manually to some of the projects.

I appreciate any help that can be provided.

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

    1 reply

    NicholeVargas
    Adobe Employee
    NicholeVargasAdobe Employee
    Adobe Employee
    November 30, 2023

    If you are wanting to see this in a column in a project list / report, you would use the following text mode. You can rename the line for displayname= to whatever you want your column to be called. 

     

    displayname=Reference Number - Planned Start Date (Year) textmode=true valueexpression=CONCAT({referenceNumber}," - ",RIGHT(YEAR({plannedStartDate}),2)) valueformat=HTML

     

    If you wanted to create this as a calculated custom field, it would look like the following on your project custom form (text format) 

     

    CONCAT({referenceNumber}," - ",RIGHT(YEAR({plannedStartDate}),2))

     

    More information on calculated data expressions here.

    Hope that helps! 

    Terms & ConditionsAccessibility statement

    Loading footer...