Skip to Content
-1

Userwise Dropdown List in Marketing Documents

May 10, 2017 at 05:44 AM

69

avatar image
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Nagarajan K May 14, 2017 at 12:34 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded