I'm working on a Project Management app, and we've added a feature to assign a task to a specific user. I want to log the changes to the Assigned User field in a separate text field, marked "User History".
Currently I have a system that uses a Formula-Text field to pull the current user's name, and then a form rule that writes that to the User History field on save whenever the assigned user is updated. The User History field logs changes with timestamps so it's perfect except for one thing... Grid Edit.
We often receive hundreds of new jobs at a time, and it's not unusual for them to be assigned en masse. Grid Edit makes selecting a user quick and easy. However, since there are no form rules for grid edits, the User History field never gets updated with the new data and the changes are not logged.
Is there any way to track changes on a User field or Formula-Text field directly? Neither one seems to give me the option. That would allow me to keep track of the data without having to resort to the clunky form rule writing it across whenever it changes.