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...

      R
      Community Advisor
      Richard_Le_Community Advisor
      Community Advisor
      October 21, 2020

      Hi Naushin,

      No problem, happy to help! Yes this is also possible, but to achieve it you would need to create a calculated custom data field and add it to your custom form. You would need to use the following code for the calculation:

      IF(ISBLANK(CSBrand,(BrandDepartmentNonAutomation),CSBrand)

      This would only work on new issues that you create (which have the custom form attached). In order for historic issues to be updated with the calculated values, you would need to ensure that you select 'recalculate custom expressions' on each of the issues. You can do this by selecting all objects, bulk editing them and choosing 'recalculate custom expressions' as shown in the screen shot attached.

      Once this has been done, you would need to use the newly created calculated custom field in your reports (make sure you group by the field in your report if you want to use it in a chart).

      There is a great article on Workfront one here on how to do this

      Hope this helps!

      Best Regards,

      Rich.

        Terms & ConditionsAccessibility statement

        Loading footer...