Jump to content
Sign in to follow this  
TroubleShooter

Hide rows based on Calculated Fields

Recommended Posts

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

Share this post


Link to post
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>

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

 

Hope this helps,

DN31337

Share this post


Link to post
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.

Guest
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.

Loading...
Sign in to follow this  

×
×
  • Create New...