I need help combinInc forms and spreadsheets. Kyaw On Jul 20, 2014 10:46 PM, <[email protected]> wrote:
> Today's topic summary > > Group: http://groups.google.com/group/google-spreadsheets-api/topics > > - I need help combining forms and spreadsheets > <#147548f16904e49d_group_thread_0> [1 Update] > > I need help combining forms and spreadsheets > <http://groups.google.com/group/google-spreadsheets-api/t/e56eb5156ec7980b> > > Gur Telem <[email protected]> Jul 19 09:58AM -0700 > > 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.
