How do I include multiple Project custom fields into a single column in a Task Report | Community
Skip to main content
J
JeremiahBo
Level 2
December 7, 2020
Solved

How do I include multiple Project custom fields into a single column in a Task Report

  • December 7, 2020
  • 2 replies
  • 622 views

I have a task report that I need to surface a few project custom fields. I am hoping to use a CONCAT to add a number of the fields together into a single column in the report, but I'm sure I have my syntax messed up. This is what I have so far.

displayname=Test Domain Releases

listdelimiter=<div>

listmethod=nested(project).lists

textmode=true

type=iterate

usewidths=true

valueexpression=CONCAT{DE:Test Domains Enabled},": ",{DE:Release Cadence})

valueformat=HTML

width=200

    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 Jeremiah,

    The text mode you have is for a collection (something that is one to many). If I understand your request, you need to reference as a task only belongs to one project, not many.

    (You'd use a collection if you were doing a Project report and wanted to have info from various tasks into one column)

    Try...

    displayname=Test Domain Releases

    textmode=true

    valueexpression=CONCAT({project}.{DE:Test Domains Enabled},": ",{project}.{DE:Release Cadence})

    valueformat=HTML

    width=200

    2 replies

    imgrund
    Adobe Employee
    imgrundAdobe EmployeeAccepted solution
    Adobe Employee
    December 7, 2020

    Hi Jeremiah,

    The text mode you have is for a collection (something that is one to many). If I understand your request, you need to reference as a task only belongs to one project, not many.

    (You'd use a collection if you were doing a Project report and wanted to have info from various tasks into one column)

    Try...

    displayname=Test Domain Releases

    textmode=true

    valueexpression=CONCAT({project}.{DE:Test Domains Enabled},": ",{project}.{DE:Release Cadence})

    valueformat=HTML

    width=200

      J
      JeremiahBoAuthor
      Level 2
      December 7, 2020

      Thanks, Anthony and Sarah,

      This works!

      S
      SarahNa
      Level 6
      December 7, 2020

      Hey Jeremiah,

      Try this:

      displayname=Test Domain Releases

      textmode=true

      usewidths=true

      valueexpression=CONCAT({project}.{DE:Test Domains Enabled},": ",{project}.{DE:Release Cadence})

      valueformat=HTML

      width=200

      Hope that helps!

        Terms & ConditionsAccessibility statement

        Loading footer...