Forums

Simple form test:
- text field (name=title, id=title)
- checkboxes (name=choices[], id=choices, options y=Yes n=No)
- submit button
When submitting the values are saved in a table. I checked the table, there's a new record.

I add a Read Data action in the load event. Set the Database table property and set the Model name to myRecord. In the where conditions I set aid:22 (22 is the aid of the record).
In the Display Section I set the Data Provider as {var:read_data5.myRecord}.
I save and reload the preview form.
The title field is filled with the value saved in the record, the 2 checkboxes are unchecked.

I'm using CF v6.0.14 on joomla 3.8.2.

maxx

Hi maxx,

Apologies for the late reply!

It depends on how the data was saved and then read again, please add a "Debugger" after the "read data" and before the "display section", how is the data represented ?

Best regards

I have a similiar issue.
​
Data of the Checkboxes is successfully stored to the DB as:

["Cafeteria","Aufenthaltsraum","Keller","Wände","Bürotische (freie Flächen)","Toiletten","Bad"]

values and Labels are identical. I added checkboxes1 to special fields as described by emmex.
Putting {var:read_data.Model.checkboxes1} to "Checked options values" obviously doesn't work. I am able to load all other data of the DB, just not the Checkboxes.
I read this thread but I'm not getting further. Do I still need to write a php code in ChronoForms 6? If so, could you help me with that?

Thanks!

Source Code of the Checkboxes:

<div class="multifield grouped fields" >
 <label >Detailleistungen1:</label>
 <input type="hidden" name="detailleistungen1" value="" data-ghost="1" />
 <div class="field" ><div class="ui checkbox" ><input data-events="[]" name="detailleistungen1[]" id="detailleistungen10" type="checkbox" value="Küche" />
 <label for="detailleistungen10" >Küche</label></div></div>
 <div class="field" ><div class="ui checkbox" ><input data-events="[]" name="detailleistungen1[]" id="detailleistungen11" type="checkbox" value="Cafeteria" />
 <label for="detailleistungen11" >Cafeteria</label></div></div>
 <div class="field" ><div class="ui checkbox" ><input data-events="[]" name="detailleistungen1[]" id="detailleistungen12" type="checkbox" value="Aufenthaltsraum" />
 <label for="detailleistungen12" >Aufenthaltsraum</label></div></div>
 <div class="field" ><div class="ui checkbox" ><input data-events="[]" name="detailleistungen1[]" id="detailleistungen13" type="checkbox" value="Keller" />
 <label for="detailleistungen13" >Keller</label></div></div>
 <div class="field" ><div class="ui checkbox" ><input data-events="[]" name="detailleistungen1[]" id="detailleistungen14" type="checkbox" value="Wände" />
 <label for="detailleistungen14" >Wände</label></div></div>
 <div class="field" ><div class="ui checkbox" ><input data-events="[]" name="detailleistungen1[]" id="detailleistungen15" type="checkbox" value="Bürotische (freie Flächen)" />
 <label for="detailleistungen15" >Bürotische (freie Flächen)</label></div></div>
 <div class="field" ><div class="ui checkbox" ><input data-events="[]" name="detailleistungen1[]" id="detailleistungen16" type="checkbox" value="Toiletten" />
 <label for="detailleistungen16" >Toiletten</label></div></div>
 <div class="field" ><div class="ui checkbox" ><input data-events="[]" name="detailleistungen1[]" id="detailleistungen17" type="checkbox" value="Bad" />
 <label for="detailleistungen17" >Bad</label></div></div>
 <div class="field" ><div class="ui checkbox" ><input data-events="[]" name="detailleistungen1[]" id="detailleistungen18" type="checkbox" value="Waschküche" />
 <label for="detailleistungen18" >Waschküche</label></div></div>
 <div class="field" ><div class="ui checkbox" ><input data-events="[]" name="detailleistungen1[]" id="detailleistungen19" type="checkbox" value="Treppen/-geländer" />
 <label for="detailleistungen19" >Treppen/-geländer</label></div></div>
</div>

Hi morphz,
​
Please add a debugger action and post the debug report here
​
Best regards

It's huge.
​
"detailleistungen1" and "detailleistungen2" are the checkboxes.
Id like to put {var:read_data15.Article.detailleistungen1} in "Checked options values".
​
What php code do I need to have the result as:
​
Cafeteria
Aufenthaltsraum
Bad
Waschküche
...
​
instead of

["Cafeteria","Aufenthaltsraum","Keller","Wände","Bürotische (freie Flächen)","Toiletten","Bad"]

​
Here the debug report:
​

Array
(
    [article_id] => 10
    [event] => edit
    [c92a01bebeafb3dc49972672e8504dce] => 9f5e1bfe45c977d35b389cd35b13e84a
    [f25c26af7e50705032a66e7bfc9e57d8] => 156a2b8886b6fac2f4ca660a99c78f17
    [Itemid] => 127
    [option] => com_content
    [view] => article
    [id] => 11
)

Array
(
    [read_data15] => Array
        (
            [log] => Array
                (
                    [0] => SELECT `Article`.`aid` AS `Article.aid`, `Article`.`user_id` AS `Article.user_id`, `Article`.`created` AS `Article.created`, `Article`.`modified` AS `Article.modified`, `Article`.`datum1` AS `Article.datum1`, `Article`.`name1` AS `Article.name1`, `Article`.`strasse1` AS `Article.strasse1`, `Article`.`email1` AS `Article.email1`, `Article`.`kunde1` AS `Article.kunde1`, `Article`.`vorname1` AS `Article.vorname1`, `Article`.`plz1` AS `Article.plz1`, `Article`.`ort1` AS `Article.ort1`, `Article`.`gewnschte_dienstleistung1` AS `Article.gewnschte_dienstleistung1`, `Article`.`objekt1` AS `Article.objekt1`, `Article`.`detailleistungen1` AS `Article.detailleistungen1`, `Article`.`kundenschlssel_vorhanden1` AS `Article.kundenschlssel_vorhanden1`, `Article`.`retourniert_am1` AS `Article.retourniert_am1`, `Article`.`an1` AS `Article.an1`, `Article`.`detailleistungen2` AS `Article.detailleistungen2`, `Article`.`reinigungsmaterialien1` AS `Article.reinigungsmaterialien1`, `Article`.`arbeitsgeraete1` AS `Article.arbeitsgeraete1`, `Article`.`checkliste_vorhanden1` AS `Article.checkliste_vorhanden1`, `Article`.`strasse2` AS `Article.strasse2`, `Article`.`plz2` AS `Article.plz2`, `Article`.`ort2` AS `Article.ort2`, `Article`.`stockwerk1` AS `Article.stockwerk1`, `Article`.`zufahrt1` AS `Article.zufahrt1`, `Article`.`lift1` AS `Article.lift1`, `Article`.`strasse4` AS `Article.strasse4`, `Article`.`plz4` AS `Article.plz4`, `Article`.`ort4` AS `Article.ort4`, `Article`.`besichtigungstermin1` AS `Article.besichtigungstermin1`, `Article`.`gewnschter_ausfuehrungstermin` AS `Article.gewnschter_ausfuehrungstermin`, `Article`.`vorauszahlung1` AS `Article.vorauszahlung1`, `Article`.`strasse3` AS `Article.strasse3`, `Article`.`plz3` AS `Article.plz3`, `Article`.`ort3` AS `Article.ort3`, `Article`.`stockwerk2` AS `Article.stockwerk2`, `Article`.`zufahrt2` AS `Article.zufahrt2`, `Article`.`lift2` AS `Article.lift2`, `Article`.`name2` AS `Article.name2`, `Article`.`vorname2` AS `Article.vorname2`, `Article`.`strasse5` AS `Article.strasse5`, `Article`.`plz5` AS `Article.plz5`, `Article`.`ort5` AS `Article.ort5`, `Article`.`definitiver_ausfuehrungstermin` AS `Article.definitiver_ausfuehrungstermin`, `Article`.`betrag_chf` AS `Article.betrag_chf`, `Article`.`anzahl_stunden` AS `Article.anzahl_stunden`, `Article`.`anzahl_regiestunden` AS `Article.anzahl_regiestunden`, `Article`.`anzahl_teilnehmer` AS `Article.anzahl_teilnehmer`, `Article`.`preis_pro_stunde_in_chf` AS `Article.preis_pro_stunde_in_chf`, `Article`.`entsorgung_kilogramm` AS `Article.entsorgung_kilogramm`, `Article`.`anzahl_kilometer` AS `Article.anzahl_kilometer`, `Article`.`wegpauschale_in_chf` AS `Article.wegpauschale_in_chf`, `Article`.`stunden_ansatz_in_chf` AS `Article.stunden_ansatz_in_chf`, `Article`.`regiestunden_ansatz_in_chf2` AS `Article.regiestunden_ansatz_in_chf2`, `Article`.`ansatz_pro_teilnehmer_in_chf` AS `Article.ansatz_pro_teilnehmer_in_chf`, `Article`.`preis_pro_gruppe_in_chf` AS `Article.preis_pro_gruppe_in_chf`, `Article`.`ansatz_pro_kilogramm_in_chf` AS `Article.ansatz_pro_kilogramm_in_chf`, `Article`.`ansatz_pro_kilometer_in_chf` AS `Article.ansatz_pro_kilometer_in_chf`, `Article`.`kostendach_exkl_regiestunden_in_chf` AS `Article.kostendach_exkl_regiestunden_in_chf`, `Article`.`test_dropdown` AS `Article.test_dropdown` FROM `bnd_chronoforms_data_auftragserfassung_reinigung` AS `Article` WHERE `Article`.`aid` = '10' LIMIT 100;
                )

            [var] => Array
                (
                    [Article] => Array
                        (
                            [aid] => 10
                            [user_id] => 206
                            [created] => 2018-02-19 14:58:04
                            [datum1] => 13-12-2017
                            [name1] => Apfelbrot
                            [strasse1] => Am Rhein 18
                            [email1] => mail@gmail.com
                            [kunde1] => kunde ist könig
                            [vorname1] => Bartholomäus
                            [plz1] => 6428
                            [ort1] => Winterthur
                            [gewnschte_dienstleistung1] => Entsorgung / Räumung inkl. Reinigung
                            [objekt1] => Büro
                            [detailleistungen1] => ["Cafeteria","Aufenthaltsraum","Bad","Waschküche","Treppen\/-geländer"]
                            [kundenschlssel_vorhanden1] => Ja
                            [retourniert_am1] => 2018-02-23 15:54:00
                            [an1] => Wyniger Beatrice
                            [detailleistungen2] => ["Telefone","Fenster","Böden trocken","Staubsaugen"]
                            [reinigungsmaterialien1] => Mitnehmen
                            [arbeitsgeraete1] => Mitnehmen
                            [checkliste_vorhanden1] => 1
                            [strasse2] => Soeinestrasse 15
                            [plz2] => 7492
                            [ort2] => Kräiligen
                            [stockwerk1] => 5
                            [zufahrt1] => 1
                            [lift1] => 1
                            [strasse4] => Gartenweg 5
                            [plz4] => 4362
                            [ort4] => Thun
                            [besichtigungstermin1] => 2018-02-27 15:57:00
                            [gewnschter_ausfuehrungstermin] => 2018-01-24 15:00:00
                            [vorauszahlung1] => Ja
                            [strasse3] => Einandererweg 82
                            [plz3] => 9213
                            [ort3] => Steffisburg
                            [stockwerk2] => EG
                            [zufahrt2] => 1
                            [lift2] => 1
                            [name2] => Rechnung
                            [vorname2] => Mister
                            [strasse5] => Rechnungsweg 18
                            [plz5] => 8241
                            [ort5] => Rechnungsort
                            [definitiver_ausfuehrungstermin] => 2018-02-21 15:57:00
                            [betrag_chf] => 300
                            [anzahl_stunden] => anz. stundeeeen
                            [anzahl_regiestunden] => anz regieee
                            [anzahl_teilnehmer] => anz teilll
                            [preis_pro_stunde_in_chf] => preis pro stundeee
                            [entsorgung_kilogramm] => entsorgung und kiloo
                            [anzahl_kilometer] => 5000
                            [wegpauschale_in_chf] => 20
                            [stunden_ansatz_in_chf] => 16
                            [regiestunden_ansatz_in_chf2] => 18
                            [ansatz_pro_teilnehmer_in_chf] => 20
                            [preis_pro_gruppe_in_chf] => 22
                            [ansatz_pro_kilogramm_in_chf] => 24
                            [ansatz_pro_kilometer_in_chf] => 26
                            [kostendach_exkl_regiestunden_in_chf] => 28
                            [test_dropdown] => 
                        )

                )

        )

)

Hi morphz,
​
Using this in a PHP action seems to work when I test - in your case I'm not sure where the array is being turned into a string. I can't find a setting for that. [pre]$temp = $this->data('checkboxes1', '');
if ( is_array($temp) ) {[br] $temp = implode('<br />', $temp);[br]} else {[br] $temp = str_replace(',', '<br />', $temp);[br]}[br]$this->data('checkboxes1', $temp, true);[/pre]
Bob
​
PS In your form replace checkboxes1 with detailleistungen1[br]

I think I mixed something there.. My apologies
I wanted the output to be changed when I SELECT, not when I INSERT data.
​
Now that I think about it, I would like to run the php script when I INSERT it as described above.
​
unfortunately I can't get it running with your code over a few days now😟
Can you please help me again? You'll have some coffee for your awesome help greyhead
​
Here is the debug. This time the one showing when I INSERT a record:

Array
(
    [chronoform] => auftragserfassung_reinigung
    [event] => submit
    [anzahl_stunden] => 
    [anzahl_regiestunden] => 
    [anzahl_teilnehmer] => 
    [preis_pro_stunde_in_chf] => 
    [entsorgung_kilogramm] => 
    [anzahl_kilometer] => 
    [wegpauschale_in_chf] => 
    [stunden_ansatz_in_chf] => 
    [regiestunden_ansatz_in_chf2] => 
    [ansatz_pro_teilnehmer_in_chf] => 
    [preis_pro_gruppe_in_chf] => 
    [ansatz_pro_kilogramm_in_chf] => 
    [ansatz_pro_kilometer_in_chf] => 
    [kostendach_exkl_regiestunden_in_chf] => 
    [button127] => 
    [g-recaptcha-response] => 03ANcjosrxe5oDdDGruW9vwtYVYPXypetEqklId6yNxm4vCGkYFJynofrQoZc3cqtaKPJR1UwF0-xUISwgMHdOEOE2ajrJsrSBMDDs_DreXIeLG4ViSjCa3VYm4rVQogsk07ng0vGx7VX3hMia97PAgWw1oeS_Rfd-8f3hVTMt1fNmjSDU_v7B64AM3HRjWY2dAQSN3vJecrfK1AFKuR4poyV77lLHRwPxuq9Yx2mB0bW9yA9kOOGtQwEX-iSBVrkx5wPsLnL1wv2ABdyDYCa70Lzpr_NbjUKlbQLymXUSbSWt-dtivdlY2Yh033nAZhpI4LKwnvNTPeKJPwtGkmpC24LHoXZuAhRSPl-Fc-rthpvAqSJtKsa3MoCxkri4Lx6BD4szQ2yUhF0CZJJbD53NCQCDv00rM3qL8Op4GT_2j9Lc2ZGUFyGQskU5XnvSNc0ctQjQR8ZXQSwZ
    [c92a01bebeafb3dc49972672e8504dce] => 95a0c953b32ee25bf0ef7def75a5da05
    [f25c26af7e50705032a66e7bfc9e57d8] => 4c81f2a52d9d9a6855b90661916f1bdd
    [Itemid] => 113
    [option] => com_content
    [view] => article
    [id] => 7
    [datum1] => 
    [name1] => 
    [strasse1] => 
    [email1] => 
    [kunde1] => 
    [vorname1] => 
    [plz1] => 
    [ort1] => 
    [gewnschte_dienstleistung1] => Endreinigung
    [button19] => 
    [objekt1] => Studio
    [detailleistungen1] => Array
        (
            [0] => Küche
            [1] => Cafeteria
            [2] => Aufenthaltsraum
        )

    [kundenschlssel_vorhanden1] => 
    [retourniert_am1] => 
    [an1] => 
    [detailleistungen2] => Array
        (
            [0] => Telefone
            [1] => Fenster
            [2] => Böden trocken
        )

    [reinigungsmaterialien1] => Vor Ort
    [arbeitsgeraete1] => Vor Ort
    [checkliste_vorhanden1] => 
    [button49] => Adressen
    [strasse2] => 
    [plz2] => 
    [ort2] => 
    [stockwerk1] => 
    [zufahrt1] => 
    [lift1] => 
    [strasse4] => 
    [plz4] => 
    [ort4] => 
    [besichtigungstermin1] => 
    [gewnschter_ausfuehrungstermin] => 
    [vorauszahlung1] => 
    [strasse3] => 
    [plz3] => 
    [ort3] => 
    [stockwerk2] => 
    [zufahrt2] => 
    [lift2] => 
    [name2] => 
    [vorname2] => 
    [strasse5] => 
    [plz5] => 
    [ort5] => 
    [definitiver_ausfuehrungstermin] => 
    [betrag_chf] => 
    [button81] => 
)

Array
(
    [google_nocaptcha19] => Array
        (
            [response] => Array
                (
                    [success] => 1
                    [challenge_ts] => 2018-03-06T07:49:17Z
                    [hostname] => farb-formulare.jdevcloud.com
                )

            [_success] => The NoCaptcha verification was successfull.
            [var] => 1
        )

    [save_data18] => Array
        (
            [data] => Array
                (
                    [created] => 2018-03-06 07:49:30
                    [user_id] => 0
                    [test_dropdown] => ""
                    [datum1] => 
                    [name1] => 
                    [strasse1] => 
                    [email1] => 
                    [kunde1] => 
                    [vorname1] => 
                    [plz1] => 
                    [ort1] => 
                    [gewnschte_dienstleistung1] => Endreinigung
                    [objekt1] => Studio
                    [detailleistungen1] => ["Küche","Cafeteria","Aufenthaltsraum"]
                    [kundenschlssel_vorhanden1] => 
                    [retourniert_am1] => 
                    [an1] => 
                    [detailleistungen2] => ["Telefone","Fenster","Böden trocken"]
                    [reinigungsmaterialien1] => Vor Ort
                    [arbeitsgeraete1] => Vor Ort
                    [checkliste_vorhanden1] => 
                    [strasse2] => 
                    [plz2] => 
                    [ort2] => 
                    [stockwerk1] => 
                    [zufahrt1] => 
                    [lift1] => 
                    [strasse4] => 
                    [plz4] => 
                    [ort4] => 
                    [besichtigungstermin1] => 
                    [gewnschter_ausfuehrungstermin] => 
                    [vorauszahlung1] => 
                    [strasse3] => 
                    [plz3] => 
                    [ort3] => 
                    [stockwerk2] => 
                    [zufahrt2] => 
                    [lift2] => 
                    [name2] => 
                    [vorname2] => 
                    [strasse5] => 
                    [plz5] => 
                    [ort5] => 
                    [definitiver_ausfuehrungstermin] => 
                    [betrag_chf] => 
                    [anzahl_stunden] => 
                    [anzahl_regiestunden] => 
                    [anzahl_teilnehmer] => 
                    [preis_pro_stunde_in_chf] => 
                    [entsorgung_kilogramm] => 
                    [anzahl_kilometer] => 
                    [wegpauschale_in_chf] => 
                    [stunden_ansatz_in_chf] => 
                    [regiestunden_ansatz_in_chf2] => 
                    [ansatz_pro_teilnehmer_in_chf] => 
                    [preis_pro_gruppe_in_chf] => 
                    [ansatz_pro_kilogramm_in_chf] => 
                    [ansatz_pro_kilometer_in_chf] => 
                    [kostendach_exkl_regiestunden_in_chf] => 
                )

            [_success] => Data saved successfully
            [log] => Array
                (
                    [0] => INSERT INTO `bnd_chronoforms_data_auftragserfassung_reinigung` (`created`, `user_id`, `test_dropdown`, `datum1`, `name1`, `strasse1`, `email1`, `kunde1`, `vorname1`, `plz1`, `ort1`, `gewnschte_dienstleistung1`, `objekt1`, `detailleistungen1`, `kundenschlssel_vorhanden1`, `retourniert_am1`, `an1`, `detailleistungen2`, `reinigungsmaterialien1`, `arbeitsgeraete1`, `checkliste_vorhanden1`, `strasse2`, `plz2`, `ort2`, `stockwerk1`, `zufahrt1`, `lift1`, `strasse4`, `plz4`, `ort4`, `besichtigungstermin1`, `gewnschter_ausfuehrungstermin`, `vorauszahlung1`, `strasse3`, `plz3`, `ort3`, `stockwerk2`, `zufahrt2`, `lift2`, `name2`, `vorname2`, `strasse5`, `plz5`, `ort5`, `definitiver_ausfuehrungstermin`, `betrag_chf`, `anzahl_stunden`, `anzahl_regiestunden`, `anzahl_teilnehmer`, `preis_pro_stunde_in_chf`, `entsorgung_kilogramm`, `anzahl_kilometer`, `wegpauschale_in_chf`, `stunden_ansatz_in_chf`, `regiestunden_ansatz_in_chf2`, `ansatz_pro_teilnehmer_in_chf`, `preis_pro_gruppe_in_chf`, `ansatz_pro_kilogramm_in_chf`, `ansatz_pro_kilometer_in_chf`, `kostendach_exkl_regiestunden_in_chf`)  values  ('2018-03-06 07:49:30', '0', '""', '', '', '', '', '', '', '', '', 'Endreinigung', 'Studio', '["Küche","Cafeteria","Aufenthaltsraum"]', '', '', '', '["Telefone","Fenster","Böden trocken"]', 'Vor Ort', 'Vor Ort', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
                )

            [var] => Array
                (
                    [created] => 2018-03-06 07:49:30
                    [user_id] => 0
                    [test_dropdown] => ""
                    [datum1] => 
                    [name1] => 
                    [strasse1] => 
                    [email1] => 
                    [kunde1] => 
                    [vorname1] => 
                    [plz1] => 
                    [ort1] => 
                    [gewnschte_dienstleistung1] => Endreinigung
                    [objekt1] => Studio
                    [detailleistungen1] => ["Küche","Cafeteria","Aufenthaltsraum"]
                    [kundenschlssel_vorhanden1] => 
                    [retourniert_am1] => 
                    [an1] => 
                    [detailleistungen2] => ["Telefone","Fenster","Böden trocken"]
                    [reinigungsmaterialien1] => Vor Ort
                    [arbeitsgeraete1] => Vor Ort
                    [checkliste_vorhanden1] => 
                    [strasse2] => 
                    [plz2] => 
                    [ort2] => 
                    [stockwerk1] => 
                    [zufahrt1] => 
                    [lift1] => 
                    [strasse4] => 
                    [plz4] => 
                    [ort4] => 
                    [besichtigungstermin1] => 
                    [gewnschter_ausfuehrungstermin] => 
                    [vorauszahlung1] => 
                    [strasse3] => 
                    [plz3] => 
                    [ort3] => 
                    [stockwerk2] => 
                    [zufahrt2] => 
                    [lift2] => 
                    [name2] => 
                    [vorname2] => 
                    [strasse5] => 
                    [plz5] => 
                    [ort5] => 
                    [definitiver_ausfuehrungstermin] => 
                    [betrag_chf] => 
                    [anzahl_stunden] => 
                    [anzahl_regiestunden] => 
                    [anzahl_teilnehmer] => 
                    [preis_pro_stunde_in_chf] => 
                    [entsorgung_kilogramm] => 
                    [anzahl_kilometer] => 
                    [wegpauschale_in_chf] => 
                    [stunden_ansatz_in_chf] => 
                    [regiestunden_ansatz_in_chf2] => 
                    [ansatz_pro_teilnehmer_in_chf] => 
                    [preis_pro_gruppe_in_chf] => 
                    [ansatz_pro_kilogramm_in_chf] => 
                    [ansatz_pro_kilometer_in_chf] => 
                    [kostendach_exkl_regiestunden_in_chf] => 
                    [aid] => 17
                )

        )

)

I assume the php code is placed after the "multipage" and before "save data". correct?
​
Thank you a million times

Hi,
​
Your checkboxes data are saved in JSON format which is OK, just add this string in the "Read data" "Special fields" box:

detailleistungen1/json

You may add more lines for other fields saved in json format too, this line should decode the data when its read.
​
Best regards

This! Awesome