Search the Community
Showing results for tags 'history'.
Found 3 results
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.