Tag Info

New answers tagged

0

At this time isn't not possible to delete a single response from the responses repository attached to the Google form. One alternative is to save the responses to another repository delete all the responses from the form and submit again the desired responses. Another alternative is to edit the duplicate response. References FormResponse - Google Apps ...


0

There is a way to automate the list updating by setting a Trigger[ 1 ] [ 2 ] for Update Lists. The path is Script Editor -> Resources -> Current project's triggers Then, add a new trigger. For the given examples, you can set updatesList to run from spreadsheet and On form submission. This way, the function onOpen won't be needed.


1

Here is how it could work. The script does the following: Get the sheet with form responses Get the last (nonempty) row there Pick the entry from column B. To make matching more robust, it trims the entry (removing any whitespace left or right of text), and converts to lower case. If the result is 'yes', an email is sent. The body is the content of the ...


1

One approach is to add a status column next to the data input: for example, in L10 it would be =if(iserror(match(H10, H11:H, 0)), "current", "obsolete") which returns "current" if no entry below the present row has the same email. Then your query can filter out the obsolete results. The above does not work with arrayformula. I don't think there is an ...


0

At this time it's not possible. One alternative is to create a report to display the responses the way that you want. You could use spreadsheet formulas to create the report. Google editors Help


3

There's a defect listed on the Google Apps Script issue tracker. We'll have to wait it out to see when a project member responds to it, I'm assuming.


1

Depending on the type of question, Google Forms could create a chart automatically for you and display it in the "Summary of responses". From View and manage form responses View the summary of responses To quickly see how many users filled out a form and what their responses are, you can check out the response summary. From your form, click the ...


0

Instead of sharing the responses sheet use a IMPORTRANGE and FILTER or QUERY to pass to a second spreadsheet only the "public" responses share that spreadsheet with them. The formula will look like the following, assuming the in Column C will include "Public" for the public responses. =QUERY(IMPORTRANGE(spreadsheet_key,reference),"Select * Where Col3 = ...


0

Google Forms doesn't edit data in Google Sheets, instead they send responses. Responses sent to a Google spreadsheet could be updated but should be enabled the option "Allow users to edit responses". By the other hand, Google Forms and Google Sheets don't have a built-in feature to send responses to specific sheets based one answer. One alternative is to ...


1

You could use =ROW()-1 as was proposed in the answer by @ghozx. It's worth to say that this will require to fill down the formula manually or by a script after one or more responses be submitted. An alternative is to use the following formula in cell C2: =Filter(Row(B2:B)-1,Not(isblank(B2:B))) The above formula will return an array that will be of the ...



Top 50 recent answers are included