Forums

Hello to all CCv6 guru,
Simple question that I cannot resolve myself-
I have an Array that is stored in the Database like this - ["A","apm","Apm.","Aud"] in one Column named pakalpojums.
​
When I create a table in CCv6 I got the same view. in a column named Pakalpojums.
​
So, what should I do to have those data to be nicely represented in the table without square brackets and quotes - A,apm,Apm.,Aud?
​
Thank you in advance -
Elita

and more - how can I read back those values for edit in Dropdown Multi Select?

Hi Elita,
​
It looks as if your data is JSON encoded for saving, so you'd need to decode and re-format it into the display that you need.
​
Bobb

Thank you, GreyHead, that was the case - I was using Autosave option Max wrote.
To have that data stored and then read as I wanted I did following:
​
1) created dropdown with multiselect and the name produkts[] - square brackets at the end;
2) untoggled Auto save fields and Auto manage the data table options for DB save Action
3) created data override entry as produkts: {data.join[, ]:produkts};
​
With this I have data nice presented in the table Column "Produkts" with comma - A, apm, Apm., Aud.
​
To read this data back in the dropdown for data editing I used {var.split[, ]:read_submission.Submission.produkts};
​
Works like charm - *love* CF6 and CCv6