I am attempting to create a custom widget which can take actions when a new record is added to a table, or when an existing record is updated or deleted.
As far as I can tell, there are no applicable ways via the main grist-plugin-api Module, nor any of the other “sub Modules” accessible there, such as docApi, viewApi, widgetApi, etc.
Is what I’m wanting to do possible?
If not, I presume I would have to manually keep track of the records in a table to know when a new one is added or deleted… and for updates, I would need to do something like adding a helper column that gets updated via a trigger formula each time the record changes, or creating internal hashes of data in the row that I get from the onRecords() event handler.
It really seems like there should be some additional event handlers such as onRecordCreated, onRecordUpdated, and onRecordDeleted.
Thanks!