create order form that autofills a numbers spreadsheet

Question

Level 1

41 points

create order form that autofills a numbers spreadsheet

Numbers 3.5.2
OS. Yosemite 10.10.2

So at work I have to use Google Sheets and Forms. I like the way I can create a separate form that auto fills within a different spread sheet.
My question is can Numbers do this? Is there a way to create a form that has a list of options, like an expense report and when filled out is goes directly to a numbers file for tracking?

Thanks for any help.

Posted on Jul 29, 2015 5:37 PM

Reply

Answer 1

t quinn

Level 5

7,063 points

Jul 29, 2015 7:52 PM in response to Adology

Hi Adology,

In Numbers, each file or document is stand alone. Something might be cobbled together with Applescript but you would need to be very specific as to what your tables look like.

quinn

Reply

Answer 2

Barry

Level 9

60,023 points

Jul 29, 2015 10:28 PM in response to Adology

Hi Ad'

Further to what Quinn says:

Numbers can do that using separate TABLES within a single DOCUMENT.

The TABLES may be on separate SHEETS, but must be in the same DOCUMENT.

Regards,

Barry

Reply