Thursday, July 14, 2011

yogi_Create A Form To Place An Order By Specific Attributes

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

mereh said:
How can a create a form for a clothing company if I want to specify the number of units to order next to each style?
I am trying to set up an order form for a clothing company. I want to know if there is a way to format the form so that a customer can order more than 1 unit of a specific size & style. In google forms it doesn't seem to give me this option as it is only check boxes, multiple choice etc that you can choose to format your answer in. Please let me know if anyone has suggestions on how I could have a style number with sizes and boxes listed underneath where you could order 2 of size small and 5 of size large. thanks!
In the following solution I used a Form using just only Text style questions ... and then I added a compputed column L in the spreadsheet to compute the Order Amount

In the following, I present the Form that I created ...

and here is the spreadsheet ...