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

Text Mode Help

  • October 21, 2020
  • 1 reply
  • 1972 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
      Level 3
      October 21, 2020

      I'm being a little greedy here, but is there any way I can utilize a similar logic to display a chart/graph that shows all issues by Brand but somehow the system very smartly sums up all the requests for the same brand across both fields? As a rule, BrandDepartmentNonAutomation will be filled out only if CSBrand is blank. But I have no idea how to show total by Brand in a chart form if the brand is pulling from two fields...

      N
      NaushinWaAuthor
      Level 3
      October 26, 2020

      Thank you so much again, Rich! What if there was a third field that would activate for brand if the option selected in CSBrand or BrandDepartmentNonAutomation = Other? The Other Brand is a free form text field that users can enter brands not in the drop-down. How would I add that to the calculation?

      I really need to go back to math class...

      Terms & ConditionsAccessibility statement

      Loading footer...