Audit table

Hi everyone

I’m very new to Xano but absolutely love it so far. Looking for some best practice advice.

I need to create an audit table when a number of things happen in my system. Some will simply be database changes.

Audit table would be:

user_id, action, comment

I want to call the functionality on the Create, Update and Delete API functions with the user_id calling the method and a simple description which doesn’t really matter at the moment , Record added, updated or deleted will work

Am I right in thinking this should be a function? Or is there a better way?

Thanks

Mike

6 replies