Change field type on a custom table

[Cesane]

Hello everybody! I created a custom table when I uploaded a CSV file by load data with the purpose of serving as a reference for a reference field in the portal. Inside the instance everything is normal, but when I go to the portal the specific field shows me the numbering of the ROW column. I saw that the ROW column field is of type Integer, where only numbers are allowed, and when I try to change it to string (to simply put the correct name of the records in it), it doesn't allow me, showing only the Integer type. Any suggestions on how to get around this or enable field type switching?

ps: attached, as it is on the portal and as it is on the platform. The right column is how it should be appearing on the portal.

[Community Alums]

Hi @Cesar ,

You cannot change a field's type without data loss. For custom fields, the system prompts you to confirm you accept the data loss before proceeding with the change. For a base system field, the system prevents you from making the type change.

One of the options is to have a new field and migrate the values for existing record as one time script via fix script.

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Cesane · Accepted solution]

I just change the display on table configuration. I turned the display of ROW off and the field i want to True.