Skip to main content
Nintex Community Menu Bar
Question

Remove value from Drop-Down menu if selected before

  • September 5, 2024
  • 4 replies
  • 50 views
  • Translate

Forum|alt.badge.img+1

Hi All ,

 

Basically I have a list and create a drop down list and almost 10 value. If someone fill the form and choose 1 value in the menu, I need to be removed from the list to prevent to be chosen second time by someone else. 

Is it possible to remove or disable the value if selected someone else?

 

For example there are 6 values in the drop down menu. I created 1 item and choosed Value1. When second person ty to create item they shouldnt see Value1 or should see disabled. 

Value1

Value2

Value3

Value4

Value5

Value6

Did this topic help you find an answer to your question?

4 replies

SimonMuntz
Nintex Employee
Forum|alt.badge.img+22
  • Nintex Employee
  • 2466 replies
  • September 6, 2024

Hi @Yusuf_128,

Welcome to the community.
I wrote a blog post about 4 years ago for an appointment system tackling this issue.
If someone chooses an appointment from a dropdown, it is removed for the following user. I am sure you can apply the same concept for your solution.
 

 

Translate

Forum|alt.badge.img+1
  • Author
  • Rookie
  • 1 reply
  • September 9, 2024

Hi Simon ,

 

Thanks for the information but i dont have any database i can use. Is there any diffrent way i can accomplish this?

Translate

  • 73 replies
  • September 10, 2024

You can enforce unique values in the list column settings. You can find those under the list settings of sharepoint. It won’t prevent users from selecting the option but it will prevent them from saving the new item.

Translate

SimonMuntz
Nintex Employee
Forum|alt.badge.img+22
  • Nintex Employee
  • 2466 replies
  • September 12, 2024
Yusuf_128 wrote:

Hi Simon ,

 

Thanks for the information but i dont have any database i can use. Is there any diffrent way i can accomplish this?

SharePoint and Nintex have databases, so your environment has an SQL server.
If IT will not create a new database for you to use, see if they can add a table to one of the existing databases.  It's not ideal, but it would work.

The other option may be to use a SharePoint list. To select a date, use a date control. Make sure the control is configured not to allow past dates.
Then, cascade the available times off of the date selected. I haven’t tried it, but it should work.
If no times are available for the selected date, then no times will appear in the cascaded lookup.

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings