Userwise Dropdown List in Marketing Documents

[Former Member]

Hi All,

Let me explain my requirement as much clear as i can.

We have given 5 Users to CRM department. Whenever and Whichever users login to the system he should select his name from the drop down (Probably an UDF) and the dropdown should list only the names of CRM Users. It should be a mandatory field and without entering this data system should not allow to add the documents.

This is my requirement. Now how to create UDF that should display only the specified (Based on Login system to find whether it is CRM users or other department users) and display that department employees name only. And that should be mandatory field.

[kothandaraman_nagarajan · Accepted solution]

Hi,

You can use Formatted Search (FMS) query to get logged user name or department. Use below FMS to get logged user name

SELECT T0.U_NAME FROM OUSR T0 WHERE INTERNAL_K = $[USER]

Regards,

Nagarajan