Tag Info

New answers tagged

1

The best solution for this is to put the following formula in cell A1 in Sheet2: =arrayformula('Form Responses 1'!C2:C) This will auto update all entries that are made in Column C on the first sheet. If you dislike the name of your first sheet, you cab just rename it of course!


0

Google Forms are not intended for respondents collaboration. The answers to each question will be saved until the user press the submit button. This will save all the answers that user had set and will not update the form that other user has opened before. To get the las answers, the user should open the form after the last changes were submitted. If you ...


0

Instead of using a script, consider to add the responses to another sheet using formulas and there add the three columns. It's worth to say that Today() column will be updated when the recalculation occurs. I.E. Adding a column with the formula =Today() to the responses of a form add the following formula to A1 in a new sheet: =ArrayFormula( { ...


1

Google Forms now allows forms editors to insert images. From Add and edit questions, headers, images, videos, and page breaks Once you’ve created a form, you’re ready to start adding the questions you’d like to ask. If you’d like to give your form some structure, you can also add section headers and page breaks. Add questions, headers, and page ...


1

Overview The built-in response summary of Google Forms is not customizable, but you could set your form to send responses to a spreadsheet and use it to do assist you to count the responses by organizational units. You could create a "master" spreadsheet to use as template to do the follow up of each Google Form. Example of the "master" spreadsheet setup ...


2

There is no way to dynamically change the confirmation/thank you message. However, you could use the Autocrat add-on (or adapt its code) to send your customers a confirmation email with the reference number.


1

It looks like this issue is due to a bug in the new Google Sheets, but you can use this simple script as a workaround. In your sheet, go to Tools > Script Editor. Erase the existing code in Code.gs and add this instead: function setCellAlign(range, alignment) { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheets()[0]; var ...


3

No, there's no way. Google's help says Please note that while users will be asked to log in to their Google Account in order to access and fill out the form, their actual usernames will not be recorded. Some alternative approaches (taken from here): You could make completing the form "inviation only" and email people a unique code that they have ...


0

Yes. The form owner should set the form to allow users to edit responses. This will give them a link that they could share with others. For more details see Edit form responses after submitting - Docs editors help.


3

The problem was due to Google Forms adding a new row every time. If you are having the same problem here's what you need to do to fix it: Where you previously had your formula change it to: =arrayformula('YOUR SHEET NAME'!A2:A) Change the sheet name, and enter the cell you want to target, as-well as the column. Make sure you delete all other formulas ...



Top 50 recent answers are included