Forums

CF8 - 8.0.14 - Checkboxes Group - DB Read/Save

rbock 13 Oct, 2023
Page1 Load - DB Read Action with Data Merge, Wizard Settings -> Name: data

Checkboxes Group: Field Name: ART

Page1 Submit - DB Save Action -> Modify Data Source: ART={data:ART}

-> Unknown column 'Array' in 'field list'

1. how do I load the array into the checkboxes group from the db? (decode json)

2. Apparently there was a problem saving the array into the db. Other fields work.
Max_admin 13 Oct, 2023
1- set the data using a PHP action:
$this->data["field_name"] = json_decode($this->get("read_data123.field_name"), true);


2- remove the ART field before setting it:

-ART
ART={data:ART}
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
You need to login to be able to post a reply.