# Change a drop down field into a text field?!

**URL:** <https://primero.supporthub.dev/forum/t/change-a-drop-down-field-into-a-text-field/430>\
**Category:** CPIMS\
**Tags:** v1-7, v2-0\
**Created:** [May 17, 2021, 6:09am UTC](https://primero.supporthub.dev/forum/t/change-a-drop-down-field-into-a-text-field/430 "2021-05-17T06:09:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![nebras.hussien](https://primero.supporthub.dev/forum/letter_avatar_proxy/v4/letter/n/9de053/32.png) [@nebras.hussien](https://primero.supporthub.dev/forum/u/nebras.hussien)\
**Post date:** [May 17, 2021, 6:09am UTC](https://primero.supporthub.dev/forum/t/change-a-drop-down-field-into-a-text-field/430/1 "2021-05-17T06:09:12Z")

</div>

We need to change the type of field we added manually to the registration form, specifically a one selection-drop down list field into a text field, knowing this field already have data in the database entered by a caseworker, would it be possible to change the type without effect or loss of the already entered data?!!  
We need to keep the previous data and change its field into a text that most satisfies all our partners’ needs.

---

<div class="post-metadata">

**Author:** ![irlawrence](https://primero.supporthub.dev/forum/user_avatar/primero.supporthub.dev/irlawrence/32/8_2.png) [@irlawrence](https://primero.supporthub.dev/forum/u/irlawrence)\
**Post date:** [May 17, 2021, 11:12am UTC](https://primero.supporthub.dev/forum/t/change-a-drop-down-field-into-a-text-field/430/2 "2021-05-17T11:12:04Z")

</div>

I would hide the current field (do not delete it). Then create a text field with the same Label as the previous hidden select one but with a different database name and make it visible. It is generally good practice to hide/show stuff rather delete anything

---

<div class="post-metadata">

**Author:** ![nebras.hussien](https://primero.supporthub.dev/forum/letter_avatar_proxy/v4/letter/n/9de053/32.png) [@nebras.hussien](https://primero.supporthub.dev/forum/u/nebras.hussien)\
**Post date:** [May 18, 2021, 10:29am UTC](https://primero.supporthub.dev/forum/t/change-a-drop-down-field-into-a-text-field/430/3 "2021-05-18T10:29:09Z")

</div>

Thats eaxtly what I was thinking of, but the point is what about the already stored data?!

---

<div class="post-metadata">

**Author:** ![irlawrence](https://primero.supporthub.dev/forum/user_avatar/primero.supporthub.dev/irlawrence/32/8_2.png) [@irlawrence](https://primero.supporthub.dev/forum/u/irlawrence)\
**Post date:** [May 20, 2021, 3:44pm UTC](https://primero.supporthub.dev/forum/t/change-a-drop-down-field-into-a-text-field/430/4 "2021-05-20T15:44:13Z")

</div>

The data will remain in the database. If you need access to it you can export the records before the change. Any new records created after it is hidden will not export the data any longer
