Display DB Read Results

Display database read results in ChronoForms text fields.

Overview

The issue occurs when using the Read Data action followed by Display Section, where the debugger shows data is loaded but text fields remain blank because the field value settings are not correctly linked to the data array.
To resolve this, set the 'Value' of each text field to the correct data path using the format {var:read_data4.Data.attribute_name}, replacing 'attribute_name' with the specific column name from your database query.

Answered
ChronoForms v6
U U Can Drive 28 Mar, 2018
Baffled ???

I am using "Read Data" followed by "Display Section"

The debugger shows that the record has been successfully loaded and the data is there, but it's not displaying in the relevant "Text Fields"

Does anyone know what I'm missing?

Array
(
    [option] => com_chronoforms6
    [chronoform] => FileRequest
    [fbm_1635736963332990] => base_domain=.ucandrive.com.au
    [_ga] => GA1.3.456503532.1507494079
    [_gid] => GA1.3.1065541731.1522202846
    [joomla_user_state] => logged_in
    [df095ea18f45903807902fe9758177c0] => veavc2p94u0lmgd5mrar5njlo5
    [jfbconnect_permissions_granted] => ["email","public_profile"]
    [jfbconnect_autologin_disable] => 1
    [ac2664da8cb0e5732104ddf8c4826d71] => gbdnr3r3n16dkeuv2t3er53f72
    [jSGCacheBypass] => 1
    [Itemid] => 
    [397703414a0c77ca087769c0c97ac945] => 1
)
Array
(
    [read_data4] => Array
        (
            [log] => Array
                (
                    [0] => SELECT `Data`.`aid` AS `Data.aid`, `Data`.`user_id` AS `Data.user_id`, `Data`.`created` AS `Data.created`, `Data`.`modified` AS `Data.modified`, `Data`.`LicenseNumber` AS `Data.LicenseNumber`, `Data`.`LessonSelection` AS `Data.LessonSelection` FROM `00_UCD_StudentFileRequest` AS `Data` WHERE `Data`.`user_id` = '1065';
                )

            [var] => Array
                (
                    [Data] => Array
                        (
                            [aid] => 1
                            [user_id] => 1065
                            [created] => 2018-03-28 07:30:49
                            [LicenseNumber] => 123456789
                            [LessonSelection] => LessonEntry01 
                        )

                )

        )

)
Thank you in advance
he healyhatman 04 Apr, 2018
Answer
Under the field "Value" setting, put {var:read_data4.Data.name_of_the_attribute}
This topic is locked and no more replies can be posted.