Skip navigation
Joel.Holt
Currently Being Moderated

Complicated dropdown, effecting several textboxes

Sep 7, 2012 10:48 PM

Hello everyone. I have searched high and low for something talking about exactly how to do what I want - but I'm not finding anything thats quite right. Simply put, I want a drop down (with potentially hundreds of choices - I would love to limit the number but there really is no way...) where someone can pick  their selection, then, based on that choice, several other text fields get filled in with the corresponding info. I would like to have a database file with the drop down choices, then somehow define what field and then what information goes in the next text box. that way you can pick something in the drop down and the other boxes get filled in correctly. Is this possible?

 
Replies
  • Currently Being Moderated
    Sep 8, 2012 9:11 PM   in reply to Joel.Holt

    Hi Joel,

     

    If you are trying to populate a dropdown field dynamically from a data base then this post might help, http://blogs.adobe.com/formfeed/2009/10/populate_a_listbox_from_a_web. html.

     

    If you are taking the data from the database and adding it to the form at design time then this sample shows two ways of doing that, https://acrobat.com/#d=BgXrrCR3IkelMhRn*6DYMw

     

    Regards

     

    Bruce

     
    |
    Mark as:
  • Currently Being Moderated
    Sep 9, 2012 3:56 AM   in reply to Joel.Holt

    Hi Joel,  I reckon, if the information doesn't change much then your best bet is to keep the form as self contained as possible, that is have the information contained within the form.  There are a number of connectivity problems your users could experience with an external data source.  I would not expect performance to be an issue, I have developed forms with thousands of selections in a drop down, you may find the sample I made of a searchable dropdown list helpful in the Adobe cookbook section, http://cookbooks.adobe.com/post_Drop_Down_List_Control_with_auto_compl ete__Searcha-18402.html, if your data contains a hierarchy then there are a number of examples around of dependent drop down lists to try, such as this one http://thelivecycle.blogspot.com.au/2011/01/multi-level-dropdown-list. html. I'm glad you found my comments helpful, Regards. Bruce

     
    |
    Mark as:
  • Currently Being Moderated
    Sep 13, 2012 5:34 AM   in reply to Joel.Holt

    Hi Joel,

     

    Quite a wish list you have.  Feature 1 would probably require some central database or webservice, so the different forms can access the same data, though you could try the approach described at http://blogs.adobe.com/formfeed/2010/07/shared-data-in-packages-part-1 .html.

     

    I guess you are on top of feature 2 now.  You can't do any drawing in a PDF form, though this sample might help for simple stuff, which allows the user to draw an X on a map  https://acrobat.com/#d=2qgv56rOCT65AnXtLZXJmw.  Maybe you can look into a Flash object http://blogs.adobe.com/formfeed/2010/12/flash-in-xfa-sample-column-cha rt.html but I don't know much about that.

     

    Signing documents is a standard part of an PDF form, so you should be ok with feature 4.

     

    Feature 5, I think some of the older versions of Reader had trouble with text fields spanning multiple pages but there's no problem with the latest ones.

     

    A menu system can be implemented, here is a good example http://www.assuredynamics.com/index.php/portfolio/accessing-pdf-menu-i tems/.  You can also add buttons to the Reader toolbar as described here http://blogs.adobe.com/acdc/2010/06/acrobat_javascript_extensions.html.

     

    Feature 6, If your NCIC application has a webservice then you can access the information.

     

    Audio notes can be added to a 'normal' PDF using the commenting function, but this doesn't work with LiveCycle Designer forms, maybe it works with AcroForms, but I think you will have to add them as an attachment.

     

    Good luck

     

    Bruce

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points