Dynamically Change Column CSS Styling in a Pivot Table

[CTW2020]

Is it possible to dynamically change the styling of a column or header of a column in a pivot table.  I looked at this article but I don't see an opportunity to insert HTML Blocks or Calculation Fields in Pivot Tables.

https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/how-to-dynamically-change-the-background-of-a-results-page/

In this screenshot, I want to pass in an external parameter called "Visit_Number".  So if Visit_Number=4 then I want the column or at least the header of the column highlighted.  Is this possible?

[TellMeWhy]

You cannot do this through Standard Feature. You need JavaScript if you want it dynamic.

 

Quote

<script type="text/javascript">
document.addEventListener('DataPageReady', function (event) {

   if([@Virtual1] == 1){
document.querySelector("[class^='cbResultSetTableHeader'] th:nth-child(1)").style.backgroundColor = "red";
}

 if([@Virtual1] == 2){
document.querySelector("[class^='cbResultSetTableHeader'] th:nth-child(2)").style.backgroundColor = "yellow";
}

});
</script>

Virtual1 is my Parameter Name

You need to find the class of the tr first, so you can get the th child of that. You may use F12

 

 

 

 

 

[SinJunYoung]

Maybe this can also help? https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/how-to-dynamically-change-the-background-of-a-results-page/