Jump to content
  • 1

How build a log/trace for debug and/or application logging



Even if Caspio provide some logging feature sometimes I nedd to have a more granular app log/trace. I want to share what I use in my apps.

I built a table to mantain all log records with this design:



  • ID - is a unique identifier
  • tnt_id - I use it to handle multi-tenant app (it could be omitted)
  • Timestamp - self explanatory
  • Appl - Is the name of the app that logged an entry
  • Source - Is the kind of element that logged the entry (i.e. Trigger/Task ...)
  • Event - Is the eventname I logged (Update, Record scan, Insert, ecc.)
  • Description - contains valuable data related to the event. It may be some field values, authentication fields or a concatenation of more field.

Then I put some pattern like this into keypoints of my triggers or tasks filling Description with useful data.


If you consider this useful click the like at bottom-right.
If you know a better idea, please let me know.

Log table.png

Log pattern.png

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...