> We've know there are some quirks in our current Forms feature of
> spreadsheets which makes it very confusing when trying to edit an
> existing form - particularly re-arranging questions... While we are
> actively fixing these issues, I thought it might be helpful to post
> some guidelines to getting along with the existing behavior of the
> forms feature...
> 1 - Generally, if you want to change the form, don't try to do it by
> changing the spreadsheet.... just edit the form. Changes to the form
> drive changes to the spreadsheet more than vice versa. The main place
> that doesn't hold true is in re-arranging questions. For now,
> spreadsheet columns will not move to stay in sync with the form (I
> know... not good).
> 2 - in line with the above, changes to the spreadsheet column headers
> (the text) do not get reflected in the form questions. If you start
> with a spreadsheet and then go to the form creation screen for the
> first time, you'll see that your column headers have been
> automatically converted into Form Questions. While that's a
> convenience, it's misleading - because future changes to the
> spreadsheet headers will NOT be reflected in the form - in fact, any
> time the form is edited and saved, the form questions WILL overwrite
> the associated spreadsheet column headers.
> 3 - Form submissions get added to the spreadsheet at the bottom of
> your data - after the last row which has data already. That means you
> actually CAN add data below your column headers but above your data
> collection area and form responses will still be collected correctly.
> Here's a detailed Do's and Don'ts format to clarify the above:
> DO:
> - from the form: DO re-arrange questions using the up/down icons on
> the left of the question being edited
> - from the form: DO delete questions you want removed from the form.
> Note: the spreadsheet column will NOT be deleted, so you won't lose
> any prior responses, but it will no longer be filled with any new
> data.
> - from the spreadsheet: DO insert columns for your own data -
> calculations, notes, etc - which are not in the form
> - from the spreadsheet: DO insert rows under your column headers to
> create calculations of results (such as counts of each answer, etc.
> New form responses will always be added after the last row with any
> content.
> DON'T:
> - from the spreadsheet: DON'T try to re-arrange questions by cutting/
> pasting portions of columns OR whole columns
> - from the spreadsheet: DON'T delete columns that are in the form -
> they will not be deleted from the form and will eventually re-appear
> in the spreadsheet (next time you edit the form) as the first
> available column at the end of your current columns.
> - from the spreadsheet: DON'T change column header text, as the next
> edit of the form will overwrite those back to whatever they are on the
> form... make all changes to question titles on the form and those will
> be transferred to the spreadsheet column headers (overwriting what's
> there).
> - DON'T expect re-ordering of questions in the form to change the
> order of columns in the spreadsheet
> Notice that all the Don't's have to do with trying to manipulate the
> form by making changes to the spreadsheet... so stick with the form to
> make changes for now.
|
