I use repeating Timestamp field so I can see the history of modification. And corresponding repeating Account field.
You don't need any script triggers for this - just define these fields:
CreatedBy - Text, auto-enter calculated value = gUserID
ModifiedTS - Timestamp, auto-enter Modification Timestamp
ModifiedBy - Text, auto-enter calculated value (replacing existing value) = Let ( trigger = ModifiedTS ; gUserID )
I don't know your reasons for letting multiple users log in under the same account, but I'd suggest you think twice about this.
Thanks! The CreatedBy solution was so simple; I tried to make that route too complicated. I didn't know about the variable "trigger" and appreciate learning that.
The main database requires unique user logins, but I sometimes have students or volunteers that help enter data via portable 'runtime' versions that are imported into the main database at a later time. Not having to create unique runtime solutions for this temporary help is a time saver.
Thanks again; I appreciate your willingness to share your expertise; I've learned a lot from various responses you have made to other posts.