[Event Follow-Up] 10 More Text Mode Tips in Adobe Workfront

[NicholeVargas]

Thank you to everyone who joined, asked questions, and shared additional pointers in today's workshop, 10 [More] Text Mode Tips in Adobe Workfront! ​This session was a continuation of the original, 10 Text Mode Tips workshop done in April, so if you're looking for additional examples, check out that post. 

If you missed today's session, no worries, below are links to the recording and slide deck:

• Workshop recording
• Slide Deck PDF - the text mode used for Tip #8: Detailed User View is added as a comment below. 

Examples shared during the workshop include:

• Collections in a Filter
• Custom Prompts
• Show all Templates and Custom Forms
• Detailed User View
• Custom Job #s (calculated custom fields)
• and more! 

If you are just getting started with text mode, I'd recommend bookmarking and familiarizing yourself with the API Explorer (this will be your single source of truth for text mode) and reviewing customer submitted examples in the Reporting Cookbook. In addition, the Customer Support team can help with your text mode questions, but be sure to come prepared with your report already built - give it your best effort! 

If you have additional text mode tips to share, please reply to this post and we can use this discussion as a living text mode tip library for everyone to access! 

Thanks again and we hope to see you at more Customer Success workshops later this year. Be sure to check out the Events page on Experience League for the full list and to register.

[NicholeVargas]

Here is the text mode you can use for Tip #8: Detailed User View. Remember to remove all but the first 2 columns of your user report and add this in the third column:

column.2.displayname=User Information
column.2.sharecol=true
column.2.textmode=true
column.2.value=<font color=000000 face=Agenda><b>Title:&nbsp</b></font>
column.2.valueformat=HTML
column.2.width=400
column.3.displayname=
column.3.linkedname=direct
column.3.namekey=title
column.3.querysort=title
column.3.sharecol=true
column.3.textmode=true
column.3.valuefield=title
column.3.valueformat=HTML
column.4.sharecol=true
column.4.textmode=true
column.4.value=<br><font color=000000 face=Agenda><b>Manager:&nbsp</b></font>
column.4.valueformat=HTML
column.5.displayname=Manager
column.5.linkedname=manager
column.5.namekey=view.relatedcolumn
column.5.namekeyargkey.0=manager
column.5.namekeyargkey.1=name
column.5.querysort=manager:name
column.5.sharecol=true
column.5.textmode=true
column.5.valuefield=manager:name
column.5.valueformat=HTML
column.6.sharecol=true
column.6.textmode=true
column.6.value=<br><font color=000000 face=Agenda><b>Primary Job Role:&nbsp</b></font>
column.6.valueformat=HTML
column.7.displayname=
column.7.namekey=view.relatedcolumn
column.7.namekeyargkey.0=role
column.7.namekeyargkey.1=name
column.7.querysort=role:name
column.7.sharecol=true
column.7.textmode=true
column.7.valuefield=role:name
column.7.valueformat=HTML
column.8.sharecol=true
column.8.textmode=true
column.8.value=<hr><font color=000000 face=Agenda><b>Access Level:&nbsp</b></font>
column.8.valueformat=HTML
column.9.displayname=
column.9.namekey=view.relatedcolumn
column.9.namekeyargkey.0=accessLevel
column.9.namekeyargkey.1=name
column.9.querysort=accessLevel:name
column.9.sharecol=true
column.9.textmode=true
column.9.tile.name=component.accesslevellistview
column.9.valuefield=accessLevel:name
column.9.valueformat=HTML
column.10.sharecol=true
column.10.textmode=true
column.10.value=<br><font color=000000 face=Agenda><b>Home Group:&nbsp</b></font>
column.10.valueformat=HTML
column.11.displayname=Home Group
column.11.linkedname=homeGroupID
column.11.namekey=view.relatedcolumn
column.11.namekeyargkey.0=homeGroup
column.11.namekeyargkey.1=name
column.11.querysort=homeGroup:name
column.11.sharecol=true
column.11.textmode=true
column.11.valuefield=homeGroup:name
column.11.valueformat=HTML
column.12.sharecol=true
column.12.textmode=true
column.12.value=<br><font color=000000 face=Agenda><b>Home Team:&nbsp</b></font>
column.12.valueformat=HTML
column.13.displayname=
column.13.linkedname=homeTeam
column.13.namekey=view.relatedcolumn
column.13.namekeyargkey.0=homeTeam
column.13.namekeyargkey.1=name
column.13.querysort=homeTeam:name
column.13.textmode=true
column.13.valuefield=homeTeam:name
column.13.valueformat=HTML

[NicholeVargas]

Shoutout to @MoniqueEvans for sharing this text mode in the chat! It can be used on a task, issue, or project report to show the latest update, who provided it, and when. It only shows the first 139 characters and then "open for more" if there is more to be read. 

displayname=Latest Update
namekey=latest update
textmode=true
valueexpression=IF(LEN({lastNote}.{noteText})>140, CONCAT(SUBSTR({lastNote}.{noteText},0,139),"...(open for more) -- ",{lastNote}.{owner}.{name}," on ", {lastNote}.{entryDate}), IF(LEN({lastNote}.{noteText})>0, CONCAT({lastNote}.{noteText}," -- ",{lastNote}.{owner}.{name}," on ", {lastNote}.{entryDate})))
valueformat=HTML

[NicholeVargas]

A similar version to shorten your description field to 139 characters: 

textmode=true
valueexpression=IF(LEN({description})>140, CONCAT(SUBSTR({description},0,139),"...(open for more) -- "), IF(LEN({description})>0,
{description}))
valueformat=HTML

[KatherineLa]

In under a day, I had someone bring me an odd filter challenge that #1 was the perfect solution for, and until this class I had never tried filtering by a collection. Thanks for a great session!