Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

Text Mode to use the Display name instead of the (DE:) Backend name

Avatar

Level 2

Hi,

When I am using text mode and I am trying to create a filter using a field that is not WF native I use the "DE" field. My understanding is "DE" is at the beginning of any fields that were created by your business. So when I am trying to use Text Mode or create a formula, you need to include the "DE:" to select the filed I want, but what if I want to display the display label rather then the backend name. 

Example: 

CONCAT({DE:Program 1 Number},".",IF(LEN({DE:Project 1 Number})<2,"00",{DE:Project 1 Number})),"_",{DE:Division Program Code})
 
If I wanted the Program code (section in bold) to display the label instead of the backend name what would I put?
 
Thanks,
Julian

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Level 7

Below is the text mode we used for columns(view), not for filter though, to display the column label in bold font.

 

Text mode:

column.8.displayname=Section
column.8.sharecol=true
column.8.textmode=true
column.8.valueformat=
column.9.displayname=Section Type
column.9.sharecol=true
column.9.textmode=true
column.9.value=<br><strong><font color=#000000>Section Type: </font></strong>
column.9.valueformat=HTML
column.10.displayname=Section Type
column.10.linkedname=direct
column.10.namekey=Section Type
column.10.querysort=DE:Section Type
column.10.textmode=true
column.10.valuefield=Section Type
column.10.valueformat=customDataLabelsAsString

 

This is how it would look.

Sri_Nijs_0-1731578463153.png

 

Avatar

Level 2

Sorry, I didn't mean I wanted that text in bold I was just trying to show the part of the formula I want to show the Display label rather then the DE value.