I think this suggestion is refered to as ‘good practice’ even though it might be possible to use Logs records to achieve the same objective.
All tables should contain following fields listed below. Its better to add them now rather than face regret later. Think about this: how would you filter company specfic records from all tables for multi-tenant applications without adding, for example, ‘CreatedBy’ and/or ‘CompanyName’ for every transaction where it is practically possible.
Using tables rules might not be the best way to upadate these fields, its just my opinion because no effort would be required and also, I think, as I dont know for sure, this is server side processing and not client side.
-
Auto Increment (already exists)
-
Record ID (already exists)
-
CreatedAt (already exists)
-
CreatedBy (add using record rules or table rules, created)
-
UpdatedOn (add using table rules, edited)
-
UpdatedBy (add using table rules, edited)
