Hot answers tagged


You need to use the 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 -


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


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