Google-sheets – Filling Google Form through Google Sheet

Yes. It is Possible. Just follow some simple steps:

1. You create a custom function by writing scripts which will work like simple function inside a Spreadsheet cell for ex: =SUM(A1 +A2) by Opening the Google Spreadsheet(That acts like directory ie. Data like name,contacts etc) ->Click Tools->Click Script Editor...

A new window will openup and choose spreadsheet option .Here,you can write custom functions which looks like

Here you write functions (for more info,https://developers.google.com/apps-script/your_first_script#requirements)

2.You create a function that will open your Spreadsheet that contains behaves like directory. A sample function

function readRows()
{
var sheet = SpreadsheetApp.openById("0AszINz88nA9hdEkxa1FIS0wta1FLS2NPUzAyU0lOV1E")
var rows = sheet.getDataRange();
var numRows = rows.getNumRows();
var values = rows.getValues();
for (var i = 0; i <= numRows - 1; i++) { var row = values[i]; Logger.log(row); } };

For more info,https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app#open(File)

You can Run and Test by pressing Run and selecting function, (it may require permission).

You can view the results in Log Window by Opening View->Logs.

That,it now you can use that function in that cell.

Something I have done to accomplish this(sort of) is to make a certain number of identical questions. It could be 5 or 10 or whatever you see the max number being. Then I add a question at the end of each of those that asks if the person would like to add another.

So, in your case, you would have Book 1, Book 2, and Book 3. All are separate sections in the form. The person fills out Book 1 recommendation and says yes to adding another. They get routed to Book 2 section. They only have 2 recommendations so they answer no to adding another. They then get routed to the final section in the form which just contains a submit button.

I wish the ability to just add another question like you are asking for existed but until Google adds something like that, this should get the job done for you.