Hide rows based on Calculated Fields

[TroubleShooter]

Hi,

 

Is there any way to hide rows on a Tabular report based on the value of a Calculated Field?

 

I was hoping I could set this up on the Filter Criteria in the DataPage but I was told by Caspio Support that this is currently not possible. They advised to sort the Calculated Field from top to bottom (to put the null-values at the bottom) then use JavaScript to highlight the blank records. Any thoughts on how to hide the whole row instead of just highlighting it?

 

Any help is appreciated. Thanks,

TS

[DefinitelyNot31337]

Hello @TroubleShooter,

 

Here is a slightly modified version of the script I got from this article: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/how-to-dynamically-change-the-background-of-a-results-page/

 

<div id="hide-this-[@cbRecordIndex]"></div>

<script>
var isi = document.getElementById("hide-this-[@cbRecordIndex]");
if('[@calcfield:1]' == ''){
 isi.parentNode.parentNode.style.display = 'none';
}
</script>

 

Hope this helps,

DN31337