Management of tags (multiselect) in tables

App Building
,
1

Using "tags" (multiselect / list )
I created a record from Multiselect input in a form
image

It saves data into the database as an array : empty or with several data separated by comas
image

But in tables, despite values are set, the column remains empty
image

In can update the cell via the table
image
it's ok in the changeset array
image

But error when updating (because there is no string delimiters, it considers the coma separator as a field separator)
(error message : upd_modeles failed (1.603s):update modeles set options = 1, 2 where id = 1)

These are the update via GUI parameters

image
image720×1125 92.3 KB

If I'm not wrong, there is unconstistency of behaviour between new tables and the rest of the components regarding the management of multiselect

Environnement : MySql

2

Thank you Gabe for this post. Have you tried transforming the array to a string? You can use the transform functionality in the query tab to do so.

3

Hello Grace, thank you for your reply
Yes I did the transformation.
I was only pointing out the difference of behaviour between form and table.
When I save from the form, the format is the array, and the selected values are shown in the field
But the same data created by the form is not dipsplayed in the list.
That was the point

Have a great day