Re: If you change a custom field's type does it wipe the data in that field for all contacts?

Anonymous
Not applicable

If you change a custom field's type does it wipe the data in that field for all contacts?

I want to change a field's type from integer to string that's already in use by a lot of contacts. If I make the change will it wipe all of the data within this field for all my contacts?

Thanks in advance!
Tags (1)
4 REPLIES 4
Delinda_Tinkey1
Level 5

Re: If you change a custom field's type does it wipe the data in that field for all contacts?

I don't think Marketo will even let you change the field type if it has data in it.
Dory_Viscoglio
Level 10

Re: If you change a custom field's type does it wipe the data in that field for all contacts?

I think you are able to change it, but I've seen a warning that the data will be deleted. It's a little bit of work, but you could always export a list of the current field values with the user's email address, and then re-upload once you have changed the field over.
Anonymous
Not applicable

Re: If you change a custom field's type does it wipe the data in that field for all contacts?

I actually decided to build a test custom integer field and loaded up a couple of my test lead with some numbers. I then changed the field to a string and it worked! No data was lost.

Dory, I'm still going to take your recommendation and export a list of the integer field and email address in case there is any lost. 

Thanks everyone.
Justin_Cooperm2
Level 10

Re: If you change a custom field's type does it wipe the data in that field for all contacts?

Correct, only for certain type changes is the data deleted. In this case from integer to string it is not. 

As an aside, it would not be possible to change the type of a field if it was in use by another asset.