Numbers - Using Pop-up Selection to Populate Selected Number of Form Instances

Question

Level 1

8 points

Numbers - Using Pop-up Selection to Populate Selected Number of Form Instances

Building a Pricing Sheet.

I have built a small form to analyze pricing for a set of properties in a room.

I would like to be able to use a pop up to select the number of rooms to price and then the small form is duplicated based on the selected number in the popup.

If I choose 5 rooms, I will get 5 forms with a 1-2 row space between them.

There is the added complication that I am also calculating the total of all the rooms to arrive at an overall project cost.

Wondering if this is possible.

MacBook Pro Apple Silicon

Posted on Mar 7, 2023 7:56 AM

Reply

Answer 1

Yellowbox

Level 7

21,981 points

Mar 7, 2023 6:38 PM in response to pLlave

Hi pLlave,

I am not sure what you want to do. Your profile shows MacBook Pro, and you have reached the Numbers for Mac forum. Welcome!

Numbers for Mac does not have forms. It has tables. Numbers for iOS (iPad, iPhone) does have forms as a feature.

A question to clarify your aim: are you asking about forms (Numbers for iOS) or tables (Numbers for Mac)?

More information may lead to a solution.

Regards,

Ian.

Reply

Answer 2

SGIII

Level 8

37,604 points

Mar 8, 2023 12:11 AM in response to pLlave

pLlave wrote:

duplicated the number of times chosen in the pop-up. Very similar to just copy/pasting the same group of rows to match the number of rooms in a project. Just would like it to be automatic.

If you frequently need to duplicate a given table a number of times then a script within the built-in Shortcuts app can help (no need to know how to script to install and use this. Just click, point...).

Click somewhere in table and chose Duplicate Selected Table from the Shortcuts Menu.

Answer the prompt.

After you click 'OK' the new tables should appear on the same sheet in your Numbers document.

If you are sure you have selected a table before running and you still get an error message then you may have to change permissions within System Settings to allow Shortcuts to perform this action. Also check Shortcuts > Settings > Advanced to allow running scripts.

This only makes multiple duplicates of the selected table. You'll have to work out separately out how to make a total from the various tables.

Open this link in Safari to inspect and install the Shortcut on your Mac.

SG

Reply

Answer 3

Yellowbox

Level 7

21,981 points

Mar 8, 2023 12:30 AM in response to pLlave

Hi pLlave,

I am still not clear on your aim, but here is one idea.

Table 1 has enough rows to cover all possibilities.

The single cell Table "No.of Rooms" can be a Pop-Up Menu, a Stepper, a Slider, or simply Automatic format where you type a number.

Formula in G2: IF(A2≤No of Rooms::A$1,"Show","")

(Type <= and Numbers will change that to ≤)

Now apply a filter to Table 1. You can hide the "Show?" column.

Just a guess!

Regards,

Ian.

Reply

Answer 4

pLlave Author

Level 1

8 points

Mar 7, 2023 6:45 PM in response to Yellowbox

Thanks for the reply.

Don't get caught up in my use of the word "form". Im using Numbers for MacOS.

My "form" is just a "table" with about 15 rows that have a list of items to price in a single room.

A single project might have 5 rooms for example and another project might have 23 rooms.

I would like to have a pop up that picks the number of rooms at which time this "table/form" of rows is duplicated the number of times chosen in the pop-up. Very similar to just copy/pasting the same group of rows to match the number of rooms in a project. Just would like it to be automatic.

Reply