We have a requirement where IT members should see 5 choices in the dropdown when they are logged in, while others should see 3 choices. (Screenshot attached for reference)
I know this can be done by creating two separate dropdowns and hiding/unhiding them, but I was wondering if it's possible to do this with a single dropdown?
Thank you :)
Page 1 / 1
Hi @Natha
Yes, there are a number of methods you can use to achieve this, mostly they just depend on if you have a method of detecting if the current user is a member of IT? Do you have that already configured?
Regardless the most effective and performant way would be to use Nintex data tables.
Open the Data tab in your Nintex tenant :
Create a new table and name it Item Matrix:
We will use the Name column for the choices you need, and we will also add a Yes/No field that allows us to mark IT fields
You can configure the choices like this (I am assuming the IT choices are marked IT):
Now back in the form lets add the data sources, we need to add a data source for both scenarios, if they are in IT and if they are not in IT.
In the form open the Data Variables Tab:
Add a new table data variable and configure like this where there is no filtering (as IT has access to all choices but apply whatever logic works)
Then create a new table data variable for everyone else and configure it so ITChoice is false:
You will end up with 2 variable objects:
Now lets go to the single choice dropdown and configure the options:
Hit insert on the options and this will show the variable builder:
Now we can create a normal variable to check if the current user is in IT, if they are use one set of choices, if not then use the other, the variable looks like this:
ifElse(>Form].
Once added it should look like this:
Now on preview you will see it is showing only 3 options:
Changing to IT shows 5:
Hope this helps
Jake
Hi @Jake ,
You are a star as always. Thanks for the detailed explanation. :)
We have 20 people in IT, so I have a list of their email IDs in the database and the Nintex table as well. I was thinking of using that to check the current logged-in user and determine if they are a member of IT or non-IT.