Text Mode Help | Community
Skip to main content
N
NaushinWa
October 21, 2020
Solved

Text Mode Help

  • October 21, 2020
  • 1 reply
  • 1954 views

I am wondering if anyone can help provide direction on this - I have two brand fields - CSBrand and BrandDepartmentNonAutomation that are used by a team. The team would like to see the Brand on their dashboard, and I was wondering if there's a way to merge data from both fields into one in the dashboard? so if CSBrand is Blank, Display BrandDepartmentNonAutomation? I am really a novice when it comes to text mode, so wondering how to do this.

Thank you for any help or guidance!

    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 Richard_Le_

    Hi Naushin,

    Yes this is possible within a report view. You would need to add a column to your view, switch it to text mode and add the following text mode code:

    displayname=Brand

    textmode=true

    valueexpression=IF(ISBLANK({DE:CSBrand}),{DE:BrandDepartmentNonAutomation},{DE:CSBrand})

    valueformat=customDataLabelsAsString

    Best Regards,

    Rich

    1 reply

    R
    Community Advisor
    Richard_Le_Community AdvisorAccepted solution
    Community Advisor
    October 21, 2020

    Hi Naushin,

    Yes this is possible within a report view. You would need to add a column to your view, switch it to text mode and add the following text mode code:

    displayname=Brand

    textmode=true

    valueexpression=IF(ISBLANK({DE:CSBrand}),{DE:BrandDepartmentNonAutomation},{DE:CSBrand})

    valueformat=customDataLabelsAsString

    Best Regards,

    Rich

      N
      NaushinWaAuthor
      October 21, 2020

      THANK YOU so much, Rich!

      Terms & ConditionsAccessibility statement

      Loading footer...