Google Spreadsheets / Forms tip

I love the form feature, but it’s still very simple and can be difficult to work with. But I did find a good trick to updating a sheet with a form attached (which is surprisingly not a standard feature):

To edit a form and columns so that they continue to match-up:
First make a backup if you are not sure about the following:
1. Make receiving sheet the left-most sheet (according to ahab above)
2. Open the form in the form editor
3. Make changes to the form and do not save or close yet.
4. On the receiving SS do Form > Delete
5. In form editor do Save: The SS columns will change to reflect the new form questions.
6. Test the form
7. Move the earlier data on the SS left to match the appropriate columns


Add Page Numbers to Google Docs

This is a pretty cool trick:

goslogogif.png Google finally realized that the headers and footers from Google Docs have almost no real use, as you can’t add dynamic information like page numbers or the current date. Until Google adds these options in the interface, you can edit the document’s HTML code to use them.

Note: these headers and footers will only be visible on an exported PDF.