Populate or copy information from a source into table rows

[islandgirl23]

Hello,

Is there a way to copy information from a (database) source and paste it into the columns of a table.  I have a table that needs information in it that a user can copy and paste from another source into the rows.  The database is by line items.  Example:  item 1 - Bi-fold door.  Item 2 - Single door.  Item 1 will be copied and pasted into the first row of the table.  Item 2 will be copied and pasted into row 2 of the table, etc.  The issue is that they have to copy and paste each line item from the source to the rows.  This is time consuming if you have a lot of line items.  Is there a way to copy all line items from the database so that they populate in their prospective row of the table?

[Mayank_Tiwari · Accepted solution]

Yes, you can use Form data model to achieve this. You need to create RDBMS FDM and configure the same in your Adaptive Form container as the Prefill service. Then, you may map the row value to the FDM data.

For more information, please refer to: https://experienceleague.adobe.com/docs/experience-manager-learn/forms/prefill-fdm-db/introduction.h...