Hot answers tagged

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

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)....


1

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



Only top voted, non community-wiki answers of a minimum length are eligible