This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Just like the change counter or change timestamp, would be great to have a change useremail(). I do this now using actions, but it would be so much simpler to have the change column.
Add a normal (non-virtual) column with an app formula of USEREMAIL() and set Editable? to the expression, FALSE. The column’s value will be updated automatically any time the row is updated through a form or by an action.
Right, except that’s for editing the whole row. Exactly the reason behind needing the change column, is to be able to set it only when certain columns are edited.
Use case is logging timestamps and users for 1 row, but at each step in a manufacturing process.
What about a change expression column? Apply an arbitrary expression to a column when a designated change occurs. This could replace all of the existing change column types we have now and allow for your change username, too, among many other things.