Jump to content
  • 0

Change table column data type from text to List-string


InMyBoma
 Share

Question

Hey folks - I have a table where one of my list-string columns got inadvertently converted to text.  Does anyone know how to change a text column to a list-string WITHOUT losing the values that are already in the column?    I fear this might be a bit much of an ask but thought I'd see if any experts out there could help.  Thanks

image.png.ab460edef7900d7d9f7ec4b81dfd96b2.png

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0
On 8/24/2020 at 11:27 AM, InMyBoma said:

Hey folks - I have a table where one of my list-string columns got inadvertently converted to text.  Does anyone know how to change a text column to a list-string WITHOUT losing the values that are already in the column?    I fear this might be a bit much of an ask but thought I'd see if any experts out there could help.  Thanks

image.png.ab460edef7900d7d9f7ec4b81dfd96b2.png

I am thinking of downloading them in excel and getting them  fixed there, it usually does this trick to my case. As long as they have their respective IDs, then they can be easily appended on the table: https://howto.caspio.com/tables-and-views/importing-data/

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...