Can I have a changeTimestamp data column that only changes when a user of a specific role makes a change in the table?
Right now both “Drivers” and “Dispatchers” interact with the same table so the changeTimestamp column only shows the timestamp of the most recent change.
I want to fix this by having a second changeTimestamp column that only changes when a dispatcher makes a change, and then have the first changeTimestamp column only change when a driver makes a change.
I have a users table that specifies everyones role and email address so I think a lookup function would suffice. I just don’t know where to put the lookup function. Maybe the update field?