Welcome Dialog

Welcome to the Community!

We have a brand new look! Take a tour with us and explore the latest updates on Adobe Support Community.


Importing or copying Excel list into drop down list

Community Beginner ,
Jun 18, 2012 Jun 18, 2012

Copy link to clipboard

Copied

Can anyone help me with this??  I have a list of 115 departments that I would like to populate the drop down box in an acrobat pdf form and dont have the time to enter them one by one..  Is it possible to either import this list or do a copy and paste??  Please help..  Thanks so much!!

TOPICS
Create PDFs, Windows

Views

52.8K

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

correct answers 1 Correct answer

Adobe Community Professional , Jun 18, 2012 Jun 18, 2012
Here's a link to a very simple PDF that demonstrates how you can populate a combo box (aka drop down) with a list of items that can be pasted into a text field, after copying them from Excel (or some other source): https://acrobat.com/#d=sIJoabh12oYOY19AuTZ9ywThe idea is that once the drop-down is populated after clicking the "Populate combo box" button, you can copy & paste the field to your form. Be sure to check for duplicates and blank lines.

Likes

Translate

Translate
New Here ,
Feb 01, 2018 Feb 01, 2018

Copy link to clipboard

Copied

Um, okay.

I'm not savvy enough to try and use JavaScript in Acrobat, I've added a Dropdown list (via Prepare Form) in Pro DC. When that Dropdown list is selected on the form, in Dropdown properties --> Options, there is an Item field to add data to create the dropdown list. I don't want to add them manually, as there are several, I want to batch add.

Perhaps this is not possible without scripting, but, from what I've read here in the forums, George's form appears to be what I need (I think). I thought by adding text to his script, I could copy that into my form.

But in Dropdown properties --> Options, there is no where for me to paste that much text. It appears that you can only add one item at a time to populate the list. I'm not sure what I'm missing...

Again, I don't want to do this via Java (if that's possible). I'd rather do it GUI-style...

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 ,
Feb 01, 2018 Feb 01, 2018

Copy link to clipboard

Copied

I'd rather do it GUI-style...

If that was possible we wouldn't use a script, but it's not.

Feel free to make a feature request here: Feature Request/Bug Report 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 ,
Feb 01, 2018 Feb 01, 2018

Copy link to clipboard

Copied

I think I made this too complicated.

If you have access to the form George made, then use it to create your filled list. As I already stated, the purpose of this form is to give you a copy paste method for filling a dropdown with entries. No scripting needed on your end.

If you don't have the form, then I'll create one and upload it to the free content at  http://www.pdfscripting.com

Thom Parker - Software Developer at PDFScripting
Use the Acrobat JavaScript Reference early and often

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 ,
Feb 02, 2018 Feb 02, 2018

Copy link to clipboard

Copied

Hi, Thom,

Glad to hear that no scripting is needed. So we're back to my original question: where does this data get pasted? There is no "Populate Combo Box" anywhere in the Dropdown Properties of Pro DC. I'm in the Options tab of the Dropdown Properties, but even pasting the copied text from George's form in the Item field of that tab does not allow for more than one item at a time. Is there a different tab I should be using, a different field? 

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 ,
Feb 02, 2018 Feb 02, 2018

Copy link to clipboard

Copied

I think this was stated previously so I didn't address it. There is no place to paste a list of entries into the properties dialog of a dropdown. That's the reason George created the form. It should have a text box on it somewhere, and that is where you paste your list of entries.

Regardless, Download the form here. It is the first sample download in the list and it contains clearly marked fields and instructions for this same process.

Free Sample PDF Files with scripts

Thom Parker - Software Developer at PDFScripting
Use the Acrobat JavaScript Reference early and often

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 ,
Feb 06, 2018 Feb 06, 2018

Copy link to clipboard

Copied

Hi, Thom,

Thank you for providing the link, the instructions were most helpful.

Cheers,

Elizabeth

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
Community Beginner ,
Dec 06, 2018 Dec 06, 2018

Copy link to clipboard

Copied

Hi Thom,

You are such a help, I tried dropdown thing and it worked. Thanks a lot!

I have a question if you can solve it will be great. I want to GET THE SELECTED ITEM OF A DROPDOWN and COPY TO ANOTHER TEXTBOX. How can I do that? Can you please help.

Thanks in advance.

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 ,
Dec 06, 2018 Dec 06, 2018

Copy link to clipboard

Copied

Here are two articles that cover exactly this topic and more:

https://acrobatusers.com/tutorials/list_and_combo_in_lc

https://www.pdfscripting.com/public/List-Field-Usage-and-Handling.cfm

Thom Parker - Software Developer at PDFScripting
Use the Acrobat JavaScript Reference early and often

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 ,
May 10, 2021 May 10, 2021

Copy link to clipboard

Copied

Hello: I cannot download the form, could you create a free one?

 

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 ,
May 17, 2021 May 17, 2021

Copy link to clipboard

Copied

The link to the form in the  AcrobatUsers.com article is still good. Here it is:

https://www.windjack.com/PDFSamples/ListPrograming_Part2_AcroForm.pdf

 

  

Thom Parker - Software Developer at PDFScripting
Use the Acrobat JavaScript Reference early and often

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
    • 1
    • 2