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).

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!