3 Replies Latest reply on Sep 4, 2010 5:44 PM by LaRetta_1

    default for drop-down menu

    AdamReed

      Title

      default for drop-down menu

      Post

      I have a drop-down menu, and would like it to default to the first entry in the value list.  I've tried indicating that in the field definition (auto-enter/data), but it seems to have no effect.  Any suggestions?

        • 1. Re: default for drop-down menu
          LaRetta_1

          Let's assume your value list is called "Type".  You would add an auto-enter by calculation to the dro-down menu field with something like:

          GetValue (  ValueListItems ( Get ( FileName ) ; "Type" ) ; 1 )

          Make sure that the spelling of your value list within those quotes is exact or it won't produce any results.  And it won't help for existing records, only newly created ones.  To prefill existing records,  show all records and then use this calculation in Replace Field Contents.  Back up first.

          • 2. Re: default for drop-down menu
            AdamReed

            Thank you, that helped -- it ended up working slightly differently for my example: 

            GetValue ( "Dollars¶Euro¶Pounds" ; 1 )

            ...but it works.  Thanks again!

            • 3. Re: default for drop-down menu
              LaRetta_1

              Well, if you know the exact value it should be (because it isn't based upon only existing field data), then you can have it auto-enter DATA (right about calculated value options) and just type Dollars. :^)