We're currently using text mode on a project report to list all people involved in the project (code below). Sometimes this list is rather long and can make the report look clunky. Is there a way to have this replaced with an icon or text that reads Project Team that you could hover over to display as a pop up with the list of users instead? Any help is appreciated
description=Project Team
displayname=Project Team
listdelimiter=<div>
listmethod=nested(projectUsers).lists
textmode=true
type=iterate
valueexpression=CONCAT("- ",{user}.{name})
valueformat=HTML
Solved! Go to Solution.
Views
Replies
Total Likes
Hi @Kasey-Gagne
So options are limited but it can be done - with caveats:
Below is the code to get the compound column to show a tool tip with the project users on hover.
It uses the feature that a "title" attribute in a tag becomes a tool tip that shows when you hover over the tag. I am using a "div" tag here.
Steps:
column.0.displayname=Project team list
column.0.sharecol=true
column.0.textmode=true
column.0.valueformat=HTML
column.0.value=<div style="cursor: pointer; text-align:center; background-color: #efe;" title="
column.1.displayname=Project Team
column.1.listmethod=nested(projectUsers).lists
column.1.description=Project Team
column.1.sharecol=true
column.1.valueformat=HTML
column.1.valueexpression="- "+{user}.{name}
column.1.textmode=true
column.1.listdelimiter=
column.1.type=iterate
column.2.value=">Hover to see Project Users</div>
column.2.valueformat=HTML
column.2.textmode=true
Result:
Hi @Kasey-Gagne
So options are limited but it can be done - with caveats:
Below is the code to get the compound column to show a tool tip with the project users on hover.
It uses the feature that a "title" attribute in a tag becomes a tool tip that shows when you hover over the tag. I am using a "div" tag here.
Steps:
column.0.displayname=Project team list
column.0.sharecol=true
column.0.textmode=true
column.0.valueformat=HTML
column.0.value=<div style="cursor: pointer; text-align:center; background-color: #efe;" title="
column.1.displayname=Project Team
column.1.listmethod=nested(projectUsers).lists
column.1.description=Project Team
column.1.sharecol=true
column.1.valueformat=HTML
column.1.valueexpression="- "+{user}.{name}
column.1.textmode=true
column.1.listdelimiter=
column.1.type=iterate
column.2.value=">Hover to see Project Users</div>
column.2.valueformat=HTML
column.2.textmode=true
Result:
Hey @Kasey-Gagne
If you want to be adventurous, you can include e.g. the name field in the compound column like so: Wrap the div around the name - the benefit is that since name is a link, we get the neat pointer cursor
Create 5 columns at the very left and paste
column.0.sharecol=true
column.0.valueformat=HTML
column.0.value=<div title="
column.0.displayname=Project team list
column.0.textmode=true
column.1.listdelimiter=
column.1.valueformat=HTML
column.1.listmethod=nested(projectUsers).lists
column.1.valueexpression="- "+{user}.{name}
column.1.displayname=Project Team
column.1.sharecol=true
column.1.textmode=true
column.1.description=Project Team
column.1.type=iterate
column.2.value=">
column.2.textmode=true
column.2.sharecol=true
column.2.valueformat=HTML
column.3.link.linkproperty.0.valuefield=ID
column.3.link.linkproperty.0.valueformat=int
column.3.link.linkproperty.0.name=ID
column.3.link.lookup=link.view
column.3.link.valueformat=val
column.3.link.valuefield=objCode
column.3.descriptionkey=name
column.3.linkedname=direct
column.3.sharecol=true
column.3.listsort=string(name)
column.3.section=0
column.3.shortview=false
column.3.stretch=30
column.3.querysort=name
column.3.namekey=name.abbr
column.3.valueformat=HTML
column.3.textmode=true
column.3.width=250
column.3.valuefield=name
column.4.value=</div>
column.4.textmode=true
column.4.valueformat=HTML
Result
Views
Replies
Total Likes
This is perfect! Thank you SO SO much for your help
Views
Replies
Total Likes
Views
Likes
Replies