Hot answers tagged

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


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


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

The only way I found to do this is with a script. Step 1: Go to Tools > Script Editor and put the following code there: function wrap(e) { e.range.setWrap(true); } Step 2: Still in Script Editor, go to Resources > Current project's triggers, and select from dropdowns "wrap", "From spreadsheet", "On form submit". Step 3: You're done. Close the ...


1

When you insert or link a form to a spreadsheet, a new sheet is always created. This makes sense because the data is transmitted in a specific way: column A is Timestamp, etc. The algorithm isn't meant to work around some pre-existing data in the sheet, so it pulls out a clean sheet to work with. But you can achieve the desired effect by copying the ...


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


1

This can be done with the following Google Apps Script. It should be added to the spreadsheet that receives form submissions (go to Tools > Script Editor). After entering the code (including the URLs of the spreadsheets A-D, E-L, etc), go to Resources > Current Project's Triggets and add a trigger "createSheet | From Spreadsheet | On form submit". function ...



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