SharePoint QA
ihmunro
Member
Morning
Is it possible to have a choice field automatically update?
For example, if I have a choice field that says Yes or No and I allow people to add in their own values, I would like the list to be updated automatically - is this possible?
So when the next person does an entry, it now may sau Yes, No, Maybe.
It is kind of like the choice field is doing a lookup on itself as opposed to information already on the site.
Iain
I don't think that could be accomplished without a custom Visual Studio workflow. I think what would happen is you do a check to see if the values is yes or no after the item is created. If it isn't, you'd write that value into the choice options so it's available for the next person to use. Along with that, you'd want to make sure that the value they entered doesn't already exist in the list.
The alternative would be to have a lookup list be your choice column and have an additional line of column be below that on the NewForm. The lookup list would have an Other (Please List Below) value and when a user selects Other and fills in their value in the text field, this value is then updated in the lookup list via a work flow.
This opens the door for variations and duplicate records. You could maybe turn on content approval on the lookup list to prevent this from happening.
If this doesn't make sense I can go into more detail.
A screencast has been submitted detailing how to do the lookup and autopopulating the user defined value.
You must log in to post.
