Checkboxes doesn't work well

Hi,
​
When you add bracket

to name and try to save_data :

[h1]1054 Unknown column 'Array' in 'field list'[/h1]
​
Without bracket, only one value saved !!
​
Thanks

Post a debug

Hi,
​
You can create an account and go to https://www.arobasfinance.fr/conseil-en-gestion-de-patrimoine/vos-projets/mieux-vous-connaitre
​
Debug is active
​
"Profil boursier" is with brackets
​
Regards

Or you could just post a debug

there is some personnal information ... See it you'll understand

You could cover it up in paint but okay I'll have a look later

thanks

OK so I highly doubt it's the checkboxes that aren't working, but your save data action that's wrong. I also can't see the debug because you have the malformed save data action activated which is throwing an error.

Post a screenshot of your save data action please. And what your "faulty" checkboxes are called.

the last checkboxes with two brackets
"Quels instruments entrent dans la composition de votre portefeuille de valeurs mobilières :"

Try putting the fields in manually in your save data action instead of relying on auto add.

I don't know do that

In data override.
​
database_field:{data:field}

composition_portefeuille:{data:composition_portefeuille (without brackets)} -->

1054 Unknown column 'Array' in 'field list'

composition_portefeuille:{data:composition_portefeuille (with brackets)

--> nothing saved in this data

Does the database table have that field in it?

yes and nothing inside after save

OK so I had a look again and you STILL have the Auto Save Fields turned on - turn that off. Put the fields in manually.
​
Additionally, Auto Detect often doesn't work so well for the write action - only seems to work in very specific circumstances. If the field is for updating only, set it to update. If you want to automatically detect if you should do an update or a save, use a read data action - if the row you want is founduse a save data action set to update. If the row is not found, use a save data set to insert.

I tried it but always error or only the last checkbox saved...

Hello,
​
In the "Data override" of the Save or update you can do the following:

table_field_name:{data.jsonen:checkbox_name}

That would json encode the data before its saved
​
Best regards

Hi Max,
​
Thanks healyaltman gave me the info...
​
Where we can know that, please?
​
regards

^ that

ok
Thanks

In the shortcodes FAQ and the manual it talks about json encode / decode, and you just kind of have to know you can't store an array directly in your database and that you have to JSON encode it first

ok
i understood