We are currently working on a requirement, where I need you guys help.
We have a form created with Form Model selected as FDM and connected to MySQL DB. It has one Repeatable Section / Panel and we used an Instance Manager as the option for doing the same, which has 2 buttons (Add and Remove). We used a Fragment for creating that panel and properly binded to DB fields.
When we try to insert data into DB using FDM service, expected scenario is if a user adds one more entry of same section with different details, then in the DB, I should see 2 records inserted (we have a logic at our end which is based on Unique Identifier at table level). But currently I see only 1 record getting inserted every time. I was assuming that section with proper binding is the one which is repeated, then same binding should be applied there too, but I doubt whether it was happening or not.
Can someone please help in understanding of following questions on
1. How this repeatable sections work especially while binding and doing DB operations? I explored the follow documents, but unfortunately couldn't able to get much info. Repeatable Section,
2. What is the best approach for creating repeatable sections out of available one's like Accordion, Instance Manager, XDP Subform and XSD?
Quick help is appreciated!
Solved! Go to Solution.
Thanks for the response! Yes looks like FDM Service is going to insert only 1 record at a time. That's fine we can invoke that service for each and every section separately.
But what about prefilling data for the sections while using retrieving / get service? When user saves the form and sometime later comes back to complete submission, I should pre-populate data saved in DB for all sections filled by user earlier. Please help
Okay we're able to prefill the data for Repeatable sections, it's just that I need to return the data as an array in FDM service for form to understand and fill the data for all sections.
Thanks all for your responses!
@Mayank_Gandhi , could you please provide some more details on what exactly you mean by term "row". Is it entire repeatable section? Also what does element in the data source mean?
An example of this would help understand better.