Expand my Community achievements bar.

Hover over pop-up on project report

Avatar

Level 2

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 Reply

Avatar

Level 3

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