How can I create a table in Numbers that is connected to another one?

Question

Level 1

8 points

How can I create a table in Numbers that is connected to another one?

Hi,

to come around the problem of the inexisting dynamic Pop-Up Menu in Numbers, so that I can show a certain Pop-Up Menu based on a previous drop menu I selected.

I thought I could create several new tables identical to the main one, filter down the rows only with a certain selection of the first Pop-Up Menu, and then create a new column with a specific drop menu for each different table.

So if in the main table I selected "food" from the Pop-Up Menu, in the new table, which will be filtered for only rows that contain "food", I can create another Pop-Up Menu (restaurant, bar, grocery...). Likewise, if I had selected "entertainment", I'd go to a new table with a different Pop-Up Menu.

The problem is that I'd like the secondary tables to show automatically the rows I add in the main one, without having to copy and paste every time.

Thanks,

Edo

MacBook Air (13-inch, Early 2015), macOS High Sierra (10.13.6)

Posted on Oct 29, 2018 1:26 AM

Reply

Answer 1

SGIII

Level 8

37,580 points

Oct 29, 2018 7:01 PM in response to edoardo138

Numbers just doesn't have "dynamic" Pop-Ups.

And not sure what you mean by "connected" table.

If you post a screenshot then perhaps someone can help you achieve what you are trying to do, at least make it a little easier.

SG

Reply

Answer 2

Yellowbox

Level 7

21,963 points

Oct 29, 2018 8:59 PM in response to edoardo138

Hi Edoardo,

See this User Tip.

Nested (or Cascading) Pop-Up Menus in Numbers

They are not dynamic, but maybe they are another way to achieve what you want,

Regards,

Ian.

Reply

Answer 3

SGIII

Level 8

37,580 points

Oct 29, 2018 10:08 AM in response to edoardo138

I don't think it's not a question of what you call them. Numbers just doesn't have "dynamic" Pop-Ups.

If you post a screenshot perhaps someone can help you achieve what you are trying to do, at least make it a little easier.

SG

Reply

Answer 4

SGIII

Level 8

37,580 points

Oct 29, 2018 7:10 AM in response to edoardo138

Hi Edo,

As mentioned in your other thread, Numbers doesn't have cascading dropdowns (or Pop-Ups) the way you can do in Excel with Data Validation.

However, as illustrated, Pop-Ups are quite easy to make.

SG

Reply

Answer 5

edoardo138 Author

Level 1

8 points

Oct 29, 2018 7:28 AM in response to SGIII

Clearly, I'm not getting however you would call them in English, but that's not the problem, I know they're easy to make!

I'm trying to figure out a way to create dynamic Pop-Ups, and to do so I need to know if there's a way to create linked tables.

Reply

Answer 6

edoardo138 Author

Level 1

8 points

Oct 29, 2018 11:45 AM in response to SGIII

I was just trying to give a solution for this missing feature. All I need to make it work is, as I said, the possibility of creating a second table that would be connected to the main one. So that if I add something in the main one, it is automatically added to the secondary too.

Should I make another discussion with just this problem? I just discussed about the dynamic Pop-Ups to help other people with the same question find this discussion.

Reply

Answer 7

edoardo138 Author

Level 1

8 points

Oct 30, 2018 12:30 AM in response to SGIII

Starting off with the main table on the left, create a second one identical, but it has to automatically add rows as I'm adding them on the main one, like this:

Without having to copy and paste every time I do it. This would allow me to create dynamic Pop-Up menus, but just if the second table automatically refreshes.

Reply

How can I create a table in Numbers that is connected to another one?

Similar questions