How to change a column with multiple values into Enumlist

[Mirza19]

Hey everyone,

I have a column named ID with multiple sites (sites is a column as well) which has data like site1,site2,site3 . I want these column values to be seen in EnumList . I have created a view with only site column with EnumList as datatype, so when i click on the this column it should be in the EnumList with sites corresponding to that id, can anyone help me with this?    

[Marc_Dillon]

Not quite sure what you're asking here. Maybe SPLIT() is the answer?

https://help.appsheet.com/en/articles/2357340-split

[Mirza19]

Hey Marc thanks for your reply

My Question is how can the column having values d1,d2,d3 can be changed to EnumList , so that we can select the d1,d2,d3 seperately instead as a whole.

[Marc_Dillon]

Hmm, that still doesn't make any sense to me. If the values are already in the column, why would you need to select them? Can you describe another way, and maybe with some screenshots?

[Mirza19]

I am pulling the column with these values into another view. where i need these values to be in enumlist.

[Mirza19]

These are the screen shots, i need sites to be visible as choice that can be selected

 

 

[Marc_Dillon]

Use SPLIT() in valid_if.