rgiljohann

I have done this in the past by duplicating my app. I then make the changes in the duplicated app for testing purposes. After everything is done, what you could do is export the new app as Caspio XML format, and then import and replace it to your existing app provided all of the naming conventions are the same. The alternative to importing would be to change your datapages to the new ones.

Below is what I was hoping to have as my record level security fields. I was hoping to have the county from my auth table match with the county from my data table. The problem is it only picks up the first one if there are multiple per user.

I am looking for a way to allow record level security with multiple records per user without a name/email field. I found a way to do this through views, however, my data table is 10 GB, so if I have two users that have access to all records, then the data will be 20 GB, and I will be out of space. With this method, I envision my storage would be well over 100 GB when I only have 15 GB of space. Below is my Authentication Table. I have two records for the same user because I want them to have access to the two different County Records (Waukesha and Milwaukee). The county field is also in the data table. I was hoping to use the County fields as the record level security field, however, the datapage only shows the records with the first record from the Auth table. In this case, it only shows the records with Waukesha. Is there a way to have the auth table allow multiple records per user instead of just the first? Again, I understand if I stamped the email into the data table, I could get this initial result. My problem with this is that I need multiple users to access the same records, and If I duplicate the records through a view, my table becomes way too large so this is not an option for me. Is there any other way?

Perfect. Thanks!

@Vitalikssssss, this is a great solution. Is there something else you have to do 'width($('table') if you are actually using a pivot table? I tried to implement your solution as is, and it inserts a scrollbar on top, but it is a full block and does not scroll at all. Please see HERE. I am wondering if the width does not work because I am using a pivot table instead of a tabular report.

Thanks for this. It looks like this will work for the datapages all deployed on one page. However, I am assuming there is no work around to do this for datapages deployed on a second URL?

That works. Thanks!

I tried taking out the noscript, and it works to put the original Iframe in the correct spot, but the reason for the javascript in the first place is to grab the parameter from the URL and send to the iframe. The iframe with the noscript does not receive this parameter, but the iframe below my footer does receive it correctly.

I have a page Shown Here that has a couple of datapages deployed as Iframes. My table at the bottom has a custom script which is also shown below. As you can see, this is causing the iframe to show below the footer of the website and not where originally specified. When I take away the javascript and just use the iframe deploy code, it works correctly. Does anyone know why it might be showing up so low in the website? <noscript><iframe border="0" frameborder="0" height="1000px" marginheight="0" marginwidth="0" name="iframe" src="https://c1abv844.caspio.com/dp/91cf7000e1c04a6858f7405d90f8" width="100%">Your browser does not support inline frames or is currently configured not to display inline frames.</iframe></noscript><script type="text/javascript"> var form = 'https://c1abv844.caspio.com/dp/91cf7000e1c04a6858f7405d90f8'; var params = window.location.search; var thisScript = document.scripts[document.scripts.length - 1]; var iframe = document.createElement('iframe'); iframe.setAttribute('src', form + params); iframe.setAttribute('width', '100%'); iframe.setAttribute('height', 500); iframe.setAttribute('type', 'text/html'); iframe.setAttribute('frameborder', 0); iframe.setAttribute('allowTransparency', 'true'); iframe.style.border = '0'; thisScript.parentElement.replaceChild(iframe, thisScript); </script>

I have a page Shown Here that has a couple of datapages deployed as Iframes. My table at the bottom has a custom script which is also shown below. As you can see, this is causing the iframe to show below the footer of the website. Does anyone know why it might be showing up so low in the website? <noscript><iframe border="0" frameborder="0" height="1000px" marginheight="0" marginwidth="0" name="iframe" src="https://c1abv844.caspio.com/dp/91cf7000e1c04a6858f7405d90f8" width="100%">Your browser does not support inline frames or is currently configured not to display inline frames.</iframe></noscript><script type="text/javascript"> var form = 'https://c1abv844.caspio.com/dp/91cf7000e1c04a6858f7405d90f8'; var params = window.location.search; var thisScript = document.scripts[document.scripts.length - 1]; var iframe = document.createElement('iframe'); iframe.setAttribute('src', form + params); iframe.setAttribute('width', '100%'); iframe.setAttribute('height', 500); iframe.setAttribute('type', 'text/html'); iframe.setAttribute('frameborder', 0); iframe.setAttribute('allowTransparency', 'true'); iframe.style.border = '0'; thisScript.parentElement.replaceChild(iframe, thisScript); </script>

Thanks @Andrew. I will give this a try as it might work for this situation. I generally try to stay away from Iframe, because even this function is sending a parameter through a URL string. Is there anyway to find the ID on load? I tried the script below but could not figure out the correct syntax for finding the ID. <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { var charted = document.getElementsByClassName("container")[0].id; var chart = Highcharts.charts(charted); console.log(chart); chart.update( { plotOptions: { series: { pointWidth: 50, cursor: 'pointer', point: { events: { click: function () { location.href = 'https://hhaclaims.weebly.com/inpatient-referral-sources.html?HHAIPName=' + this.name; } } } } }, } ); }); </script>

Right now, the JS has your exact code, and it worked once, but when refreshing the page, it does not work again as they keep switching.

So I tried your code (chart 6), but that does not necessarily work. The charts change numbers, so it might work once in a while, but they change which was my initial issue. If you refresh the page, the chart variables change for some reason, and I am not sure why, which is why Caspio Support told me I had to use something else.

Hello @Andrew, it is the chart titled: Top 10 IP Referral Sources. I have a screenshot of it attached. I received the response below from Caspio about the ID's changing when you refresh the page. They said the Chart ID is dynamic, so I would have to select it by class and an array type, but I am not sure how to do that. Thanks.

Good morning, I have a chart deployed with the javascript that works in it's underlying function. You can click on one of the bars and it will go to the new datapage and passes the parameter in the URL allowing me to do a drilldown from the chart. Here is my URL - The chart with the code in the header is the third line down (4th overall chart) called Top 10 IP Referral Sources My problem is that I deployed it on a page with multiple datapages, and it is not referencing the correct chart. It is referencing the chart at the bottom of the page instead of the one with the code. I tried putting Highcharts.charts['4'] but it does not work, as my page constantly changes the chart ID's. I am not sure why they keep changing. Is there another way to reference a specific chart besides the ID as it changes everytime I refresh the page? <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { var chart = Highcharts.charts['0']; console.log(chart); chart.update( { plotOptions: { series: { pointWidth: 50, cursor: 'pointer', point: { events: { click: function () { location.href = 'https://hhaclaims.weebly.com/inpatient-referral-sources.html?HHAIPName=' + this.name; } } } } }, } ); }); </script>