I have a list that I will have users enter data into, each user needs to select their own location. First I created a drop down field with all the options. The column can be set to force unique values, but this doesnt check until the end when the user goes to save.
Is there a way to check if the users selection is already entered, immediately when the option is selected? (without having to hit save)
OR
Another option I tried was:
- Create a separate list with two columns:
name
andsaved
. Call itLocation_List
- Create a view that displays all where
saved = no
onLocation_list
- Populate the options on the
mainList
from a look up the theLocation_List
. This works. - Add a workflow action to
mainList
that updatessaved = yes
on theLocation_List
. This part doesn't work. Does sharepoint allow this though?
Is there an easier way to accomplish this?