Create an "On Open Trigger" and "On Close"
There are currently 3 trigger types on a table (Insert, Update, Delete) - I was thinking of potentially having two more: an "On Open" and "On Close" trigger - possibly best used when you open a datapage form instead of a table, where you want it to go and get values or make a calculation on the fly and load them into the page. At present the datapage is only populated by the table you have connected to the page, but with the on Open Trigger I could imagine being able to select from other tables (ie: Select the relevant Running Total) from a Running_Total table and display it in the Running Total Field. There are possibly other ways to achieve this but I think this makes sense to be available for a datapage? The On Close would be the same in reverse but maybe it is used to update the data (ie: Update the Running total with the new running total). Hope that makes sense?