google sheetsgoogle-forms
I have been given a link to a Google docs form where I was supposed to enter some data. The URI looks something like this:
https://docs.google.com/spreadsheet/formResponse?formkey=foo
Is there anyway I can see the the responses already submitted by people using the 'foo' value (or may be some other hack like that)? Also, any idea how Google docs generates the keys?
If you add the following formula in cell D2:
=ARRAYFORMULA(FILTER(C2:C;C2:C<>"")*1.2)
then it will take on the complete column, via the array. The FILTER function, is to make sure no empty cells are taken into account.
I've added the result into the file you shared with us.
Since you asked about "an alternate way to solve this problem", I suggest using a required checkbox question with only one option: namely, the text of terms and conditions. This is more in line with the industry practice which requires a user to explicitly check a box next to T&C. The full text of this option will be included in the response, and can be emailed to the user by a script running on form submission.
One drawback is that options do not support line breaks. But one can separate sections with some ASCII art: I used 58 = signs below. This sort of formatting, replacing line/paragraph breaks with ===, can be done automatically if the document is long; the result is then copy-pasted into an option. The email-sending script can reformat the text for email, say, by replacement str.replace(/={2,}/g, '\n').
Using a part of Stack Exchange terms of service for illustration:
I don't know what the maximal length of option text it, but it can be long (multiple screens to scroll).
Best Answer
If you were given the link but do not own the form, then no - responses are private unless the response spreadsheet is shared with you.
If the response spreadsheet was shared with you however, then you can just search for that document title in your Drive list, and it will appear as a normal shared document.
No idea how Drive generates document keys, but they are different between the spreadsheet and the actual form, again to make sure that the responses are private unless explicitly shared with others.