http://www.endusersharepoint.com/STP/ SharePoint QA en Fri, 28 Aug 2009 03:54:44 +0000 http://www.endusersharepoint.com/STP/topic/choice-fields-auto-update#post-8628 Thu, 23 Jul 2009 08:20:09 +0000 eric 8628@http://www.endusersharepoint.com/STP/ <p>A screencast has been submitted detailing how to do the lookup and autopopulating the user defined value. </p> http://www.endusersharepoint.com/STP/topic/choice-fields-auto-update#post-8572 Tue, 21 Jul 2009 09:33:57 +0000 eric 8572@http://www.endusersharepoint.com/STP/ <p>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.</p> <p>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.</p> <p>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. </p> <p>If this doesn't make sense I can go into more detail. </p> http://www.endusersharepoint.com/STP/topic/choice-fields-auto-update#post-8569 Tue, 21 Jul 2009 09:11:01 +0000 ihmunro 8569@http://www.endusersharepoint.com/STP/ <p>Morning</p> <p>Is it possible to have a choice field automatically update?</p> <p>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?</p> <p>So when the next person does an entry, it now may sau Yes, No, Maybe.</p> <p>It is kind of like the choice field is doing a lookup on itself as opposed to information already on the site.</p> <p>Iain </p>