Add UserID to the table for every record user add / edited automatically


I need to record who is the one who add / edit the form. And it done automatically, anyway to do that?

meaning to say my userID is jliang84 and once i add / edit the form, my jliang84 will be updated in the form's database table (userID column).

  • Guys,
    find a way to do that already. thanks.
    1. Create a field called "created by" (code 20)
    2. at Form design, on insert and on modify, add the following C/AL code:
    "Created By" := USERID;
    3. compile and test... it works!