Hide calculated column in view but still have it run its code

Question

I have a task list with a calculated column that includes some code to change the background color of the list items based on their priority value, see below

Is there a way to hide the calculated column from the view but still have it run its code, if I remove the column from the view then obviously it won't run the code to color the list

Any help would be appreciated, thanks

=[Priority] 
&"<img src=""/_layouts/images/blank.gif"" onload=""{" 
&"var row=this;while(row.tagName!='TR'){row=row.parentNode}"
&"row.style.backgroundColor='#" 
&CHOOSE( RIGHT( LEFT( [Priority] , 2) , 1) , "F78181" , "BCF5A9" , "F3F781" , "81B1F8") 
&"'}"">"

Answer 1

Why not exclude the original Priority1 Column from the list, and wrap your Calculated Column in

<div style="text-align:left">
 ...
</div>

Now that is something CSR can not do..
With CSR You need the value displayed in the View in order to work with it.

You loose the fance sorting and filtering, so I usually display another less meaningfull column in the Calculated Column

You can also leave it blank, and/or even add code to hide the whole column (after it executed)

If you are moving to CSR - Client Side Rendering

Then at least write a function as generic as possible

• no fieldname dependency
• no language dependency

• no external Image file dependencies

  function priorityFieldTemplate(ctx) {
      var fieldValue = ctx.CurrentItem[ctx.CurrentFieldSchema.Name],
          colorIndex=fieldValue.match(/(\d+)/g),//(extract x from '(x) Label'
          color=['none','red','orange','green','brown'][colorIndex],
          circleSize=15,
          H="<svg height={0} width={0}><circle cx={1} cy={1} r={1} fill='{2}'/></svg>";
      return String.format( H , circleSize, circleSize/2, color);
  }
  

ICSR

Answer 2

I had similar task. I had to show multiline text field/column shorten. I did that with additional column that was calculated field and I hid it with help of javascript. Add script webpart page and in it just hide that class and that is all.

Answer 3

As Akhoy says, I personally recommend js-link.

Here are two links where you should see how it is done:

https://code.msdn.microsoft.com/office/Client-side-rendering-code-0a786cdd

and a blog post from myself (Statuscolumn changed to traffic light icons):

https://blog.afrait.com/traffic-light-column-in-custom-list-en/

Here the script, tried to match your requirements a little:

<script>    
(function () {
        var statusFieldCtx = {};


        statusFieldCtx.Templates = {};
        statusFieldCtx.Templates.Fields = {
            "Priority1": {
                "View": StatusFieldViewTemplate
            }
        };

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

    function StatusFieldViewTemplate(ctx) {

        var _statusValue = ctx.CurrentItem.Priority1;

         if (_statusValue == '(1) High')
         {
             return "<img src='http://sp13/teams/PublishingImages/Ampel/red.png'/>";
         }

         if (_statusValue == '(2) Normal')
         {
             return "<img src='http://sp13/teams/PublishingImages/Ampel/yellow.png'/>";
         } 

         if (_statusValue == '(3) Low')
         {
             return "<img src='http://sp13/teams/PublishingImages/Ampel/green.png'/>";
         }   

         if (_statusValue == '(4) Done')
         {
         return "<img src='http://sp13/teams/PublishingImages/Ampel/brown.png'/>";
         } 

    }
</script>

Maybe you will decide to choose js-link in the future. Also you can still sort and filter by the status column. See here: