Expand my Community achievements bar.

SOLVED

Displaying the name of a merged column field within the row

Avatar

Level 3

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.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 6

@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

View solution in original post

4 Replies

Avatar

Community Advisor

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.

Avatar

Level 3

@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?

Avatar

Correct answer by
Level 6

@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

Avatar

Level 3

thanks @skyehansen and @Sven-iX  this worked and totally misinterpreted what Skye had said earlier in the thread.