Hi everyone,
I’m exploring ways to implement a custom widget or alternative solution in Grist that tracks modifications in certain columns. Specifically, my goal is to have a mechanism where, when any of a set of columns is modified, a dedicated “UpdateTracker” column is automatically updated with the name of the column that changed.
For example, consider a table with these columns:
- Name
- UserName
- Date
- Phone
Currently, the only solution I’ve found is to create an associated tracking column for each of these fields, so that each time one is updated, its corresponding tracker is updated with the column name (e.g., “Name” when the Name column is modified). However, this approach quickly multiplies the number of columns and clutters the table schema.
My question is:
Is it possible to create a custom widget—or use another mechanism (maybe leveraging Grist’s internal trigger system such as _grist_Triggers
)—that can monitor these changes and update a single tracking column (or otherwise log the change) without needing to create separate tracking columns for each field?
I would appreciate any insights, sample code, or references to documentation that could help implement a more elegant solution.
Thanks in advance!