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

autofill

Forum Index > JavaScript > autofill
2007-11-26 11:21:26
dbertanjoli
Registered: Nov 18 2007
Posts: 30

I have 3 combo boxes on my form. First box contains categories of diseases, second box names of the disease and third box code of the diseases. What we would like to do is if someone select the code the category and the name are field automatically or if someone select the name the code and category are field in automatically? Can this be done?

Many thanks,
Debbie

p.s. I am new at programming

Top
2007-11-26 11:44:45
#1
gkaiseril
Online
Expert
Registered: Feb 23 2006
Posts: 4307
Yes, but the DRG is a large item to keep up to date. Will you be getting this detail from a database or an internal table?

This is not the project for a novice programmer, you will be querying a database or a multidimensional array.

George Kaiser

Top
2007-11-26 13:08:07
#2
dbertanjoli
Registered: Nov 18 2007
Posts: 30
Hello,
Thank you for your reply.

Unfortunately there is no database, just excel spreadsheet. We will have 2 combo boxes and one text field. In first combo box there will be categories of diseases, second box sub categories (depending on selection in first box) and third one should show the code of subcategory (third one is not necessary). So basically it is cascading menu.

For example. First drop down menu will have the following categories:
Disease1
Disease 2
Disease 3


Second drop down menu will have
(If selection is disease1)
Cancer1
Cancer2
Cancer3
(If selections disease2)
Diabetes1
Diabetes2
Diabetes2

Third text box, once subcategory is selected, should show the code related to that subcategory.

I would greatly appreciate your help.

Debbie
Top
2007-11-27 10:08:15
#3
gkaiseril
Online
Expert
Registered: Feb 23 2006
Posts: 4307
Well, you can create a named area within an Excel file and use the Excel database functions of vlookup or hlookup and create an ODBC connection, Open Data Base Connection, that can be used to process SQL database statements. Once you have created an ODBC you can use ADBC (Adobe Data Base Connection) object in Acrobat forms or a data connection in LiveCycle Designer.

You can also import data from a tab delimited text file. You can create this file with a Save As through Excel.

More information is contained in the scripting documentation provided by Adobe for Acrobat or LiveCycle Designer.

George Kaiser

Top