Bathuu A
Level 1 (0 points)

Q: how can i connect 2 drop down menus? on numbers

hi i need to connect 2 popup menu, for example my first popup menu would be fruit, meat then if i choose fruit next popup menu will populate banana and apple then if i choose meat next popup menu will populate beef and mutton.

iMac, OS X Mavericks (10.9.1)

Posted on Jan 6, 2014 8:14 PM

Close
Bathuu A

Q: how can i connect 2 drop down menus? on numbers

  • All replies
  • Helpful answers

  • by Yellowbox,

    Yellowbox Yellowbox Jan 6, 2014 10:01 PM in response to Bathuu A
    Level 6 (10,535 points)
    Mac OS X
    Jan 6, 2014 10:01 PM in response to Bathuu A

    Hi Bathuu,

     

    I think that is called a hierarchical menu, but I don't think that Pop-Up Menus in Numbers support that.

     

    One way could be to have all you food items in one column. Type them, select them all, then Format Panel > Cell > Data Format > Pop-Up Menu:

     

    Screen Shot 2014-01-07 at 4.50.05 pm.png

     

    Start with Blank (it will show None) is handy if you want to cancel an entry. In the Format Panel you can drag menu items to reorder them, or double click to rename.

     

    Screen Shot 2014-01-07 at 4.53.36 pm.png

     

    Another way (if you want to distiguish different food groups) is to have another column with Pop-Ups for Fruit and Meat:

     

    Screen Shot 2014-01-07 at 4.59.20 pm.png

     

    Then you can sort the table by Food group or Food.

     

    Regards,

    Ian.

  • by Bathuu A,

    Bathuu A Bathuu A Jan 6, 2014 11:11 PM in response to Yellowbox
    Level 1 (0 points)
    Jan 6, 2014 11:11 PM in response to Yellowbox

    Hi, Ian.

    actually that's usefull

    but if we have 100 categories, 100 sort and 100 detail informations then that dropdown menu cannot help at all.

     

    Thanks,
    Bathuu.

  • by Badunit,

    Badunit Badunit Jan 7, 2014 4:51 AM in response to Bathuu A
    Level 6 (11,705 points)
    iTunes
    Jan 7, 2014 4:51 AM in response to Bathuu A

    There is no good way to do hierarchical menus in Numbers. With a small list of words you can use a stepper or slider cell next to a cell that gets a word from a list based on what number is in the stepper/slider cell. In ohter words, if the stepper has a "2", the formula will get the second word from your list. The user cannot see a list of words to choose from but can step through the words until they get to the one they want.  There have been posts on this over the past few years. It applied/applies to Numbers '09 also.

     

    100 categories x 100 sub categories (sort) x 100 sub-sub categories (detail information) = 1 million cells of data to create the pop ups. Is this what you really have?

  • by maartenjandubai,

    maartenjandubai maartenjandubai Dec 11, 2015 10:59 PM in response to Badunit
    Level 1 (0 points)
    Dec 11, 2015 10:59 PM in response to Badunit

    Badunit,

     

    have a look at this thread. It may help.

     

    MJ

  • by Barry,

    Barry Barry Dec 12, 2015 1:47 AM in response to maartenjandubai
    Level 7 (32,697 points)
    iWork
    Dec 12, 2015 1:47 AM in response to maartenjandubai

    "have a look at this thread. It may help.

     

    MJ"

     

     

    Hi MJ,

     

    Methinks you've forgotten to include a link to "this thread." Oops!

     

    Regards,

    Barry

  • by Yellowbox,

    Yellowbox Yellowbox Dec 12, 2015 2:38 AM in response to maartenjandubai
    Level 6 (10,535 points)
    Mac OS X
    Dec 12, 2015 2:38 AM in response to maartenjandubai

    Hi MJ,

     

    Or this User Tip?

    Nested (or Cascading) Pop-Up Menus in Numbers 3

     

    Regards,

    Ian.