How to set display rules in text mode | Community
Skip to main content
M
MichaelPe1
Level 5
July 22, 2021
Question

How to set display rules in text mode

  • July 22, 2021
  • 3 replies
  • 1150 views

I am trying another approach to call out the differences in a grouping on a report. I have added a column for the project priority and added an IF statement to display what I want based on the priority chosen. But I would like to color it Red if Red Alert (priority 4) is chosen. I tried to borrow some code from another column that had display rules but it's not working. Can someone help?

Here is what I have:

styledef.case.0.comparison.icon=false

styledef.case.0.comparison.leftmethod=project:priority

styledef.case.0.comparison.lefttext=project:priority

styledef.case.0.comparison.operator=eq

styledef.case.0.comparison.operatortype=type

styledef.case.0.comparison.righttext=4

styledef.case.0.comparison.trueproperty.0.name=fontstyle

styledef.case.0.comparison.trueproperty.0.value=bold

styledef.case.0.comparison.trueproperty.1.name=textcolor

styledef.case.0.comparison.trueproperty.1.value=ffffff

styledef.case.0.comparison.trueproperty.2.name=bgcolor

styledef.case.0.comparison.trueproperty.2.value=ff0000

styledef.case.0.comparison.truetext=

textmode=true

valueexpression=IF({project}.{priority}=4,"RED ALERT TOP PRIORITY",IF({project}.{priority}=3,"DUE TODAY",""))

valueformat=HTML

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

3 replies

skyehansen
Community Advisor
skyehansenCommunity Advisor
July 22, 2021

I'm not sure I'm parsing your question. What result are you trying to achieve and why can't it be achieved by just setting two rules on the column one after the other, as explained here: https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FReports_and_Dashboards%2FReports%2FReporting_Elements%2Fuse-conditional-formatting-views.html&_LANG=en

(why are we in text mode?)

M
MichaelPe1Author
Level 5
July 22, 2021

I am in text mode because I previously altered the wording that displayed using an If statement. Now I want to alter the color if Priority of 4 was selected to make that field Red with white text.

SamanthaIsin
SamanthaIsin
Level 7
July 22, 2021

I don't believe you can throw style rules onto text created from an if statement, but why don't you just use the show text option in the column rules and color it top priorities red? You can do it using the rule builder or your text mode would look like this:

textmode=false

valuefield=priority

valueformat=val

enumclass=com.attask.common.constants.TimelinePriorityEnum

linkedname=direct

namekey=priority

querysort=priority

type=enum

case.0.comparison.leftmethod=priority

case.0.comparison.lefttext=priority

case.0.comparison.righttext=4

case.0.comparison.operator=in

case.0.comparison.icon=false

case.0.comparison.truetext=RED ALERT TOP PRIORITY

case.1.comparison.leftmethod=priority

case.1.comparison.lefttext=priority

case.1.comparison.righttext=3

case.1.comparison.operator=in

case.1.comparison.icon=false

case.1.comparison.truetext=DUE TODAY

styledef.case.0.comparison.leftmethod=priority

styledef.case.0.comparison.lefttext=priority

styledef.case.0.comparison.righttext=4

styledef.case.0.comparison.operator=in

styledef.case.0.comparison.icon=false

styledef.case.0.comparison.truetext=RED ALERT TOP PRIORITY

styledef.case.0.comparison.trueproperty.0.name=fontstyle

styledef.case.0.comparison.trueproperty.0.value=bold

styledef.case.0.comparison.trueproperty.1.name=textcolor

styledef.case.0.comparison.trueproperty.1.value=d30519

styledef.case.1.comparison.leftmethod=priority

styledef.case.1.comparison.lefttext=priority

styledef.case.1.comparison.righttext=3

styledef.case.1.comparison.operator=in

styledef.case.1.comparison.icon=false

styledef.case.1.comparison.truetext=DUE TODAY

I believe this will achieve exactly what you're looking for, just a little simpler to execute.

M
MichaelPe1Author
Level 5
July 22, 2021

I couldn't get this code to work (it displayed the word normal) But I had forgotten about the show text option. I was able to accomplish what I needed using that. Thank You

SamanthaIsin
SamanthaIsin
Level 7
July 22, 2021

The only thing I don't like about this solution is that you can't inline edit your priorities anymore. If you only need this specific adjustment to display in one or two places I would leave it, but if this is a universal thing by group I would change the names of your group priorities in setup.

Terms & ConditionsAccessibility statement

Loading footer...