So, I want to record changes made in some data tables to a data table in another sheet. This will give an easy auditing feature to any table you require audited. My requested function would take 2 inputs, a tablename and a rowkey. The function would return a JSON formatted string of Key:Value pairs that reflect the column names and values in the supplied arguments.
The auditing table would only require 4 fields. When (DateTime), Who (Useremail()), Table (Name of the table being audited), Changes (The function’s return string).
It could be used as part of a Behaviour (Add a new record to another table using values from this Row) and would greatly simplify how I do it at the moment where I have to hand construct a formula such as
Related ServiceSubItems:",[Related ServiceSubItems],",
Related ProjectItems:",[Related ProjectItems],"}")
I would have to generate something like that as a virtual field on each table I want to audit wheras a nice function to return something similar such as ROWVALUES(“TABLE”,“KEY”) would be awesome!
Thanks for your consideration!