How insert automatic value for "Modified by user"?

[F.schettino]

I have a my table for users called Fabrik_Users (I need a lot of information about each one).
In this table, I have a field Joomla_user that is the id of the Joomla user:

id Surname Name .... Joomla_user ... ​

In each list/form, I need a field to memorize the user that modifies the record; in this field, I need put id of Fabrik_Users (not the id of the Joomla user table).

Which is the easier/best way to get it?
I will appreciate suggestions.

 

[F.schettino]

I tried

But it doesn't work.
What is wrong?
or
Which is the best way?

 

[troester]

"Default" (predifinito) is only executed on NEW records.
You can use a calculation element with this code (with "only calc on save"=yes, otherwise you will see the wrong user in list/details view because it would be calculated/displayed "on the fly" so showing always the logged in user).

 

[F.schettino]

Ok, I understand that my way is not a good way.
I will use Ajax.

How can I use {my->id} or something else to get the id of current user in Javascript / in PHP?