I have following list setup
- List Name "category" having three column all (Single Line Text)
CATID | CATNAME | MAINCAT |
A | ANAME | E |
B | BNAME | E |
C | CNAME | R |
D | DNAME | R |
E | ENAME | R |
- List Name "UsersCategory" having two column
Username (People and Group) | MAINCAT |
User1 | E |
User2 | R |
User3 | E |
User3 | R |
- List Transaction
Column1 | Column3 | MAINCAT |
abcd | efgh | R |
dfsf | sddf | E |
Based on List Transaction I have created a Nintex Form, and I want to achieve following
- Show a dropdown based on List#1, which display CATNAME filtered by “CurrentUser” MAINCAT mentioned in List #2 ("UsersCategory") List.
If the Current User is “User1” then the dropdown will show only CATNAME (ANAME and BNAME) and if “User3” is a current user then all category will be display.
- I need to save selected value of dropdown in List #3 MAINCAT column.
Any Idea how can I achieve this ?