Custom Rules in Report Views | Community
Skip to main content
SamanthaIsin
SamanthaIsin
Level 7
Sep 18, 2020 12:12 AM UTC
Solved

Custom Rules in Report 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.
    imgrund
    imgrundAccepted solution
    Employee
    Sep 18, 2020 2:41 PM UTC

    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

    View reply

    4 replies

    imgrund
    imgrundAccepted solution
    Employee
    Sep 18, 2020 2:41 PM UTC

    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

    Translate
      SamanthaIsin
      SamanthaIsinAuthor
      Level 7
      Sep 18, 2020 2:50 PM UTC

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

      Translate
      imgrund
      imgrund
      Employee
      Sep 18, 2020 3:26 PM UTC

      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

      Translate
      JoeSalas
      JoeSalas
      Level 3
      Sep 18, 2020 2:40 PM UTC

      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.

      Translate
        Terms & ConditionsAccessibility statement

        Loading footer...