Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

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 4

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.