I understand, but I think you need to understand better what are the strengs and quirks of AppSheet before, then you will understand that the tools provided are enough, but you need to be familiarized with them in order to come up with a workaround that fits your needs.
I haven’t built something like a Log but even if I would I couldn’t say there is a one-size-fits-all aproach
To create an audit log, you’d use Automation. Create a bot that responds to all changes to the table and adds a row to another table–to the log table–that includes the column values of the changed row you care to track. You can also add columns to your audit log to capture the email of the user and the current time stamp. You have to set all this up for each table you want to track.