Steve P asked 1 year ago
I'm hoping to change a field from a Text field to a Select and retain all values for this field in existing entries. We have strict formatting on the Text field so can be sure the data in existing entries will be fine.
I can see this should easy to do if I simply change the options directly in the frm_fields table, but when I do that the field doesn't change.
I'm guessing there's some kind of caching happening with form fields. If that's the case, how would I flush that cache to have the form pick up my database change? Any ideas>
Victor Font Staff answered 1 year ago
I would not do this if I were you. Formidable already allows you to change field types if the field types are compatible. A select and text field are not compatible types for conversion. What you may be able to do, and I have not tested this, so if you try it, do not do it in a production system. Don't try to change Formidable definition metadata in frm_fields. You are guaranteed to break something down the line if you do. Change the field association in the entry data instead. Create a new select field and change the field_id for the associated data in the frm_item_metas table.
I want to add one more thing. Don't try using a dynamic field for the select. Use a standard dropdown or lookup.
Please login or Register to submit your answer
