New answers tagged

1

The form will always record responses to separate questions in separate columns. But you can add a column with a formula that joins them together. For example, if you enter =join(", ", B2:K2) in cell L2 and drag down the column, the column L will have the data from columns B-K, separated by commas for readability. A more complex example is =B2&" ...


1

Short answer The link points to a Q&A that has two answers but non-of them looks to me to be appropiate. I.E. the code of one of answers is incomplete and both of them send emails, so the adoption is too complex to be used as a starting point. Below is a script that is easier to adopt. Instructions Create a test form and set it to send responses to ...


1

This is what you can do: Go through all the rows and find the first row with valid e-mail address Continue until you find an invalid e-mail address Re-retrieve all the data in the range and change "@" to "#" This way, you can keep adding new rows and the code will still work. And the code shouldn't mess with any formulas you might have at bottom of the ...


2

Short answer From the question After the user submits their choice on that page of the survey, I want the next page to display text that refers to their choice. This is not possible with Google Forms. Explanation Google Apps Script could be used to create, access, and modify Google Forms and to read and edit form responses but not to control the ...


2

You can do a lot of things with Google Forms responses with basic programming skills and knowing JavaScript as ome tasks with Google Forms responses could be automated with Google Apps Script with a bounded script to the form. One of the keys for your project is to use Google Apps Script installable triggers, specifically time-driven triggers to be able to ...


3

Short answer Add a new sheet. Add the following formulas to the new sheet Cell A2 -> Headers =OFFSET('Form responses 1'!$A$2,ceiling((row()-1)/5,1)-1,0) This could be repeated several times, one for each header column, just change the last parameter accordingly. Cell B2 -> data =OFFSET('Form responses ...



Top 50 recent answers are included