Text Mode to use the Display name instead of the (DE:) Backend name | Community
Skip to main content
J
Julian_Thuraisingham
Level 2
November 13, 2024
Question

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

  • November 13, 2024
  • 1 reply
  • 748 views

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

 

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

    1 reply

    Srinija_N
    Srinija_N
    Level 7
    November 14, 2024

    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.

     

    J
    Julian_ThuraisinghamAuthor
    Level 2
    November 14, 2024

    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.

    Terms & ConditionsAccessibility statement

    Loading footer...