Jump to content

Hide rows based on Calculated Fields

Recommended Posts



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,


Link to comment
Share on other sites

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>

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


Hope this helps,


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...