Dropdown List, Autopopulate text fields

[DJ Kolick]

I am currently working on a new auto complete form based off of a selction made in a drop down list.  From the videos that I have watched I think I am about 90% of the way done, however I cannot figure out the last step.Dropdown list is filled with Names... John, Joe, etc... On an Excel sheet is corresponding information  to said names with other information. ex.. Name, certifications, phone number 1, phone 2, etc.  I have used excel formulas to gather the information together into one cell but still have it be able to be cut apart by java script to fill in the text fields in the pdf. 

   When it comes to the pdf itself, Dropdown list is made, export fields are made and on the calculate tab of the properties in the Custom Calculation Script, I have the following script. 

event.value=this.getField("Name").value.split("--")[0]

From what I understand now I have to copy the Name Cell and consolidated cell from the excel into the pdf somehere and it all should work... but I cannot find where to copy and past it to.... Please HELP!!!

DJ

[Bernd Alheit]

Read this:

https://community.adobe.com/t5/acrobat-sdk-discussions/populate-fields-based-on-drop-down-list-selec... 

[try67]

You need to copy it as the Export Value of each item in your drop-down, with each value being separated by a "--" (according to the code you shared).

[DJ Kolick]

Try67 that is the problem, the export value is to long for the allowed characters in the export field

DJKolick 'Military Relocations Specialist--727-228-1962--727-828-8631--DjKolick@bhhsflpg.com becomes the export value and is way to long for the little export value block.

Bernd Alhei I read that before I posted, the users of the final product will only be selecting their name and the rest should autopopulate, and I do not want the information of everyone else to show on the form..

[try67]

I have no problem applying a much longer export value than that. What version of Acrobat are you using?
Anyway, this solution is not ideal. It's better to have the data in a separate (text) file that's attached to the PDF and then read that file's contents with a script and populate the other fields based on it.

I've actually developed a (paid-for) tool that does just that, if you're interested:

https://www.try67.com/tool/acrobat-populate-fields-from-dropdown