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.
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
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>:
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>:
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>:
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
Views
Replies
Total Likes
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 for that.
Views
Replies
Total Likes
@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?
Views
Replies
Total Likes
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>:
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>:
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>:
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
Views
Replies
Total Likes
thanks @skyehansen and @Sven-iX this worked and totally misinterpreted what Skye had said earlier in the thread.
Views
Replies
Total Likes