These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

So confused with this...Any experts out there?

Sunwest
Registered: Dec 4 2009
Posts: 5

Help!!!

Well, I am new to developing forms but somewhat computer savvy. I need to design a form that would allow the user to select his or her name from a drop down box. Once they have chosen their name, their employee number and brach number would populate. Does anyone have any thoughts on how to do this? I have all of this information contained in an excel spreadsheet but have had NO luck connecting it to the form.

I can not imagine that this would be that hard but I fear I am missing something ubber basic!

Thank you,

Christopher

Dimitri
Expert
Registered: Nov 1 2005
Posts: 1389
Hi Sunwest,

Sure, you can do this in your PDF form. There is a tutorial on populating fields based on a drop-down selection in the Learning Center here that is almost exactly what you are asking for, plus lots of other tutorials you may find helpful as you learn about possibilities in Acrobat forms. Whether or not is is ubber basic is totally subjective....

http://www.acrobatusers.com/tutorials/2006/change_another_field
Make sure to download the sample file included with the tutorial so you can examine the code used.

Hope this helps,

Dimitri
WindJack Solutions
www.pdfscripting.com
www.windjack.com
Sunwest
Registered: Dec 4 2009
Posts: 5
Thanks for your quick Reply Dimitri.

I have looked at this example this morning but am a little scared about coding this form as I have very little coding experience. Is there a way to automate this process at all or make it a little easier for me?

Sunwest
Dimitri
Expert
Registered: Nov 1 2005
Posts: 1389
Hi Sunwest,

Yeah, I see the fear comments about scripting all the time. Unfortunately, almost all the most useful and powerful features for forms require some scripting skills- not only in Acrobat but in many other software applications too. But it is just a new skill to aquire, not that bad. I've seen lots of people completely new to fillable forms in Acrobat and LiveCycle Designer and JavaScript do all the things they need for their forms in a short period of time. It's a matter of spending the time to learn though, as with any new skill. There are lots of good resources here at AUC to help get you going, and if you are interested in a course you should consider a membership at my company's site www.pdfscripting.com- a full Acrobat JavaScript video series is available there plus a Library of downloadable files with a wide variety of script examples including many on list handling.

And of course, these forums are great for asking specific point questions on scripts you are having problems with.

Hope this helps,

Dimitri
WindJack Solutions
www.pdfscripting.com
www.windjack.com
pforms
Registered: Nov 17 2009
Posts: 87
Example:

a dropdownlist with the employees' names

2 Textfields

This JS on the Change event of the dropdownlist:

if (xfa.event.newText=="employeename")
{TextField1.rawValue="Branch"
TextField2.rawValue="employeeNumber"}


I'll send you a sample if you like. This is a real confidence builder with the software and the function is pretty slick for the users