Hi,
Department in the user table is a reference to cmn_department. You can get the sys_id from the column in sys_user. You can set up your column in a custom app as a string or a reference. In most cases, the benefits of having it as a reference outweigh those of inserting a string and not having to do any relational look ups at run time.
You are able to insert the user directly because you can use g_user.userID. In order to get the department, you need to create an AJAX call to retrieve the value from the server. Here's the link to the documentation on AJAX.
On thing that many people miss is making sure that the server side script needs to be marked as client callable.
Hope that helps.
:{)
Helpful and Correct tags are appreciated and help others to find information faster
Hope that helps.
:{)
Helpful and Correct tags are appreciated and help others to find information faster
