TroubleShooter Posted August 15, 2019 Report Share Posted August 15, 2019 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 Quote Link to comment Share on other sites More sharing options...
DefinitelyNot31337 Posted August 15, 2019 Report Share Posted August 15, 2019 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.