Please write a review for the extension you are using on the Joomla extensions directory before posting a new question as we are being spammed by many negative reviews.

Thank you for your support!

Populate fields automatically when you enter a key value in a specific field

moto05 posted Nov 20, 2023 at 16:25
Imagining I have a "test_db" database and a "test_tbl" table with 4 columns ("col_id", "col_title", "col_surname", "col_name") I would like that, when I select a value in the "form_id" field, the values ​​of the "col_surname" and "col_name" columns extracted from the row for which the value in "col_id" is the same as that selected in the "form_id" field are automatically inserted in the "form_surname" and "form_name" fields .
I would like to point out that the "form_id" field is of the dropdown type and contains all the ids (values) with the respective titles (texts) present in the "col_id" and "col_title" columns of the "test_tbl" table.
I guess the result can be achieved through the "Read data" action but I don't know how. Can anyone help me by explaining how to set up Chronoforms?

Thanks in advance,
Max_admin posted Nov 21, 2023 at 01:21
you can do this now by having a first page where the form_id is selected and then a 2nd page where the rest of fields are displayed and the data is read on first page submit

but if you want the data loaded on "form_id" selection (single page form) then this requires AJAX call and after that the data should be set in the fields, and this can not be handled by v8 now but it's on the todo list
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
You need to login to be able to post a reply. Inc. (Ohio, USA) is an authorized retailer for goods and services provided by