Filling in fields from choice in a drop down list

Question

Hey guys,I'm very new to making PDFs and way new on programming. What I am looking to do is make a choice in a drop down list, and have it fill in fields based on what was chosen in that list. I am working on a form to fill out work orders, and we have 130 different locations. I have all of the store numbers (which I plan on putting in the drop down list) and the corresponding addresses in an excel file. I would like to choose the store number and have it fill in the street address in one field, the city in another. Those are both separate fields in the excel file, btw. I can put the data in another format, if it is at all possible to make this work. Any advice? &#128515;

try67 · Answer

This requires developing a custom-made script, which is not a simple task.

If you're interested, though, I've already created a tool that allows you to easily set it up using a tab-delimited text file as the data source. The tool will automatically apply the code required to populate the fields based on the selection in the drop-down, and you can easily maintain the list by just dropping a new file as an attachment to the PDF instead of the old one, or even by editing it directly.

You can find it here: Custom-made Adobe Scripts: Acrobat -- Populate Fields From Dropdown

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded