Checkbox dynamic value from DB

Set dynamic checkbox values from a database in ChronoForms v6.

Overview

The issue occurs when stored data is a JSON string instead of a plain array, preventing checkboxes from being selected upon form load.
Use the JSON decode variable format in the Checked status provider field to properly interpret the stored data.

M. M.Abletech 13 Mar, 2018

Hi,

I need to dynamically load value from DB for checkbox field: if it is check or not. How can I do that in chronoform v6? I know how to in chronoform v5.

Should I fill the advance tab? http://prntscr.com/iqmcu7

What should I fill both "Checked status provider" and "Data value"?

Thanks!

Max_admin 24 Mar, 2018

Hello,

Its the "Checked status provider" which should be used, use {var:read_data_name.model_name.field_name}

Or just use {var:read_data_name.model_name} in the "Data provider" under the "Display section".

Best regards

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

pa pat01 12 Jul, 2019

Hi Max

Has this changed in CF 6.1?

I use

{var:read_data13.Data_EPUser.usergroups}

in Checked Options values, but the checkboxes are not checked.

For example using

{var:read_data13.Data_EPUser.firstname}

works fine in a textfield.

It's just the checkboxes that are not selected after load data. The debugger shows:

[read_data13] => Array
        (
            [log] => Array
                (
                    [0] => SELECT `Data_EPUser`.`id` AS `Data_EPUser.id`, `Data_EPUser`.`privacy` AS `Data_EPUser.privacy`, `Data_EPUser`.`secondname` AS `Data_EPUser.secondname`, `Data_EPUser`.`avatar` AS `Data_EPUser.avatar`, `Data_EPUser`.`params` AS `Data_EPUser.params`, `Data_EPUser`.`facebook_id` AS `Data_EPUser.facebook_id`, `Data_EPUser`.`twitter_id` AS `Data_EPUser.twitter_id`, `Data_EPUser`.`google_id` AS `Data_EPUser.google_id`, `Data_EPUser`.`linkedin_id` AS `Data_EPUser.linkedin_id`, `Data_EPUser`.`instagram_id` AS `Data_EPUser.instagram_id`, `Data_EPUser`.`lastname2` AS `Data_EPUser.lastname2`, `Data_EPUser`.`firstname` AS `Data_EPUser.firstname`, `Data_EPUser`.`lastname` AS `Data_EPUser.lastname`, `Data_EPUser`.`wohnort` AS `Data_EPUser.wohnort`, `Data_EPUser`.`email` AS `Data_EPUser.email`, `Data_EPUser`.`usergroups` AS `Data_EPUser.usergroups` FROM `chrono_jsn_users` AS `Data_EPUser` WHERE `Data_EPUser`.`id` = '612' LIMIT 100;
                )

            [var] => Array
                (
                    [Data_EPUser] => Array
                        (
                            [id] => 612
                            [privacy] => []
                            [secondname] => 
                            [avatar] => 
                            [params] => 
                            [facebook_id] => 
                            [twitter_id] => 
                            [google_id] => 
                            [linkedin_id] => 
                            [instagram_id] => 
                            [lastname2] => 
                            [firstname] => Vorname 1
                            [lastname] => Nachname 1
                            [wohnort] => Wohnort 1
                            [email] => mail1@aa.dd
                            [usergroups] => ["10","11","12"]
                        )

                )

        )

)

So data is there.

Any idea why it's not working?

Thanks a lot.

Patrick

Max_admin 13 Jul, 2019

Answer

1 Likes

It's working here, IF that value is an ARRAY, but if the data is stored as JSON string in your table then you should use:

{var.jsonde:read_data13.Data_EPUser.usergroups}

Best regards

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

pa pat01 15 Jul, 2019

Works great, thanks a lot!

This topic is locked and no more replies can be posted.