Skip to Content
avatar image
-1
Former Member

Userwise Dropdown List in Marketing Documents

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 14, 2017 at 12:34 PM

    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

    Add comment
    10|10000 characters needed characters exceeded