New answers tagged google-forms
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.
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 ...
If you're willing to install an extension, the Form Values extension should help you here. From the description in the Add On store: Do you find yourself regularly typing the same choices in for multiple choice, list or check box questions when creating forms? Form Values allows you to store and use lists that you use regularly in forms. This ...
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.
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)))))
My solution should be to use the autoCrat add-on from New Visions Lab. With this add-on you can add a PDF document to an automated mail you send to the user. See: http://cloudlab.newvisions.org/add-ons/autocrat
You can select a range of cells, then go to Tools > Protect Sheet... Review settings, hit "Set permissions", Select "Custom..." and add the email addresses of the people who you'd like to have access. It'll make the said sheet/range of cells non-editable for everybody else, still not hidden though.
Top 50 recent answers are included