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.
해결되었습니다! 솔루션으로 이동.
토픽은 커뮤니티 콘텐츠를 분류하여 관련성 있는 콘텐츠를 찾는 데 도움이 됩니다.
조회 수
답글
좋아요 수
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
조회 수
답글
좋아요 수
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.
조회 수
답글
좋아요 수
@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?
조회 수
답글
좋아요 수
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
조회 수
답글
좋아요 수
thanks @skyehansen and @Sven-iX this worked and totally misinterpreted what Skye had said earlier in the thread.
조회 수
답글
좋아요 수