So basically, I'm trying to create a form that after you submit it it puts the results in specific spreadsheet depend on a specific field in the form. For example, my form is: First Name: Last Name: favorite food: favorite color:
and the results are: First Name: Jack Last Name: Adams favorite food: Pizza favorite color: Yellow I want to put this results in a spreadsheet called Jack Adams if this spreadsheet exists and if not I want to create spreadsheet called Jack Adams. So I thought about a way that goes like that: On the spreadsheet that keeps the results of the form I'll put a script that says that every time that this spreadsheet is being changed so take the last row and put it in a spreadsheet called (the first "field" in the row). But I have no idea how to get access to spreadsheet without id. Also, do you know if the script will run even when the spreadsheet is closed? I hope it will or I'll need to find another way like putting the script on the form, but I don't know how to work with the forms API. Any way I'd like to get some help. Thanks, Gur. -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
