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.
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.
Question
PirateSteve
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.
Link to comment
Share on other sites
3 answers to this question
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.