Forums

Chronoforms multipage

Pkoll 27 Apr, 2023
I have a multipage. In the first page I have an action to read a database record {Model1} to display it in a dropdown. Select in the dropdown a record en have a button to page2
Array
(
    [option] => com_chronoforms7
    [cont] => manager
    [chronoform] => aanmelden-optreden
    [gpage] => Ophalen_evenementgegevens
    [datum_optreden] => 1
    [__cf_token] => 41996b8c-0d71-4b35-8b51-4389b66e5af8
)
Array
(
    [Ophalen_evenementgegevens_validation] => Array
        (
            [log] => Automatic validation enabled.
            [var] => true
        )

    [read_data_4] => Array
        (
            [result] => Data read successfully!
            [log] => Array
                (
                    [0] => SELECT `Model4`.`id` AS `Model4.id`, `Model4`.`aanmaak_datum` AS `Model4.aanmaak_datum`, `Model4`.`wijzigingen_datum` AS `Model4.wijzigingen_datum`, `Model4`.`datum_optreden` AS `Model4.datum_optreden`, `Model4`.`datum_optreden_aangepast` AS `Model4.datum_optreden_aangepast`, `Model4`.`locatie_optreden` AS `Model4.locatie_optreden`, `Model4`.`evenement` AS `Model4.evenement`, `Model4`.`tijd_van_tot` AS `Model4.tijd_van_tot`, `Model4`.`naam_contact` AS `Model4.naam_contact`, `Model4`.`telefoon_contact` AS `Model4.telefoon_contact`, `Model4`.`email_contact` AS `Model4.email_contact`, `Model4`.`datum_checklist` AS `Model4.datum_checklist`, `Model4`.`datum_programma` AS `Model4.datum_programma`, `Model4`.`datum_prog_verstuur` AS `Model4.datum_prog_verstuur`, `Model4`.`opmerkingen` AS `Model4.opmerkingen` FROM `optreden-begonia` AS `Model4` WHERE `Model4`.`id` = '1';
                )

            [var] => Array
                (
                    [Model4] => Array
                        (
                            [id] => 1
                            [aanmaak_datum] => 2023-04-20
                            [wijzigingen_datum] => 2023-04-26
                            [datum_optreden] => 2023-04-25
                            [datum_optreden_aangepast] => 
                            [locatie_optreden] => in de schuur
                            [evenement] => Nieuw evenement
                            [tijd_van_tot] => 14.00 tot 17.00 uur
                            [naam_contact] => Naam
                            [telefoon_contact] => telefoon
                            [email_contact] => e-mail
                            [datum_checklist] => 
                            [datum_programma] => programma datum
                            [datum_prog_verstuur] => verstuur datum
                            [opmerkingen] => dit is verzonnen
                        )

                )

        )

)

In this page I will show the content of that database record. So I have in the action page from page 2 a read from the same database record {Model4} with the condition from the dropdown in the first page.
Array
(
    [option] => com_chronoforms7
    [cont] => manager
    [chronoform] => aanmelden-optreden
    [gpage] => Ophalen_evenementgegevens
    [datum_optreden] => 2
    [__cf_token] => a65499f7-7870-4c86-89f1-879f73d944db
)
Array
(
    [Ophalen_evenementgegevens_validation] => Array
        (
            [log] => Automatic validation enabled.
            [var] => true
        )

    [read_data_4] => Array
        (
            [result] => Data read successfully!
            [log] => Array
                (
                    [0] => SELECT `Model4`.`id` AS `Model4.id`, `Model4`.`aanmaak_datum` AS `Model4.aanmaak_datum`, `Model4`.`wijzigingen_datum` AS `Model4.wijzigingen_datum`, `Model4`.`datum_optreden` AS `Model4.datum_optreden`, `Model4`.`datum_optreden_aangepast` AS `Model4.datum_optreden_aangepast`, `Model4`.`locatie_optreden` AS `Model4.locatie_optreden`, `Model4`.`evenement` AS `Model4.evenement`, `Model4`.`tijd_van_tot` AS `Model4.tijd_van_tot`, `Model4`.`naam_contact` AS `Model4.naam_contact`, `Model4`.`telefoon_contact` AS `Model4.telefoon_contact`, `Model4`.`email_contact` AS `Model4.email_contact`, `Model4`.`datum_checklist` AS `Model4.datum_checklist`, `Model4`.`datum_programma` AS `Model4.datum_programma`, `Model4`.`datum_prog_verstuur` AS `Model4.datum_prog_verstuur`, `Model4`.`opmerkingen` AS `Model4.opmerkingen` FROM `optreden-begonia` AS `Model4` WHERE `Model4`.`id` = '2';
                )

            [var] => Array
                (
                    [Model4] => Array
                        (
                            [id] => 2
                            [aanmaak_datum] => 2023-04-20
                            [wijzigingen_datum] => 2023-04-24
                            [datum_optreden] => 2023-05-13
                            [datum_optreden_aangepast] => 
                            [locatie_optreden] => nergens
                            [evenement] => Bloemenzondag
                            [tijd_van_tot] => middag
                            [naam_contact] => Johan en Anita Kool
                            [telefoon_contact] => 0651284732
                            [email_contact] => info@boeketje.nl
                            [datum_checklist] => 2023-04-14 00:00:00
                            [datum_programma] => donderdag 20 april
                            [datum_prog_verstuur] => vrijdag 5 mei
                            [opmerkingen] => Het Boeketje
                        )

                )

        )

)

In the debug all is oké. But the view in the second page doesn't show anything.
I use a textfield with value {var:Model4.evenement} but the field is empty.

Wat goes wrong???
Max_admin 28 Apr, 2023
Answer
1 Likes
The syntax should be: {var:read_data_4.Model4.field}
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Pkoll 28 Apr, 2023
Thanks it works. Why is it different from the first page.
Max_admin 29 Apr, 2023
it should be the same syntax on all pages
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
You need to login to be able to post a reply.