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