Tag Info

Hot answers tagged

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

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


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


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



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