Forums

CF8 - Read data

globodyne 21 Oct, 2023
Hi

    My database table : user_information with 4 columns (id, name, email and matricule) I created a form with : Dropdown name, email text field and matricule text field.


In submit I have add read data (name: read_data2) I link the table name to user_information and Read type All matching records and behaviors I added Data merge

In Dropdown I have added dynamic option
Data source : {var:read_data2}
Option Value Code: {row:name}
Option Value text: {row:name}

Options : empty

I try to make the dropdown read the data from the name column of database user_information but dropdown don't show nothing. Any help please as my goal is to use the dropdown to autofilled the email and matricule

Thank in advance
Max_admin 23 Oct, 2023
Answer
1 Likes
You should have the "Read data" in "Load", because you are loading the data for a field in the load area of the form.

Also you do not need "Data merge"
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
globodyne 23 Oct, 2023
Hello Max,

Thank you for quick reply. I have load the "read data" in the top of the form above the field and dropdown work very well. But how to make it autofill the other field like email and matricule when we select a value in dropdown ?
You need to login to be able to post a reply.