I am looking for guidance on how best to alert a user that there has been a change to some data, or a file has been uploaded etc.
As an example, in the following screenshot, I would like to add another column where you might get
“Updated by JP” or
“3 images added by TD” or something similar
I don’t need to know the instant the change has been made (although that would be nice), It could be within a minute or even 5 minutes. I just need to know that something has been added or changed by another user recently.
So I end up with something like this
This then leads to more questions…
If this record has changed, when did it change?
If it changed, since when did it change?
I do have the following fields available for every record which may be of use
Maybe every line should have a
“Data updated 20 mins ago by JP” or
“Not updated in the last 24 hours” or
“3 images added at 10:39am by TD”
This could then have some sort of colour indicator to show visually, how recently something was changed.
Do I need to do simple queries looking at “Data modified” and “Data editor” fields and do this on a scheduler set every 5 mins?
Problem is that I just can’t get my head around what to do, and how to do it. Help please.
Last updated: