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,
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