By jsruzicka on

I created a form for data entry that contains a drop down list from which users choose one of 10 values. Now a client wants to add an 11th value to be selectable but I get:

"There is data for this field in the database. The field settings can no longer be changed."

Is there a preferred way for creating these lists in the future so that

1. They come from a database lookup rather than someone typing in a list of values
2. Entries can be added as needed?

Thanks

⋅ Categories: Drupal 7.x

Comments

Sam Moore’s picture

Sam Moore
he/him
Location Sandy Hook, CT
commented

Create a taxonomy with the list items as terms.
Create a Taxonomy Reference field in your content type, and set it to use the Taxonomy you just created. The field widget will populate with whatever terms are in the taxonomy at runtime, so if you add a new one it will show up automagically.
Not sure what happens if you delete a term, but in any case this works better than static select lists.

============================
Resonetrics: Better Tools for Building Brands
http://resonetrics.com
http://technologyformarketers.com
http://kittenassociates.org
http://www.linkedin.com/in/sammooreatresonetrics

yogeshchaugule8’s picture

yogeshchaugule8 commented

The option provided by "Sam Moore" is good and flexible for layman to add new options in field.

But there will not be any data loss if you add one more option in you list field. By default fields of type list allow site admin to add new options when ever they want, it will not allow you to remove the options which are in use.

Yogesh

Yogesh
http://yogeshchaugule.com/blog

jsruzicka’s picture

jsruzicka commented

Thanks for the replies all. Appreciate it.