When replacing a field type - such as single field text to a drop down, how can I move data? [RESOLVED]

I have a form that captures a Membership ID number that is hand typed by the end user. Due to so many errors, I’ve changed it to a drop down where I maintain the list of ID’s in the custom lists. However, I now have some data in the old field and new data in the new field. What’s the best way to populate the new field with all of the old data from the earlier submissions?

One technique is to add a new field and switch the ID of the new field with the existing field. Then the data that was previously associated with the old field will now be associated with the new field. You can then delete the old field.


1 Like

Very helpful! Thank you!