Populate Form from a Table

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, and everytime I open a form, it will be there. In form, click Add-ons - Get Add-ons ...

Get Add-ons

In search box, type formRanger, then instal! (I already instal it, so it can only show manage)

instal

After you instal it, click again Add-ons, you'll find formRanger. Click it and click Start.

start

 Make your form, it only can populate the multiple choice, checkbox, list, and grid type questions. After you done, refresh your question using the button on the right side.

start

it is very simple ... just click new list, and it will take you to choose a spreadsheet, choose the column and name the list. And it will automatically populate it. Also ... you can set when will it be refreshed. So you don't have to open it again and again.

Look at my spreadsheet here.

Look at the form here.