I’m using two tables in the same base connected by a zap to create an automatic updates log (the second table) of repeating tasks in the first table. It’s a Health & Safety maintenance system.
Table one lists all the regular things that need doing - first aid box refresh, car checks etc. When a check is completed the checker updates this table and it automatically updates a iCal so the next time check is in the right persons calendar. The table has a “last update field” which I use to create a filtered view that only has checks updated today in it.
I use a zap to spot the updated view record and create a new record in the second table - the log of events. This is totally auto-generated as an audit trail. It lists the check completed and other details about it. This is the table used to report H&S activities.
But it’s a bit complex - is there a better way?