Connect dynamically created fields to ODBC database

[DKinsley]

Can anyone help me with a script to connect dynamically created table rows/fields to an ODBC database (MS Access)? For example a table with multiple fields for Customer Name, Phone Number, Address, etc.

I have several forms that I have connected static fields to MS Access but not dynamically created fields. I would use the FormID as the unique data point.

FormID	Customer Name	Phone Number	Address
1	Mr. Jones	315 999 9999	127 Adtkins Dr, Liverpool, NY
1	Mrs. Smith	215 888 4568	200 Block Ave, Hardrow, NJ

What I really need help with is a script to count the number of repeatable rows present and perform an action to each of those rows. To have the script count the number of instances of Row1 and then script that the rawValues of each field contained in the visible repeatable table1 Row1 equals the rawValues of the hidden repeatable table1 Row 1 that are bound to the database columns.

HiddenSubform.Table1._Row1.CustomerName.rawValue = VisibleSubform.Table1._Row1.CustomerName.rawValue;

HiddenSubform.Tabe1._Row1.PhoneNumber.rawValue = VisibleSubform.Table1._Row1.PhoneNumber.rawValue;

DatabaseName.update();

Any help is appreciated!

[PDFGuru]

Hi,

Look at the following blog, it might help you.

Adobe PDF Forms: Populate same xml data in multiple fields

You can drop an email to lcdesignerforms@gmail.com

[DKinsley]

I have a two tables with a header and one row, two columns.

Fields are named "Name" and "Address".

The row is repeatable with an "Add Row" button.

One table will be visible to the user the other hidden.

I am trying to get the data that the user enters into however many rows they create to populate the other table in the same way.

Here's my script from what you shared with me. What do I have wrong?

var rowNodes = Form1.Visible1.Table1.Row1.instanceManager.count;
for(var nNodeCount=0; nNodeCount<rowNodes;nNodeCount++)
{
Hide1.Table1.Row1.instanceManager.addInstance();
xfa.resolveNode("Form1.Hide1.Table1.Row1[" + nNodeCount +"].Name").rawValue = xfa.resolveNode("Form1.Visible1.Table1.Row1["+ nNodeCount + "].Name").rawValue;
xfa.resolveNode("Form1.Hide1.Table1.Row1[" + nNodeCount + "].Address").rawValue = xfa.resolveNode("Form1.Visible1.Table1.Row1[" + nNodeCount + "].Address").rawValue;
}

[PDFGuru]

I created a sample for you please check Dropbox - DuplicateTable.pdf

For more modification please send your query to lcdesignerforms@gmail.com