3 Replies Latest reply: Jan 7, 2014 4:51 AM by Badunit
Bathuu A Level 1 Level 1 (0 points)

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)
  • Yellowbox Level 5 Level 5 (7,360 points)

    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.

  • Bathuu A Level 1 Level 1 (0 points)

    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.

  • Badunit Level 6 Level 6 (11,400 points)

    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?