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:
No comments:
Post a Comment