Saturday, February 25, 2012

yogi_Set Up A Form For Top N Attributes With Each In Its Own Column

Yogi Anand, D.Eng, P.E.                Google Spreadsheet          Post  #443

user SurveyQuest said:
Creating subtext boxes within a text box in a Survey Form
I know one can use "Forms" to create a survey and link the response to a spreadsheet. I need to create a survey where the user fills in 3 or 5 unique ideas (responses) for the one questions which I can then categorize separately in the spreadsheet. For example, Question: List your top five (5) movies. Currently, I can only have the user number their entries as 1., 2., 3., etc, but since the box is a "text" or "paragraph text" everything goes into one column in the associated spreadsheet. Is there a way to get around this limitation.
following is an idea for solution to the problem

here is the so called Form Responses sheet -- each idea has been logged in its own column

and here is how the Form was set up to obtain responses as showin the Form Responses sheet: