New answers tagged

0

I have expanded the functionality of the script from the linked question accordingly. First it checks whether the sheet with given name already exists. If it doesn't, the sheet is created and the headers of the form responses sheet are copied there. Otherwise, the existing sheet it used. Either way, the newly submitted data is then copied to the sheet. ...


1

This can be done with a script. Enter the following in Script Editor, found under Tools. Change the 'Name' to whatever is the name of the form field that should be used. function formSheet(e) { var sheetName = e.namedValues['Name'][0]; var sheet = SpreadsheetApp.getActiveSpreadsheet().insertSheet(sheetName); sheet.getRange(1, 1, 1, e.values.length)....


3

You need to use the google.script.run.myServerFunctionName() client side API. You will need to use that anyway, in order to send the form data, unless you are using a HTTPS GET or POST request to send the data somewhere. Apps Script documentation - google.script.run


1

Google Forms doesn't include calculated fields. One alternative is to create a web app by using Google Apps Scripts.



Top 50 recent answers are included