Google Docs: The Do's and Don't's for using Forms

Google Docs logo

เรื่องที่ควรทำ และไม่ควรทำ เมื่อใช้ Google Docs: Spreadsheet Form

DODON'T
From the FORM
  • re-arrange questions using the up/down icons on the left of the question being edited
  • 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.

DODON'T
From the SPREADSHEET
  • insert columns for your own data - calculations, notes, etc - which are not in the form
  • 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 try to re-arrange questions by cutting/pasting portions of columns OR whole columns
  • 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.
  • 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

More Info:

Relate Post:

Comments

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account associated with the e-mail address you provide, it will be used to display your avatar.