Display additional fields / Dynamic DropDown

jformicola 23 Jan, 2020
How do I get two fields to show when using a “read data” action to dynamically
populate my checklist group?  

I want both fields 2 and 3 to show next to the check box (and the ID saved obviously). I don't want to save all three, just number 1, I just need 2 and 3 to show up beside the checkbox. I'm using chronoforms 6.

Display additional fields / Dynamic DropDown image 1Display additional fields / Dynamic DropDown image 2




Array
(
    [Itemid] => 275
    [option] => com_chronoforms6
    [view] => form
)
Array
(
    [read_data14] => Array
        (
           
[log] => Array
               
(
                   
[0] => SELECT `Data14`.`ID` AS `Data14.ID`, `Data14`.`Subject` AS
`Data14.Subject`, `Data14`.`Notes_For_Trainer` AS `Data14.Notes_For_Trainer`
FROM `tbltrainedtopics` AS `Data14` LIMIT 100;
               
)
           
[var] => Array
               
(
                   
[1] => MRI - Changing Database
                   
[2] => MRI - Calendar - Advancing the date
                   
[3] => MRI - Calendar - Navigating
               
)
        )
healyhatman 24 Jan, 2020
Answer
1 Likes
return an array of key/value pairs, TWO FIELDS MUST BE PROVIDED

Not 3.

So what you actually want is
ID
CONCAT(Subject , ' - ' , Notes_For_Trainer):text
jformicola 24 Jan, 2020
Wow, very nice! You nailed it! Thanks so much!
This topic is locked and no more replies can be posted.