I need some assistance with changing a field type in a table after creating a new column. I recently added a new column to a table in my app but realized I selected the wrong field type. I would like to change the field type, or if that’s not possible, delete the column and recreate it with the correct type.
Could you guide me on how to do this? I’m having trouble figuring it out.
You are correct that you will need to create a new column. Tulip table columns do not have the ability to be casted to other data types.
Thankfully, you should be able to use the CSV Export and Import feature to do this pretty easily, and it will be good practice to make sure you are comfortable with this niche component of Tulip.
Simply export the table as a CSV, trim the CSV to only what you need, then import the column into the same table, making sure to map the values to the new column and keep the ID mapped to the ID so that the records overwrite.