Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!
SOLVED

Hover over pop-up on project report

Avatar

Level 3

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

1 Accepted Solution

Avatar

Correct answer by
Level 5

Hi @Kasey-Gagne 

 

So options are limited but it can be done - with caveats:

  • use HTML
  • use compound columns (joined with sharecol=true)
  • it really pushes the reporting UI - no idea if Adobe decides to strip such HTML

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:

  1. create 3 new columns and move the all the way to the left. 
  2. in the first column paste the below code it will populate and join the 3 columns you created

 

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=&#013; 
column.1.type=iterate
column.2.value=">Hover to see Project Users</div>
column.2.valueformat=HTML
column.2.textmode=true
​

 

 

Result:

tool tip in report.png

View solution in original post

3 Replies

Avatar

Correct answer by
Level 5

Hi @Kasey-Gagne 

 

So options are limited but it can be done - with caveats:

  • use HTML
  • use compound columns (joined with sharecol=true)
  • it really pushes the reporting UI - no idea if Adobe decides to strip such HTML

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:

  1. create 3 new columns and move the all the way to the left. 
  2. in the first column paste the below code it will populate and join the 3 columns you created

 

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=&#013; 
column.1.type=iterate
column.2.value=">Hover to see Project Users</div>
column.2.valueformat=HTML
column.2.textmode=true
​

 

 

Result:

tool tip in report.png

Avatar

Level 5

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=&#013; 
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

tool tip on field in report.png

 

Avatar

Level 3

This is perfect! Thank you SO SO much for your help