Searchable drop down menu? | Community
Skip to main content
November 5, 2009
Solved

Searchable drop down menu?

  • November 5, 2009
  • 66 replies
  • 37509 views

I have several drop down lists in a PDF I am creating. These drop down lists contain diagnoses to be used by physicians. With there being a LOT of diagnoses, it would be extremely convenient if I had a "search" function of some kind that could be utilized as the wording of the descriptions for the codes/diagnoses can vary: (Ex. "Rib Pain" or "Pain in Rib")

As of now, the only option is to select the first letter of the name they believe the diagnosis to have. Using this example, they would select the drop down menu and press "R" and the list would jump down to the beginning of the R's. But, if the name is actually "Pain in Rib", they would have to search through all the other diagnosis codes to locate it.

I believe a search function would be the most appropriate for something like this. But, I am having some trouble locating any info on coding for something of this nature. If there are any suggestions that could make this, (or something that accomplishes the same task), possible, I am all ears.

Thanks!

I included a pdf with the fragment with the drop down menus as well as a list of the diagnoses I have in them.

I appreciate any help or ideas. I've never been let down by the people here in these forums.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by tarekahf

I was able to use the Net.HTTP and SOAP object to access the same DMTI service, but it worked only on the console window:

var jData;

var prm =

{cVerb:"GET",

aHeaders: [{name: "Authorization", value:"authentication-token"}],

cURL: "https://app2.dmtispatialxxx.com/servicesxxx/rest/suggest?limit=60&includePostalCode=true&address=20%20crown%20ste",

oHandler: {

   response: function (msg, uri, e) {

    console.println("\nThis is the response method:");

    console.println("msg=" + msg);

    //for (var p in msg) {

    //  console.println("p=" + p);

    //  console.println("msg[p]=" + msg[p]);

    //}

    var data = SOAP.stringFromStream(msg);

    jData = JSON.parse(data);

    console.println("Length of json data: " + jData.length);

    console.println("data=" + data);

    console.println("e=" + e);

   }

}

};

Net.HTTP.request(prm);

Response from the console window:

This is the response method:

msg=[object Stream]

Length of json data: 5

data=[{"matchCount":1,"suggestion":"20 CROWN STEEL DR MARKHAM ON L3R9X9","aliasSuggest":null},{"matchCount":1,"suggestion":"20 CROWN ST QUINTE WEST ON K8V1N6","aliasSuggest":null},{"matchCount":1,"suggestion":"20 CROWN ST ST. CATHARINES ON L2M3L3","aliasSuggest":null},{"matchCount":1,"suggestion":"20 CROWN ST THUNDER BAY ON P7B3J6","aliasSuggest":null},{"matchCount":1,"suggestion":"20 RUE CROWN DANVILLE QC J0A1A0","aliasSuggest":null}]

e=undefined

Unfortunately, the above method didn't work from a the click event of a button (in Adobe LiveCycle form). I got this error:

NotAllowedError: Security settings prevent access to this property or method.

Net.HTTP.request:19:XFA:form1[0]:subform[2]:Button4[0]:click

It looks like the only option now is to develop a wrapper component that can be invoked using the simple URL and to include the authentication token in the query parameters. Also, there is another problem... I have to get authentication code every time it is expired. Currently, there is Java code responsible for this part.

Question:

Why not develop a simple javascript program that can be invoked using HTML or jsp code, and return the result by clearing the output and just dump the result from the xhr response object? While I can develop the server component, but it seems a lot more easier to develop such component using only HTML and javascript. But, I am not  sure if it can be done, I just think it is possible.

66 replies

_Bruce_Robertson
November 22, 2010

Hi Bibhu,

It sounds like you want one of Adobe's Server side products, maybe LiveCycle Forms, something to take the form template and some xml and render a PDF form. I don't know much about server side processing as I have never worked with any LiveCycle product except Designer. I think the server products do support XSLT so you could convert the csv file to the xml format needed by your form.

Sorry can't really help

Bruce

Bibhu_Bikash_Na
December 17, 2010

Hello Bruce,

Your example works fine. But there is a problem. It's not taking the space. For example :

There are 3 choices in the dropdown.

Say : abc

         ABC

         Abc 123

When I type 'a' then it lists all the choices without any problem. The moment I type 'abc' and hit the space bar all choices vanishes. Could you please tell how to include this functionality ? So that when the user hits the space bar after typing few characters those corresponding choices which has a space inbetween must be displayed?

Thanks.

Bibhu.

_Bruce_Robertson
December 18, 2010

Hi Bibhu,

I'm not sure I understand, there are a number of countries with spaces in their names New Zealand and New Caledonia for example.  They seem to work as I would expect and as I think you are discribing.

Bruce

Bibhu_Bikash_Na
December 21, 2010

Hello Bruce,

What I was trying to say is : If you type New then both the countries New Zealand and New Caledonia are displayed. The moment you hit the space bar after typing the New then the dropdown suggest box goes blank. I want if you type some letter and after that we hit the space bar all those names containing that letter should be displayed , like that of a FaceBook/ Google search.

Thanks.

Bibhu.

_Bruce_Robertson
December 21, 2010

Hi Bibhu,

I am not seeing this behavior, if I type the space after "New" then the two countries stay in the list. I have tested this code in versions of Reader 7.0.9 to X so I'm not sure what to suggest. What version are you using.

Bruce

Bibhu_Bikash_Na
December 21, 2010

Hello Bruce,

I am using LiveCycle ES 8.2.x and Acrobat 9 Pro and Acrobat reader.

Thanks.

Bibhu.

Bibhu_Bikash_Na
December 22, 2010

Hello Bruce,

There is a problem. The search results are only shown by the starting letter.

For Example : There are 3 Dropdowns.

                       Chistmas

                       Happy Christmas.

                       Happy Chrismas to you all.

If I type Christmas then it should show all the 3 entries. But it's showing only the starting Christmas. (This is only for the example purpose, the same situation is applicable to the Countries as well.)

Thanks.

Bibhu.

_Bruce_Robertson
December 24, 2010

Hi Bibhu,

You could change the sample to work in this way by replacing the line populating the list in the Search text fields change event from

list = xfa.resolveNodes('$record.country.[Lower(Left(name,' + (xfa.event.newText.length) + ')) == "' + xfa.event.newText.toLowerCase() + '"]');

to

list = xfa.resolveNodes('$record.country.[At(Lower(name),Lower("'+xfa.event.newText+'")) > 0]');

Bruce

Bibhu_Bikash_Na
December 24, 2010

Hello Bruce,

It worked fine. But I have one problem again. After selecting a country from the dropdown when I submitted it through XML instead of getting only the country I have selected I get all those values that we are embeding in the form. Is there a way that we will get only the selected value as XML so that we can update our DB ? Otherwise it's not possible to update the DB after some selections has been made.

Thanks.

Bibhu.

Bibhu_Bikash_Na
December 24, 2010

Hello Bruce,

I tried to use another XML data other data country data. But The list box is showing empty.Could you please tell why ? And do you mind explaining the following codes that you have written ?

list = xfa.resolveNodes('$record.country.[At(Lower(name),Lower("'+xfa.event. newText+'")) > 0]');
    for (var i = 0; i < list.length; i++)
    {
        var country = list.item(i);
        Results.CountryList.addItem(country.name.value, country.index.toString());
    }

Here what does the variable "country" stand for ? Is it for the record source or just a variable, what are its functionalities?

What's meant by country.name.value ? You have a field name, that's why it's name or something else?

Thanks.

Bibhu.