Categories in Text Mode Reporting Nested List | Community
Skip to main content
Mikaela-Newell
Mikaela-Newell
Level 3
May 29, 2025
Solved

Categories in Text Mode Reporting Nested List

  • May 29, 2025
  • 1 reply
  • 408 views

Hi all! I'm working on a project report, and have added a column with the following text mode code:

displayname=People listdelimiter=<div> listmethod=nested(projectUsers).lists type=iterate valueexpression=CONCAT("• ",{user}.{role}," — ",{user}.{name}) valueformat=HTML

I've used this basic setup in other reports too. It gives me something like

• Design Operations — [user1]

• Designer — [user2]

• Copywriter — [user3]

• Designer — [user4]

etc etc

 

I'd like it to instead give me

• Design Operations — [user1]

• Designer — [user2], [user4]

• Copywriter — [user3]

 

Bonus points if you tell me how to put {user}.{role} — in bold!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by skyehansen

hi, I'm not sure if this is old information to you or not, but your current text mode "iterates" (loops through the entire list of users) and for each user gives you the role and the user name. There's no way to group a set of users under one role name unless you break it apart and iterate for all the roles separately.

 

This might look like a gigantic IF statement (e.g. If the role = designer, concat the names and separate with commas; If the role = copywriter, concat the names and separate with commas; etc.), or in order to get the role names to bold, you might need to break it up across multiple columns, format separately, and then join them together using sharecol.

1 reply

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe ChampionAccepted solution
May 29, 2025

hi, I'm not sure if this is old information to you or not, but your current text mode "iterates" (loops through the entire list of users) and for each user gives you the role and the user name. There's no way to group a set of users under one role name unless you break it apart and iterate for all the roles separately.

 

This might look like a gigantic IF statement (e.g. If the role = designer, concat the names and separate with commas; If the role = copywriter, concat the names and separate with commas; etc.), or in order to get the role names to bold, you might need to break it up across multiple columns, format separately, and then join them together using sharecol.

    Mikaela-Newell
    Mikaela-NewellAuthor
    Level 3
    May 29, 2025

    Ohhh I see! Makes sense. I'll try this tonight and post an update — thank you!

    Terms & ConditionsAccessibility statement

    Loading footer...