Search the Community

How can I write (insert) the rows in a DataPage report result set into a table? Table of details, with multi-level rollup, is updated by many users with login RLS. Results change often and unpredictably. Have a view that presents the correct data from several tables for a rollup report that counts instances of an item by a grouping factor, rolled up through the levels. A snapshot of the rollup report at the end of a week is used to guide deliveries based on the counts as of that time. Need to be able to write that snapshot (the rollup DataPage tabular report result set) into a history table with same columns. Purpose is to have accurate history by week of those counts to derive accurate totals for period(s) and monitor trends over time etc. I know I can export and then import append into a table, but was hoping for an automated method initiated via button or similar. New to Caspio, but not afraid of code, at least to copy and paste Thanks for any help.

I have an application that we use for new user access and termination requests. It helps when terminating a user to know which software, websites, hardware, etc., they had access to. Unfortunately, we don't have a good way to request new access to existing users while also updating the database. For example, a new user might be set up with an email address and a laptop, but later on they need a login for Website A. I would like to create a form which allows them to update the user's record to include access to Webside A. It seems simple enough to build a datapage which allows someone to update this record. But I am not sure how I would send a notification which tells me exactly what is being requested. If they already had access to Website A, and now they are asking for Website B, I would like a good way to identify the actual change being requested. I'd appreciate any help.

I'm have a submission form that uses custom buttons (because of the need to show/hide Submit due to Rules) to do the Submit. I need, after submitting the new record, for the destination to go back in History a page (or two if the submit refresh logs the form as a page in History). I can't get the code to run in the Destinations wizard, using Message and html editor disabled. Here's what I have so far: basically the data submits correctly and a new record is created but I get no redirection to previous url. <SCRIPT LANGUAGE="JavaScript"> function goBack() { window.history.go(-1); } document.getElementById("caspioform").onsubmit = goBack; </script> The other option I tried was to put the js in the html block with the custom button for Submit. It does run the 'go back' code but the new record doesn't actually get submitted. So it's either the 1st choice with record submitted and no back-redirect or the 2nd choice with no record submitted and back-redirect working. If someone could clarify how to get the actual 'submit' AND the 'back-redirect' to work that'd be really great. Here's the custom button code in the html block, if that helps: <div style="text-align: center;"><input class="cb_custom_btn" type="submit" onclick="goBack()" value="SUBMIT" /> <SCRIPT LANGUAGE="JavaScript"> function goBack() { window.history.go(); } document.getElementById("caspioform").onsubmit = goBack; </script> </div>