Fill and font colors in the column headers in view and user reports | Community
Skip to main content
esalraz
esalraz
Level 2
May 29, 2024
New

Fill and font colors in the column headers in view and user reports

  • May 29, 2024
  • 4 replies
  • 945 views

Description -Text formatting only applies to data within the columns in project view and user reports and cannot be applied to column headers and it looks like that is why change the color in the headers is not possible.

 

Why is this feature important to you - Our organization wants to stop using excel and have everything in workfront however custom the column headers like excel is not possible.

 

How would you like the feature to work - Change fill and font colors in the headers using an option or the text formatting.

 

Current Behavior - Header in the project views and user reports are not customizable filled color is gray and font color is black.

    4 replies

    RandyRoberts
    Community Advisor
    RandyRobertsCommunity Advisor
    Community Advisor
    May 29, 2024

    You could always wrap it in html like this:

     

    esalraz
    esalrazAuthor
    Level 2
    May 29, 2024

    Thanks @randyroberts 

     

    Could you share how to wrap it in html? is it in the text formatting mode? I would like to keep those colors every time I use my custom view.

    RandyRoberts
    Community Advisor
    RandyRobertsCommunity Advisor
    Community Advisor
    May 29, 2024

    Here's the code for the first column "Entry Details":

    column.0.sharecol=true column.0.shortview=true column.0.textmode=true column.0.value=<style>hr.slatebluegrey {border: 1px solid #546e7a; border-radius: 2px} </style><div style="color: #ffffff; padding: 3px 0px 4px 10px; border-radius:4px 4px 0px 0px; font-weight: bold; background-color: #546e7a;; font-size: 11pt;">Entry Details</div><div style="padding:12px 16px 12px 16px; border-radius:0px 0px 4px 4px; border-left: 1px solid #9e9e9e; border-right: 1px solid #9e9e9e; border-bottom: 1px solid #9e9e9e; font-size:11pt;">Name: &nbsp;<strong> column.0.valueformat=HTML column.0.width=300 column.1.linkedname=direct column.1.namekey=name column.1.querysort=name column.1.sharecol=true column.1.shortview=true column.1.textmode=true column.1.valuefield=name column.1.valueformat=HTML column.2.sharecol=true column.2.shortview=true column.2.textmode=true column.2.value=</strong><br>Entry Date: &nbsp;<strong> column.2.valueformat=HTML column.3.sharecol=true column.3.shortview=true column.3.textmode=true column.3.usewidths=true column.3.valuefield=entryDate column.3.valueformat=fullAtDate column.4.sharecol=true column.4.shortview=true column.4.textmode=true column.4.value=</strong>&nbsp; by: &nbsp;<strong> column.4.valueformat=HTML column.5.linkedname=enteredBy column.5.namekey=view.relatedcolumn column.5.namekeyargkey.0=enteredBy column.5.namekeyargkey.1=name column.5.querysort=enteredBy:name column.5.sharecol=true column.5.shortview=true column.5.textmode=true column.5.valuefield=enteredBy:name column.5.valueformat=HTML column.6.sharecol=true column.6.shortview=true column.6.textmode=true column.6.value=</strong><br>Template used: &nbsp; column.6.valueformat=HTML column.7.linkedname=template column.7.namekey=view.relatedcolumn column.7.namekeyargkey.0=template column.7.namekeyargkey.1=name column.7.querysort=template:name column.7.sharecol=true column.7.shortview=true column.7.textmode=true column.7.valuefield=template:name column.7.valueformat=HTML column.8.sharecol=true column.8.shortview=true column.8.textmode=true column.8.value=<br>URL: &nbsp; column.8.valueformat=HTML column.9.link.url=URL column.9.linkedname=html(URL) column.9.sharecol=true column.9.textmode=true column.9.valueexpression=IF(ISBLANK({URL}),"","Open") column.9.valueformat=HTML column.10.link.url=customDataLabelsAsString(SYS Converted Issue Project URL) column.10.sharecol=true column.10.textmode=true column.10.valueexpression=IF(ISBLANK({DE:SYS Converted Issue Project URL}),"","Open") column.10.valueformat=HTML column.11.sharecol=true column.11.shortview=true column.11.textmode=true column.11.value=<style>hr.slatebrowngrey {border: 1px solid #7a6054; border-radius: 2px} </style><hr class="slatebrowngrey">Original Request: &nbsp;<strong> column.11.valueformat=HTML column.12.linkedname=convertedOpTask column.12.namekey=view.relatedcolumn column.12.namekeyargkey.0=convertedOpTask column.12.namekeyargkey.1=name column.12.querysort=convertedOpTask:name column.12.sharecol=true column.12.shortview=true column.12.textmode=true column.12.valuefield=convertedOpTask:name column.12.valueformat=HTML column.13.sharecol=true column.13.shortview=true column.13.textmode=true column.13.value=<br></strong>Request Entry: &nbsp;<strong> column.13.valueformat=HTML column.14.linkedname=direct column.14.namekey=convertedOpTaskEntryDate column.14.querysort=convertedOpTaskEntryDate column.14.sharecol=true column.14.shortview=true column.14.textmode=true column.14.valuefield=convertedOpTaskEntryDate column.14.valueformat=fullAtDate column.15.sharecol=true column.15.shortview=true column.15.textmode=true column.15.value=</strong>&nbsp; by: &nbsp;<strong> column.15.valueformat=HTML column.16.linkedname=convertedOpTask column.16.namekey=view.relatedcolumn column.16.namekeyargkey.0=convertedOpTask column.16.namekeyargkey.1=owner column.16.sharecol=true column.16.shortview=true column.16.textmode=true column.16.valuefield=convertedOpTask:owner:name column.16.valueformat=HTML column.17.sharecol=true column.17.shortview=true column.17.textmode=true column.17.value=<br></strong>Request Resides in Project: &nbsp; column.17.valueformat=HTML column.18.sharecol=true column.18.shortview=true column.18.textmode=true column.18.valuefield=convertedOpTask:project:name column.18.valueformat=HTML column.19.sharecol=true column.19.shortview=true column.19.textmode=true column.19.value=<br>Entry Point: &nbsp; column.19.valueformat=HTML column.20.linkedname=convertedOpTask column.20.namekey=view.relatedcolumn column.20.namekeyargkey.0=convertedOpTask column.20.namekeyargkey.1=displayQueueBreadcrumb column.20.sharecol=true column.20.shortview=true column.20.textmode=true column.20.valuefield=convertedOpTask:displayQueueBreadcrumb column.20.valueformat=HTML column.21.sharecol=true column.21.shortview=true column.21.textmode=true column.21.value=</strong><hr class="slatebrowngrey">Preview/Update Form Data:<strong><br> column.21.valueformat=HTML column.22.linkedname=direct column.22.namekey=category.name column.22.shortview=true column.22.textmode=true column.22.tile.name=component.objectcategories column.22.valuefield=customFormsNames column.22.valueformat=HTML column.22.viewalias=category.name
    V
    VynetaRy
    Level 2
    December 30, 2024

    @randyroberts  have you ever created column formats like these where the background color of the header bar could be changed based on conditions in the report? For instance, I have figured out how to inject column header text values, but I haven't figured out how I might change colors on the fly as well. I would like for the Teams to be able to set not only their header text, but the color used as well, without having to edit the text mode code.

     

     

     

     

     

     

    Terms & ConditionsAccessibility statement

    Loading footer...