Change field from Integer to String

[Graham18]

How can this be done?

Geneva UI 16.

[grzegorzch]

Then I would recommend you to export all records to Excel to save data, then change field type.

After changing field type load back data from excel.

[Swapnil Bhakar1]

Hi Graham,

Follow below steps to change field datatype:

1. Right click on field for which you have to change the datatype-> Click on Configure dictionary-> Change Type from Integer to String-> Click on Update.

Hope it will help you.

Regards,

Swapnil

PS: Hit like, Helpful or Correct depending on the impact of the response

[BALAJI40]

Hi Graham,

If modify field contains any data then We can n't modify the field type directly to INTEGER to STRING.So for that you need to create new field and of type string and import old data into new field and delete the old one.

If you do not need data of modify field then you can update with empty (no data in that field) through back ground script, then you can modify the filed type.

[Ajai S Nair]

Hi Graham,

Modifying an existing field type will result in lose of data in the existing field.

Also we can't modify the field type directly from INTEGER to STRING.

So better option is to create new field of type string and import old data into new field and delete the old one Just like what Chuck already mentioned