GWBush
Level 1 (0 points)

Q: Dynamic Pop-up Menus

Part 1: Is it possible to have a pop-up menu reference a group of cells on a different table? I want the pop-up menu to get populated with the values in the other cells. Let me give you an example:

 

A1 = Banana

A2 = Orange

A3 = Apple

 

I would like to have a pop-up menu (on a different sheet) read:

     Banana

     Orange

     Apple

 

Part 2: If Part 1 was possible, is it also possible to have the pop-up menu update itself automatically? Let's say I add A4 = Pineapple to my table. Could I get my pop-up menu to automatically have "Pineapple" as an option or must I manually type it in as a selection?

 

Thank you so much for your help. I have tried to find this answer but have had no luck. Have a good day.

MacBook Air, OS X Mavericks (10.9.4)

Posted on Aug 12, 2014 7:51 PM

by Yellowbox,Apple recommended
Yellowbox Yellowbox
Level 6 (10,455 points)
Mac OS X
A:

Hi GW,

 

Creating a Pop-Up Menu in Numbers 3 is very easy.

In a spare table or column, enter the values that you want to populate the Pop-up.

Select those cells.

Format Panel > Cell > Data Format > Pop-Up Menu

 

Screen Shot 2014-08-13 at 10.57.44 pm.png

 

Done. They are now Pop-Up menus

 

Screen Shot 2014-08-13 at 11.03.03 pm.png

 

Click on the upside-down triangle to show the menu items

 

Screen Shot 2014-08-13 at 11.04.12 pm.png

 

I would like to have a pop-up menu (on a different sheet) read:

     Banana

     Orange

     Apple

 

You can now copy and paste any one of those cells to another table (on the same or a different sheet). The menu choices will be carried over.

 

is it also possible to have the pop-up menu update itself automatically? Let's say I add A4 = Pineapple to my table. Could I get my pop-up menu to automatically have "Pineapple" as an option or must I manually type it in as a selection?

 

No. Not automatically. Numbers does not allow dynamic update from a table to a Pop-Up Menu.

 

(Apologies to quinn. I misread the original question).

 

To add an item to a Pop-Up, use the add button:

 

Screen Shot 2014-08-13 at 11.16.25 pm.png

 

Or start from scratch with a new list

 

Screen Shot 2014-08-13 at 11.19.38 pm.png

 

Regards,

Ian.

Posted on Aug 13, 2014 6:22 AM

Close
GWBush

Q: Dynamic Pop-up Menus

  • All replies
  • Helpful answers

first Previous Page 3 of 3

  • by Yellowbox,

    Yellowbox Yellowbox Aug 22, 2014 9:52 AM in response to t quinn
    Level 6 (10,455 points)
    Mac OS X
    Aug 22, 2014 9:52 AM in response to t quinn

    Hi quinn,

     

    As you know (we have corresponded by email) I have been working on your idea for two-level "nested" (or "dynamic" or "cascading") Pop-Up Menus using Numbers (not AppleScript).

     

    Thank you for your suggestion (by email) that an Order Form should allow a customer to order more than one item. I played with that idea and decided that it is outside the simple scope of one nested Pop-Up Table. We need a new table for each product, or a much more complex document.

     

    I am now thinking of several tables in one document, each table for one order. Include a summary table (Invoice).

    Screen Shot 2014-08-23 at 2.47.14 am.png

     

    Regards,

    Ian.

  • by Kilgor270,

    Kilgor270 Kilgor270 Apr 14, 2016 10:41 AM in response to t quinn
    Level 1 (12 points)
    Apr 14, 2016 10:41 AM in response to t quinn

    Hello All,

     

    Newbie here! - Is there a way to have a preset list of values in a column available for the pop-up menu but also add an Error message if the value has been already used?

     

    Example Column #1 -

    Pop up values for each cell

    100

    101

    102

    103

    104

    105

     

    If I select say "100" in any cell in the column, if I try to select it again, I get an error message or a literal red flag. I guess the other possibility would be to have a way to remove that data choice from the pop up if its already been used elsewhere in the column.

     

    Is this possible?

  • by t quinn,

    t quinn t quinn Apr 15, 2016 9:12 AM in response to Kilgor270
    Level 5 (5,012 points)
    Mac OS X
    Apr 15, 2016 9:12 AM in response to Kilgor270

    Hi Kilgor,

     

    There are ways to flag duplicate values but the popup aspect to your question is a nonstarter. As stated we do not have dynamic popups in Numbers.

     

    Here is a suggestion that may help with your issue.

          Find duplicates     

    Combined with conditional highlighting you can get pretty close to what you are asking for.

    Conditional Formatting

    You would substitute

    =IF(COUNTIF($A,A2)>1,A2"") f

    or SG's formula in Find Duplicates and then follow my suggestions in the conditional formatting thread.



    quinn

  • by Kilgor270,

    Kilgor270 Kilgor270 Apr 21, 2016 6:33 AM in response to t quinn
    Level 1 (12 points)
    Apr 21, 2016 6:33 AM in response to t quinn

    Thanks for the tip. Would it be possible to send me a working sample file to see if I can modify it for my needs? I

     

    Thanks

first Previous Page 3 of 3