Skip to main content

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

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.
 

 


Hi Simon ,

 

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


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.


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.


Reply