I have two columns of data that I need a drop down box to reference. I cannot for the life of me figure this out even after reading through multiple tutorials. Adobe Pro XI and Adobe Forms Central.
I don't want to have to manually enter each field because there are too many to hand-key and too many possibilities for mistakes.
You need to provide more details. Are you asking about populating a dropdown field with items that you have in an Excel spreadsheet? If so, have you seen this: http://forums.adobe.com/thread/1025337?tstart=0
I'm not sure what kind of additional details you need, but I'll throw some information at you anyway. I have a Microsoft Excel spreadsheet (2 columns) that I need to use with a PDF. This PDF that I am creating will have a drop-down box that I want to display the data from the Excel spreadsheet. The users must make a selection from the drop-down box.
In my head, this sounds incredibly simple. However, this has proven to be an incredible headache. I have Adobe Forms Central and Adobe Acrobat XI Pro.
Thanks in advance.
First of all, you mentioned FormsCentral. Is the form you're creating intended to work with the FormsCentral service?
You say you have two columns in the spreadsheet. Do you want one dropdown to have items from the first column and another dropdown to have items from the second, or something else?
I directed you to another thread here that shows one method for populating a drop down with items that you copy from a spreadsheet. Have you tried it, and of so, in what way does it not do what you want?
Here's my overall end goal/project:
I need to create a very basic PDF file. It will include three drop-down boxes for the following: 1. Project # and Project Name; 2. Month; 3. Year. Fields 2 and 3 (month and year) can be entered manually. Field 1 (project # and name) need to be pulled from an Excel spreadsheet (2 columns). The users will need the ability to select only the items in the drop-down boxes and must have the capabilities to save the PDF.
Today is my first day using Adobe XI Pro and Forms Central so I'm not sure where is even the best place to start this project.
The two columns in the spreadsheet (project # and name) should be displayed as: 12345 Scranton
I'd like to have the ability for the end-users to start typing project numbers and have that information populate, but that can wait for another day...
I read the threat/link provided but it only takes me to another website where I can purchase Acrobat from - or is there another link that I'm missing?
OK, forget about FormsCentral for the moment. The link changed because Adobe made a change to the Acrobat.com service, so here's the updated link: https://workspaces.acrobat.com/?d=sIJoabh12oYOY19AuTZ9yw
This file allows you to copy the Excel data, paste it into a text field on the form, and populate the dropdown at the top with the items you copied. In your ase, I would copy from Excel to a text editor first, and then copy from there to the text field on the form. Once the dropdown is populated with the items, copy the field from the form to your form, resize, and change any other properties to it looks like you want.
Post again if you get stuck.
I'm stuck again... I downloaded the PDF, copy and pasted the data from Notepad to the downloaded PDF. What exactly am I copying and pasting to my new PDF? If I highlight and copy the drop-down box (which includes my data) it only copy and pastes Line 1.
If the dropdown is populated with the items that you want, you just need to copy the entire field from the form and paste it into your form. To do this, you can go into form editing mode (Tools > Forms > Edit), use the select tool (black arrow) to select and copy the dropdown, and then paste it into your form.
Just to the first item that starts with the character entered. Subsequent presses of that same letter will cycle through the other items starting with that letter. Dropdowns are limited to this behavior.
I dont know if this the correct way to ask a question or not Ive never used this forum before. I couldnt find any other way to ask you directly a question about this subject you answered in the past. So i just hit reply to ask you about it. I hope thats OK. I found your info about this issue very helpful I have the same probIem. I downloaded the file to populate the menu. I populated it and then copied it to the form I am building. The only thing is it wont populate all of the entries I copied it just stops at a certain point. I did what you suggested about copying the data to notepad first then the to the menu. It works just not all of the data. Are there any limitations to the amount of data or settings that need to be changed or something? I would appreciate any help on this.