Custom Rules in Report Views | Community
Skip to main content
SamanthaIsin
Level 7
September 18, 2020
Solved

Custom Rules in Report Views

  • September 18, 2020
  • 2 replies
  • 882 views

I would like to display the field 'Resolve Project:Name' in a green cell only when the name of the converted project is different than the name of original request.

Help? Is there any way to do custom rules? I don't see an option for text mode.

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 imgrund

Hi - this was a fun challenge :)

Here you go

valuefield=resolveProject:name

querysort=resolveProject:name

valueformat=HTML

displayname=Resolve Project

linkedname=resolveProject

namekey=view.relatedcolumn

namekeyargkey.0=resolveProject

namekeyargkey.1=name

styledef.case.0.comparison.leftmethod=resolveProject:name

styledef.case.0.comparison.lefttext=resolveProject:name

styledef.case.0.comparison.rightmethod=name

styledef.case.0.comparison.righttext=name

styledef.case.0.comparison.operator=notin

styledef.case.0.comparison.operatortype=string

styledef.case.0.comparison.icon=false

styledef.case.0.comparison.truetext=

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=000000

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

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

2 replies

JoeSalas
Level 3
September 18, 2020

Hi Samantha,

Could use the 'Reference Number' fields (vs. names) to compare the differences between the two numbers. If they are different then color the cell green.

imgrund
Adobe Employee
imgrundAdobe EmployeeAccepted solution
Adobe Employee
September 18, 2020

Hi - this was a fun challenge :)

Here you go

valuefield=resolveProject:name

querysort=resolveProject:name

valueformat=HTML

displayname=Resolve Project

linkedname=resolveProject

namekey=view.relatedcolumn

namekeyargkey.0=resolveProject

namekeyargkey.1=name

styledef.case.0.comparison.leftmethod=resolveProject:name

styledef.case.0.comparison.lefttext=resolveProject:name

styledef.case.0.comparison.rightmethod=name

styledef.case.0.comparison.righttext=name

styledef.case.0.comparison.operator=notin

styledef.case.0.comparison.operatortype=string

styledef.case.0.comparison.icon=false

styledef.case.0.comparison.truetext=

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=000000

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

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

SamanthaIsin
Level 7
September 18, 2020

@Anthony Imgrund‚ How did you learn to do this? This is fantastic

imgrund
Adobe Employee
Adobe Employee
September 18, 2020

Well, I have a view that compares Actual Completion date to Planned Completion date and I just adjusted it. Not sure where I initially learned but I'm sure it was from someone here on the community site or from a Leap presentation a few years ago. :)

Best part of being a Workfront client, everyone is so forthcoming with help and sharing