Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
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 ...
This is great but is there a way that the buyer can know what their total is?
ReplyDeleteHi sam1999:
ReplyDeleteIf you mean whether the buyer can know what the buyer's order amount is before placing an order (before submitting the Form) ... no that is not possible with the Google Form in its present incarnation.
It is possible to permit the Form submitter to view a summary of the responses after the Form has been submitted.
Another way would be to display a part of the spreadsheet with the Buyer's ID, the unique Timestamp and the Buyer's order amount (of course after the Form has been submitted).