Can we use App scripts code to create a google from and post response in google spreadsheet. #576

Activity

1. varunpal7

   changed the title [-]Can we use App scripts in google forms to create a from and post response in google spreadsheet.[/-] [+]Can we use App scripts code to create a google from and post response in google spreadsheet.[/+] on May 12, 2016
2. jmdobry

   added

   question

   on Jun 9, 2016
3. jmdobry

   self-assigned this

   on Jun 9, 2016
4. jmdobry commented on Jun 9, 2016

   

   jmdobry

   on Jun 9, 2016

   Last edited by jmdobry

   Contributor

   More actions

   • Create a form via App Scripts: https://developers.google.com/apps-script/reference/forms/form-app#createtitle
   • Programmatically respond to a form: https://developers.google.com/apps-script/reference/forms/form-response#withitemresponseresponse and https://developers.google.com/apps-script/reference/forms/form-response#submit

   For example (from https://developers.google.com/apps-script/reference/forms/form):

   // Open a form by ID and create a new spreadsheet.
    var form = FormApp.openById('1234567890abcdefghijklmnopqrstuvwxyz');
    var ss = SpreadsheetApp.create('Spreadsheet Name');
   
    // Update form properties via chaining.
    form.setTitle('Form Name')
        .setDescription('Description of form')
        .setConfirmationMessage('Thanks for responding!')
        .setAllowResponseEdits(true)
        .setAcceptingResponses(false);
   
    // Update the form's response destination.
    form.setDestination(FormApp.DestinationType.SPREADSHEET, ss.getId());

   Responses to a form are posted to the form's destination spreadsheet.
5. jmdobry

   closed this as completedon Jun 9, 2016
6. google-admin

   unassigned

   jmdobry

   on Sep 11, 2018
7. saumyasinghal747 commented on Dec 1, 2020

   

   saumyasinghal747

   on Dec 1, 2020

   More actions

   How can I do this using the Node.js client?

   👍React with 👍2Reacted by Jay Vercellone and Loban Rahman
8. JustinBeckwith

   assigned

   jmdobry

   on Feb 1, 2021