Hi,
I use a spreadsheet that has a number of sheets per day for listing sales/orders. The order pickers use this printout to collect and distribute the orders.
Each sale/order has a buyer, and a number of lines of purchases (qty, product, price).
Using the Numbers App for iPad, can I create a Form that will fill out these details and then update the Table so that I can show a multiple number of sales (buyers and his purchases) per sheet?
The trouble I am having is to create the multiple purchases for each buyer.
I have only been able to create the form with a buyer and 1 purchase.
The general layout on the sheet that gets printed by the order pickers would be like this:
The "Form" the salesman fills out while talking to the buyer should just be the buyer and his multiple purchases and this will then update onto the table/sheet above.
I hope I am clear enough. I have only had the App a few days. Thanks for any help.
Phil.
I use a spreadsheet that has a number of sheets per day for listing sales/orders. The order pickers use this printout to collect and distribute the orders.
Each sale/order has a buyer, and a number of lines of purchases (qty, product, price).
Using the Numbers App for iPad, can I create a Form that will fill out these details and then update the Table so that I can show a multiple number of sales (buyers and his purchases) per sheet?
The trouble I am having is to create the multiple purchases for each buyer.
I have only been able to create the form with a buyer and 1 purchase.
The general layout on the sheet that gets printed by the order pickers would be like this:
Buyer | ||
26 | Product | $25 |
52 | Product 2 | $50 |
Buyer 2 | ||
2 | Product 3 | $10 |
150 | Product 4 | $1 |
The "Form" the salesman fills out while talking to the buyer should just be the buyer and his multiple purchases and this will then update onto the table/sheet above.
I hope I am clear enough. I have only had the App a few days. Thanks for any help.
Phil.