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:
name
and saved
. Call it Location_List
saved = no
on Location_list
mainList
from a look up the the Location_List
. This works.mainList
that updates saved = yes
on the Location_List
. This part doesn't work. Does sharepoint allow this though?Is there an easier way to accomplish this?
My second option worked, had simply forgotten to update the workflow setting to "Start automatically when item is created" for it to run accordingly.