Tag Info

Hot answers tagged


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


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.


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!


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


This happens because your Google Sheets is linked to a Google Form. When you copy the sheet you also copy the form. You can create a new (not a copy) Google Sheet and copy the content from your old Google Sheet to it. Copying this new sheet will not create a new form. Please be more clear about the auto-creation feature you are talking about.


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


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

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