Conditional formatting for SharePoint Online column.

Question

I am working on a SharePoint Online 2016 site collection and need to add conditional formatting to a few drop down fields. The drop down options are: 1: Red, 2: Amber, 3: Green. I want the field in the view to change according to the colour selected But i cannot seem to get it working.

NOTE: I have tried using html formatting and that doesn't work. Also, i am aware that you can change the data return type to number but i need this to remain as a single line of text due to SSIS issues.

I have constructed the following code:

(function () {

// Create object that have the context information about the field that we want to change it's output render 
var StakeholderStatusFiledContext = {};
StakeholderStatusFiledContext.Templates = {};
StakeholderStatusFiledContext.Templates.Fields = {
    // Apply the new rendering for StakeholderStatus field on List View
    "StakeholderStatus": { "View": StakeholderStatusFiledTemplate }
};

SPClientTemplates.TemplateManager.RegisterTemplateOverrides(StakeholderStatusFiledContext);})();

// This function provides the rendering logic for list view
function StakeholderStatusFiledTemplate(ctx) {

var StakeholderStatus = ctx.CurrentItem[ctx.CurrentFieldSchema.Name];

// Return html element with appropriate color based on StakeholderStatus value
switch (StakeholderStatus) {
    case '1) Red':
        return "<span style='color :#f00'>" + StakeholderStatus + "</span>";
        break;
    case '2) Amber':
        return "<span style='color :#ff6a00'>" + StakeholderStatus + "</span>";
        break;
    case '3) Green':
        return "<span style='color :#cab023'>" + StakeholderStatus + "</span>";
}

}

The script has been uploaded to master pages and the link has been inputted to the web part via miscellaneous tab. When i refresh the page, it doesn't seem to do anything which has got me thinking that either my script is incorrect or it has been added to the wrong section. Any ideas?

This is what i am trying to replicate

Answer 1

Refer below code. This will work for you:

Here Status is a field whose color we want to change. And dropdowntest is the dropdown field on basis of which choice will be made.

(Note: Change the field name according to your field. And this code will work for you)

(function () {

      function registerRenderer() {
        var StakeholderStatusFiledContext = {};
        StakeholderStatusFiledContext.Templates = {};

        StakeholderStatusFiledContext.Templates = {
            Fields : {
                'Status': { //------ field whose color you want to change
                    View : function (ctx) {
                      var StakeholderStatus = ctx.CurrentItem.Status;
                      switch(ctx.CurrentItem.dropdowntest){     //------------ value of dropdown on whose basis choice will be made
                        case 'choice1':
                            return "<span style='color :#f00'>" + StakeholderStatus + "</span>";
                            break;
                        case 'choice2':
                            return "<span style='color :#ff6a00'>" + StakeholderStatus + "</span>";
                            break;
                        case 'choice3':
                            return "<span style='color :#cab023'>" + StakeholderStatus + "</span>";
                            break;
                      }
                    }
                },
            }
        };
        SPClientTemplates.TemplateManager.RegisterTemplateOverrides(StakeholderStatusFiledContext);
    }
    ExecuteOrDelayUntilScriptLoaded(registerRenderer, 'clienttemplates.js');


})();

OutPut:

Answer 2

I have been able to solve this. I was adding the JSLink to the miscellaneous section of the Web part properties as by the following: https://wonderlaura.com/2014/09/11/sharepoint-conditional-formatting/

This wouldnt work for me. So i added a content Editor and dragged it to the bottom of the page. In the Content Link section, I added the following link: /sites/ProjectSite/_catalogs/masterpage/Display Templates/Indicators/Color.js. I had to remove the (~). This made my conditional formatting work.

Based on a lot of webpages i have looked at, no one has mentioned adding a content editor. Feel free to shed some light on this area if you have knowledge in it

Answer 3

The below script worked for me in hiding the column:

(function () {

function RemoveFields(ctx) {
    var fieldName = "dropdowntest"; // here dropdowntest is field or column name to be hide
    var header = document.querySelectorAll("[displayname=" + fieldName + "]")[0].parentNode;
    var index = [].slice.call(header.parentNode.children).indexOf(header) + 1;
    header.style.display = "none";
    for (var i = 0, cells = document.querySelectorAll("td:nth-child(" + index + ")"); i < cells.length; i++) {
        cells[i].style.display = "none";
    }
}

  function registerRenderer() {
    var StakeholderStatusFiledContext = {};
    StakeholderStatusFiledContext.Templates = {};

    StakeholderStatusFiledContext.Templates = {
        Fields : {
            'Status': { //------ field whose color you want to change
                View : function (ctx) {
                  var StakeholderStatus = ctx.CurrentItem.Status;
                  switch(ctx.CurrentItem.dropdowntest){     //------------ value of dropdown on whose basis choice will be made
                    case 'choice1':
                        return "<span style='color :#f00'>" + StakeholderStatus + "</span>";
                        break;
                    case 'choice2':
                        return "<span style='color :#ff6a00'>" + StakeholderStatus + "</span>";
                        break;
                    case 'choice3':
                        return "<span style='color :#cab023'>" + StakeholderStatus + "</span>";
                        break;
                  }
                }
            },
        }
    };
StakeholderStatusFiledContext.OnPostRender = RemoveFields;
   SPClientTemplates.TemplateManager.RegisterTemplateOverrides(StakeholderStatusFiledContext);
}
ExecuteOrDelayUntilScriptLoaded(registerRenderer, 'clienttemplates.js');

})();