I am trying to build a form within an existent document in acrobat. I have an excel document with about 41 rows of data. I would like it if selecting one item from a particular column in a dropdown in my PDF could autopopulate the items in the rest of this particular section based on the corresponding data in the row.
You would need to convert the data to a plain-text file in order to be able to read it using a script, or to hard-code into the script itself. Then create a custom-made script to use that data to populate the other fields when a selection is made in the drop-down.