Text Mode Help | Adobe Higher Education
Skip to main content
N
NaushinWa
Level 3
October 21, 2020
해결됨

Text Mode Help

  • October 21, 2020
  • 1 답변
  • 1972 조회

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!

    이 주제는 답변이 닫혔습니다.
    최고의 답변: 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 답변

    R
    Community Advisor
    Richard_Le_Community Advisor답변
    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
      NaushinWa작성자
      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
      NaushinWa작성자
      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...

      약관 및 조건Accessibility statement

      Loading footer...