Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

How to bind Adaptive Form Fields of a Repeatable Section to Database?

Ssb_94
Level 6
Level 6

Hello Folks,

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,

Similar question posted

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!

@Mayank_Gandhi @smacdonald2008 

 

Regards,

Sri Bhargav

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution
GirishBedekar
Correct answer by
Level 9
Level 9
7 Replies
GirishBedekar
Correct answer by
Level 9
Level 9
GirishBedekar
Level 9
Level 9

I am not sure if insert operation of FDM can insert more than one row at a time

Ssb_94
Level 6
Level 6

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

 

Regards,

Sri Bhargav

Ssb_94
Level 6
Level 6

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!

Regards,

Sri Bhargav

Kosta_Prokopiu1
Employee
Employee

Disregard - the comment landed in the wrong place...

Mayank_Gandhi
Community Advisor
Community Advisor

@Ssb_94  You need to make sure the row is bound to an element in data source which is a repeating element and that would work fine. I prefer using XSD or JSON schema.

Ssb_94
Level 6
Level 6

@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.