user22862

Help with setting fields from multiple records

Discussion created by user22862 on Jun 18, 2014
Latest reply on Jun 18, 2014 by user22862

WHAT I HAVE:

 

• 4 different PDF's that share some but not all the same field names.

 

• When importing a PDF using PDF manipulator, it saves a record for each field found on the PDF itself. Each record contains the field name, and its value.

 

• I have another table that I'm using called "FORMS", which contains all the possible fields on the 4 PDF forms.

 

 

NEED:

 

• After importing the PDF I want to populate the matching field names in "FORMS" with the values from teh PDF fields. ( there is much more complexity to the actual record creation and error trapping for duplicate past PDF imports, but that isn't what is tripping me up. )

 

 

PAST ATTEMPTS:

 

• I've done this succesfully setting a bunch of variables, and then set fields, with those variables. ( This works, but becomes much more time consuming and almost impractical for additional forms. )

 

 

THOUGHTS:

 

• I was next going to try the CF from Rob Poelking ( found on Brian Dunning ) that allows the creation of dynamic variables, however I can't help but think there is a better way!?

Outcomes