Separate/filter forms based on unique value

Avatar

Avatar

meem23

Avatar

meem23

meem23

14-01-2020

I have form created in Adobe LiveCycle Designer and has imported xml from an Access table.  The xml populates 4 fields and the form repeats for every data item. There are 780 output forms. One of the fields is called “owner”.  Out of the 780 forms there are 58 unique owners.  Is there a way to separate/filter the forms based on the unique owner?  So if owner “A” has 50 forms, I want the form to repeat only 50 times. I don’t want to create 58 separate tables in Access if I don’t have to.

View Entire Topic

Avatar

Avatar

meem23

Avatar

meem23

meem23

16-01-2020

Good question.  I’m not well-versed on this subject or scripting, so I don’t know what is possible. Currently I’m using Adobe Acrobat and importing the XML to create the 780 forms.  There is no data connection.  I’m not opposed to having a data connection.  I tried this approach and was not successful.

 

Is this possible:

 

  1. Dropdown that list the owners (A, B, C, etc. – not multiple times: A, A, A, A…..B, B, B….)
  2. Using Adobe Acrobat, import the data – 780 forms are created
  3. Select owner “A” from dropdown
  4. Filtered from 780 to 50
  5. Save As Owner A Forms.pdf
  6. Select owner “B” from dropdown
  7. Filtered 25 forms
  8. Save As Owner B Forms.pdf
  9. Select owner "C"....

Dropdown will need to be hidden after Save As.  The forms will be emailed to the owner and there are questions for them to answer and return back to me.