Dropdown List, Autopopulate text fields

New Here ,
Apr 26, 2022 Apr 26, 2022

Copy link to clipboard

Copied

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

 

TOPICS
How to , JavaScript , PDF forms

Views

70

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Apr 26, 2022 Apr 26, 2022

Copy link to clipboard

Copied

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Apr 26, 2022 Apr 26, 2022

Copy link to clipboard

Copied

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).

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Apr 26, 2022 Apr 26, 2022

Copy link to clipboard

Copied

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..

 

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Apr 26, 2022 Apr 26, 2022

Copy link to clipboard

Copied

LATEST

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

 

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines