Tag Info

Hot answers tagged

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


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


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

I would copy the list from http://www.listofcountriesoftheworld.com/ and paste it in a sheet. Then I would use the add-on formRanger to fill the question with the content of that column with names.


1

Try: =ARRAYFORMULA(transpose(split(concatenate(if(B2:D<>"", B2:D,)&char(9)),char(9)))) or: =ARRAYFORMULA(transpose(split(concatenate(B2:D&char(9)),char(9)))) or also: =ArrayFormula(transpose(trim(query(transpose(B2:D),,rows(A:A)))))


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



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