Checkbox dynamic value from DB

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!