Displaying the name of a merged column field within the row | Community
Skip to main content
O
OmahaOmaha
Level 4
November 4, 2024
Solved

Displaying the name of a merged column field within the row

  • November 4, 2024
  • 1 reply
  • 731 views

I'm trying to figure out a way to display the name of a merge column in the report field.  For example, lets say I want to display the task name, primary assignment and due date in one field. I already know how to merge the fields and create line breaks, however I'm trying to get the following text to display in the merged column:

 

Task Name: "name"

Primary Assignment: "name"

Due Date: "date"

 

I want the name of the merge column to display before the actual input from that field if that makes sense.

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 Sven-iX

@omahaomaha 

don't touch the field columns. Just add the columns Skye mentioned. 

column.0.sharecol=true column.0.textmode=true column.0.value=<b>Task Name</b>:&nbsp; column.0.valueformat=HTML column.1.descriptionkey=name column.1.isInlineEditable=false column.1.link.linkproperty.0.name=ID column.1.link.linkproperty.0.valuefield=ID column.1.link.linkproperty.0.valueformat=int column.1.link.lookup=link.view column.1.link.valuefield=objCode column.1.link.valueformat=val column.1.linkedname=direct column.1.listsort=string(name) column.1.namekey=task.name.abbr column.1.querysort=name column.1.section=0 column.1.sharecol=true column.1.shortview=false column.1.stretch=100 column.1.textmode=true column.1.valuefield=name column.1.valueformat=HTML column.1.width=250 column.2.sharecol=true column.2.textmode=true column.2.value=<br/><b>Primary Assignment</b>:&nbsp; column.2.valueformat=HTML column.3.displayname= column.3.linkedname=primaryAssignment column.3.namekey=view.relatedcolumn column.3.namekeyargkey.0=primaryAssignment column.3.namekeyargkey.1=assignedTo:name column.3.sharecol=true column.3.textmode=true column.3.valuefield=primaryAssignment:assignedTo:name column.3.valueformat=HTML column.4.sharecol=true column.4.textmode=true column.4.value=<br/><b>Due Date</b>:&nbsp; column.4.valueformat=HTML column.5.displayname= column.5.linkedname=direct column.5.namekey=plannedCompletionDate column.5.querysort=plannedCompletionDate column.5.textmode=true column.5.valuefield=plannedCompletionDate column.5.valueformat=atDate

1 reply

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
November 4, 2024

The method used is the same as what you would use for a line break. So if your linebreak column looks like this:

value=<br>

valueformat=HTML

width=1

sharecol=true

 

your title column could look like this:

value=<br>Primary Assignment:

valueformat=HTML

width=1

sharecol=true

 

Or it could look like this:

value=Task Name: 

valueformat=HTML

width=1

sharecol=true

 

You also need to put in html to make a "space". I think I usually use &nbsp; for that.

O
OmahaOmahaAuthor
Level 4
November 4, 2024

@skyehansen all the fields I'm trying to combine have a valueformat=customDataLabelsAsString, when I change them to HTML they return nothing back, just the name of the category.  Do you know why that is?

Sven-iX
Community Advisor
Sven-iXCommunity AdvisorAccepted solution
Community Advisor
November 5, 2024

@omahaomaha 

don't touch the field columns. Just add the columns Skye mentioned. 

column.0.sharecol=true column.0.textmode=true column.0.value=<b>Task Name</b>:&nbsp; column.0.valueformat=HTML column.1.descriptionkey=name column.1.isInlineEditable=false column.1.link.linkproperty.0.name=ID column.1.link.linkproperty.0.valuefield=ID column.1.link.linkproperty.0.valueformat=int column.1.link.lookup=link.view column.1.link.valuefield=objCode column.1.link.valueformat=val column.1.linkedname=direct column.1.listsort=string(name) column.1.namekey=task.name.abbr column.1.querysort=name column.1.section=0 column.1.sharecol=true column.1.shortview=false column.1.stretch=100 column.1.textmode=true column.1.valuefield=name column.1.valueformat=HTML column.1.width=250 column.2.sharecol=true column.2.textmode=true column.2.value=<br/><b>Primary Assignment</b>:&nbsp; column.2.valueformat=HTML column.3.displayname= column.3.linkedname=primaryAssignment column.3.namekey=view.relatedcolumn column.3.namekeyargkey.0=primaryAssignment column.3.namekeyargkey.1=assignedTo:name column.3.sharecol=true column.3.textmode=true column.3.valuefield=primaryAssignment:assignedTo:name column.3.valueformat=HTML column.4.sharecol=true column.4.textmode=true column.4.value=<br/><b>Due Date</b>:&nbsp; column.4.valueformat=HTML column.5.displayname= column.5.linkedname=direct column.5.namekey=plannedCompletionDate column.5.querysort=plannedCompletionDate column.5.textmode=true column.5.valuefield=plannedCompletionDate column.5.valueformat=atDate
Terms & ConditionsAccessibility statement

Loading footer...