2 Replies Latest reply: Jul 25, 2014 8:35 PM by NiobeDMX RSS

    LOOKUP function?

    NiobeDMX Community Member

      I work for a college and I want to create a fillable form that also uses drop down selection boxes.  The drop down boxes would automatically populate choices based on previous responses.  Normally, I would do this in Excel with the LOOKUP feature.  Does Acrobat have something similar?  Basically, I have a form that the student will select their major title, then based upon which major they select, I want lists of courses they need to complete to show up, in specific locations. Then the student selects the courses they have completed and will select the amount of units the course was worth.  The units will self tally at the bottom of the form.  Can this be done in acrobat without having to link to excel files?

        • 1. Re: LOOKUP function?
          George_Johnson CommunityMVP

          It sure can, but you'll have to implement it in JavaScript. I just finished up a project that does much the same, so post again if you need more help, and include bit more detail.

          • 2. Re: LOOKUP function?
            NiobeDMX Community Member

            Thanks for your quick response George, as soon as I get the initial form made, I will post it here so you can give a more in-depth response,  Also, is there a simple script that I can use that is similar to an Excel "if" "then" statement?  For example, I want to have 2 check boxes and if check box #1 is checked, when the user clicks the "submit" button, the form is emailed to one address but if they check box#2, it would go to a different email address when they click "submit."