hiding a column in a report datapage based on a parameter

[VA123]

Depending on what location is associated with a user(a column in the user table - the parameter), I would like to selectively hide a specific column in a report datapage. I am able to get Caspio to hide the column as desired on the preview Caspio page , but when deployed, Caspio seems to ALWAYS hide the column, regardless of the Country condition. Could you please take a look? This is where the datapage is deployed: https://dsmtest001.weebly.com/testjsreport.html. There are 2 user accounts-> 
1. user1@test.com | 12341234 - Country is USA
2. user2@test.com | 12341234 - Country is Canada
Column B should be hidden for the USA user but not the Canadian user. 
The selective functionality is achieved through the following code, inserted in the header of the report datapage:
<script>
alert('[@authfield:Country]' +' is the current country ' + ' -> going to hide column/row B if country is USA');
if ('[@authfield:Country]' === 'USA') {
document.getElementById('targetxxx').innerHTML = "<style>#targetxxx table:nth-of-type(1) td:nth-of-type(2) {display: none;} </style>";
document.getElementById('targetxxx').innerHTML = "<style>#targetxxx table:nth-of-type(1) th:nth-of-type(2) {display: none;} </style>";
}
</script>

<div id="targetxxx">
and the below inserted in the footer:
</div>

Last but not least, attached is the sample Caspio app

CaspioData_2019-Feb-25_2157.zip

[Andrii]

Hello!

Please find the application attached.
Take a look at datapage named "Testing JS Report_TEST_1"
I have made the example with 2 columns.

This code can be adjusted depends on the amount of columns you have in the table

Let me know if you have any questions.

CaspioData_2019-Feb-28_0954.zip

[Vindy]

Hi

I hope you could help me with my issue. I'm trying to hide tabular report columns based on the search criteria,  I have a search page with few different search criteria, at the moment once you select your search criteria and hit search it passes parameters to the tabular report page and it outputs data to  a tabular report.  but it displays all of the columns in the report page, What Iwant to do is to hide columns that are not related to the selected search, Is this something possible. I am on the basic Caspio plan.

Would love to hear ideas, fixes from anyone

Many Thanks

 

[Hastur]

Hello @Vindy

Can you elaborate a bit more on the condition of the hiding?
Also, I can not import your tables attached. Please try to make another export with dependencies to let me upload datapages in my account.   

[Vindy]

Hi Andrew,

Thanks for the response, please check these attached exports and I  have attached some screen captures of the scenario to give you bit more context. 

Many thanks,

Vindy

CaspioData_2019-May-14TEST.zip explain.docx

[Hastur]

@Vindy

I have checked your tables.
I think that using JS in your case will be very inefficient. The code will be huge, slow and unmanageable.
You should try to change the table structure to make it more normalized.

Check these articles to get familiar with normalization of tables:
https://howto.caspio.com/tables-and-views/relationships/
https://en.wikipedia.org/wiki/Database_normalization

 

[Kurumi]

Hi - Just to add, if you want to hide a column in a Pivot Report - you can use this code: