New answers tagged

0

You are using a formula =LOOKUP(F2, AreaCodes) and you want this to be updated as each Form Response is received. You are using a named range (AreaCodes) as the search_result_array. When the range was created there were two options for establishing the range: 1 - Assign a starting row and an ending row (a fixed range). For example, the range might be "A2:...


-1

replace "viewform" for "formResponse"


1

How to Fix your problem Manually install the onFormSubmit trigger. When installing the Trigger, under "Choose which function to run", choose the function onFormSubmit (the trigger event argument () isn't shown when creating the trigger. There should only be one onformSubmit trigger, and only function executed by the trigger. If you find that the function ...


0

Try toggling the switch again or force-refreshing the page by holding Control and clicking the refresh button. That field should disappear automatically when you de-select the checkbox in Settings.


0

I believe I found the answer while looking into VB Scripts, for Google Sheets it's Google Apps Scripts https://developers.google.com/apps-script/reference/spreadsheet/range#mergevertically


0

It's very likely that having several form summit triggers be part of the problem. Another thing that could be causing the problem is having form submissions while a form submit triggered script is running. One more thing that could be causing the problem is a know bug that that a single form submission trigger is triggered multiple times by a single form ...


0

The code in the question only include a function that require two parameters. The error mentioned in the question will be thrown if you call that function directly from custom menu, button (image with this function assigned), an installable trigger, from google.script.run or the Apps Script API. The solution is to call the function from another function ...


0

The problem is in the line var labels = wsData.getRange(1, 1, 1, wsData.getLastColumn()).getValues()[0] As it's returning Bobur CEO instead of the expected values. Replace the above line by var labels = wsData.getRange(1, 1, 1, wsData.getLastColumn()).getValues().map(function(row){ return row[0]; }); .map(function(row){return row[0];}) will flatten ...


0

According to an answer from Adam Davis the maximum number of characters by form response is 32,750. Exceeding this limit will through the following error message to the form respondent Your response is too large. Try shortening some answers. The number of form recipients is based on the daily remaining email quota. The maximum emails that a "basic ...


1

Incorrect. The current version of Google Forms has an independent form responses repository. Sending form responses to Google Sheets is optional. Form responses could be downloaded as CSV from the Google Forms. Also they could be retrieved by using Google Apps Script. It's worth to mention that Google hasn't disclosed Google Forms limits but there are ...


1

Google Forms may not have this option but you can use one of the free add-ons Another way would be by using one of the add-ons found using the top right kebab menu (1) in the form: Choice Eliminator 2 or Choice Eliminator light or similar add-ons would be your choice. Once installed you can find them under the menu. (2) Note: One of the main ...


Top 50 recent answers are included