1 answer
- 10-1
Hi
The ideal method is to save the form grid records into its own database table (child table) by setting the Load & Store Binders to "Multirow Form Binder".
When designing your form grid, in the tab "Edit Form Grid > UI > Validation & Data Binder", select "Multirow Form Binder" in the Load & Store Binder select box. Next define the sub form id and foreign key (a hidden field for Joget Workflow to store the parent id in your subform) in the next two tabs "Configure Multirow Form Binder".
You can see an example of the above in the sample Expense Claim app in your Joget Workflow Enterprise v5 installation or download the demonstration HR Expense app from Joget Marketplace.
To display the parent & child records in your datalist, you can use JDBC datalist database binder to perform a MySQL GROUP_CONCAT() function.
Add your comment...
Hello. I am creating a form and before submitting this form I create a subform and put it into my new form via "Edit Form Grid". I create a "datalist" for the form that I created later and select it in the field that I created with this "Edit Form Grid". there is more than one data in this field, and so it writes a lot of data that looks complicated in the "dataList" field. eg [{"":"","id":"874b3487-3132372e-36169830-95220c40","Faaliyet_Adi":"eğitim planlama"}]
I just want you to write the name of this one. but I could not do it anyway. can you help me?