Scribbling Dock

Google sheet is commonly used as database. But did you know that you can use google form to collect it? I've been using google form for years now ... and made several how to's .. but I can't believe that I've never made how to create google form and connect it to spreadsheet ... so here ... There are many ways to connect google form to sheet 1. Through google form . Go to google form, and create your form. And at the responses, create the sheet. 2. Through google sheet Go to google sheet, and create your sheet. On tools- create form, it will automaticaly create a sheet as form response Then boom ... you have 2 files connected to each other. Share your form through link, email or web page. From the link, open in browser, then add to home page, it will create a browser shortcut to the browser, with form logo in it. So there ... ^_^

An update from this log . A year ago, I was trying to populate my google form, from a column in a table, using a script formRanger . At that time, it can only be use in old google spreadsheet. So, when I change to new google spreadsheet, I can no longer use it. But today, I found out, it is in google Add Ons ... So... I'm in hype! The best thing is .. it can use other spreadsheet as the source. Nice he? So anyway ... I prefer to have my list in the same spreadsheet with the respons report of my form, so first thing is ... I prepare my table. I put it in another sheet, the first row is the title of the list . So if you use other spreadsheet as the source, just make sure you put the first row is the title, If you don't you'll lose the first row in the list. the list Since I start from the spreadsheet, I make a form from that spreadsheet, so it will attach automaticly. click form - edit form ... it will take you to form. The first time, I instal formRanger, just once...

When I tried to use google spreadsheet as project management tool for my friends, I was having a hard time to keep up with the list. Do I have to write it down one by one? ... it's more than a hundred list! nightmare ... copypaste? ... still not an option! After I've asked my good friend "google" ... We've found an article in a google group. it is called formRange, created by ahab ... I don't know this person, but LORD please BLESS this man for making my life so easier!! ... thank you Ahab .. who ever you are ... ^_^ So, here is the how to section . Need I explain more? thehehehehehe ...