Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #641 Jul 19, 2012 www.energyefficientbuild.com.
user Kelemvor said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/UuSHv00N_5g)
Can I make a form and have the spreadsheet do math on the entries?
So I'm trying to put together a basic order form. I have a spreadsheet that has items going across the top. Each item has a price.
I want to make a form that will list the items and people can enter how many of the items they want to buy.
When they submit it, the data should go into the spreadsheet and calculate a total.
I tried having a header row with items and a cost row below that, but the form entries went above the cost row and moved everything down so it didn't work.
Here's a link to the spreadsheet which has a simple form attached.
https://docs.google.com/
Any help would be great.
------------------------------------------------------------------------------------------
following is a solution to the problem ... I have added some more data and a sheet for extracting orders by name of order placer
user Kelemvor said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/UuSHv00N_5g)
Can I make a form and have the spreadsheet do math on the entries?
So I'm trying to put together a basic order form. I have a spreadsheet that has items going across the top. Each item has a price.
I want to make a form that will list the items and people can enter how many of the items they want to buy.
When they submit it, the data should go into the spreadsheet and calculate a total.
I tried having a header row with items and a cost row below that, but the form entries went above the cost row and moved everything down so it didn't work.
Here's a link to the spreadsheet which has a simple form attached.
https://docs.google.com/
Any help would be great.
------------------------------------------------------------------------------------------
following is a solution to the problem ... I have added some more data and a sheet for extracting orders by name of order placer
No comments:
Post a Comment