Forum Discussion

Brass Contributor

Jan 29, 2018

Solved

Sharepoint Conditional Formatting

Hi All, I am trying to find Json code for SharePoint online 365 columns in a custom list: If columnX = "no" make the column bold TIA, Joe

developer

sharepoint 365

Joe Fischer
Jan 31, 2018
Hi Nigel,

Yes a small bit of Json in the column formatting does the trick :)

Below is an example, @faustocapellanjr sent me...

Thanks again for your help.

Joe

{
   "$schema": "http://columnformatting.sharepointpnp.com/columnFormattingSchema.json",
   "txtContent": "@currentField",
   "elmType": "div",
   "style": {
       "font-weight": {
           "operator": "?",
           "operands": [
               {
                   "operator": "==",
                   "operands": [
                       "@currentField",
                       "No"
                   ]
               },
               "bold",
               ""
           ]
       }
   }
}

Nigel Witherdin

Iron Contributor

Jan 29, 2018

Hi, You probably need to use a Field Customizer for this (and that way no that it will work in modern pages as well as classic). A good write-up of the process is at: https://docs.microsoft.com/en-us/sharepoint/dev/spfx/extensions/get-started/building-simple-field-customizer You will need to change the code in the onRenderCell to check for your "No" value and then add the appropriate style class. Cheers, Nigel

Joe Fischer

Brass Contributor

Jan 29, 2018

Thanks Nigel,

I will look into that. I didnt expect it to be so complex. I figured I could just add some Json Code in the coumn Formatting in the column settings.

Thanks again,

Joe

Nigel Witherdin
Iron Contributor
Jan 31, 2018
It might be possible to do something with the Column Formatting (Ive never really used it) but the Field Customizer is probably the best way to customize the rendering of any field, and be confident that it will work in Modern SharePoint pages
- Joe Fischer
  Brass Contributor
  Jan 31, 2018
  Hi Nigel,
  
  Yes a small bit of Json in the column formatting does the trick :)
  
  Below is an example, @faustocapellanjr sent me...
  
  Thanks again for your help.
  
  Joe
  
  {
     "$schema": "http://columnformatting.sharepointpnp.com/columnFormattingSchema.json",
     "txtContent": "@currentField",
     "elmType": "div",
     "style": {
         "font-weight": {
             "operator": "?",
             "operands": [
                 {
                     "operator": "==",
                     "operands": [
                         "@currentField",
                         "No"
                     ]
                 },
                 "bold",
                 ""
             ]
         }
     }
  }
  - Nigel Witherdin
    Iron Contributor
    Jan 31, 2018
    nice one! Will have to look into what you can do with column formatting a little more