Sunday, November 27, 2011

yogi_Make The Column Headers And Answers Correspond After Changing Order of The Questions In Google Form

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
This has been an issue with Google Forms and there was a recent discussion on this in the following thread:
Need to change order of form responses in linked spreadsheet 
As I had stated in that thread and I will check out whether my proposed solutions work ... so when I started checking it out today ... I was pleasantly surprised -- there is no need for a fix ... when the order of the question in the Form is changed the Form Responses are logged in correctly in the right columns ... Bingo!
This doesn't mean that all situations ... all eventualities have been taken care of ... but this part as we know of is fixed -- a huge THANKS to Google Engineers for this!
here is the Form ... please note the Form had been EDITed and the questions were rearranged so that the order of the questions does not correspond with the order of the questions in the Form Responses sheet

and here is the Form Responses sheet ... however, please note that even though the column headers in Sheet1 do not correspond with the way the questions are ordered in the Form, the answers from Form submittals are logged in the appropriate columns.