In-app Change Log / History

Hi Gliders,

since I experimented with version 1 in July 2021,
I found tremendous support by

and can give something back today:

It uses

  • user specific columns for drafting changes (all users can make their own draft in parallel, so you don’t need to restrict access to the custom form)
  • hyperformula =EXACT(A1,A2) to check if changes were made
  • 2 relations and 2 roll-ups (to limit the number of rows in the change log and overwrite the oldest entry once limit has been reached)
  • and plenty of custom actions (which are required for every custom form whose changes should be tracked).