AnsweredAssumed Answered

Auto update of username and timestamp when a record is modified

Question asked by rakeshkatipalli on Aug 13, 2014
Latest reply on Aug 13, 2014 by philmodjunk

Title

Auto update of username and timestamp when a record is modified

Post

     Hi every one .

     I am very new to this technology. In my database file i have a field called "notes" of length 5000. Whenever a user enter data into that field it has to display the user name and timestamp followed by the data he has entered.

     For example first the user "user1" is modified. Now it has to display the user name and timestamp followed by the data. Next time if "user2" has modified , it has to display his username and timestamp followed by the data.

     Now this field should contain "user1","timestamp" followed by the data and "user2", "timestamp" followed by the data and so on.

     Example data in the field: Rakesh(user1), 14:02:10. Hi everyone

     Danny (user2), 09:10:11. Hello all

Outcomes