How to track modified by

Need help App Organization
1

Hi,

How can I track “last modified by” for a thing? Earlier when I had needed it I had created a field for “last modified by” and was updating it in my workflow of “submit” when user changed the thing. However, at some places I have “auto-bind” for fields, and I don’t know how to track those ones as there is no workflow that I can trigger for those (or so I think).

I can think of one possible way of creating a database trigger for when the thing gets modified. Any other simpler way?

Please guide.

Thanks,
Mukesh

2

I think that might be the easiest way.

3

to expand on this you can use the only when of the database trigger to look at e.g. if only the thing before changes -s text is not equal to the thing after changes`text. (or value). So that you only look at 1-2 fields instead of everything.

In that database trigger you could then make changes to thing, saving the last modifier and the date.

1 Like
4

Thanks @boston85719 and @TipLister. I’ll try the db trigger.

1 Like