Tag Info

Hot answers tagged

4

I've just adapted some trick which is very simple by using Validation option in Text field to check the password which you set it before give it away. For example. Set a field with user name let them choose from the list you add their name in advance let connect those name the pagebreak which is on their name on the page let set a text field and add the ...


2

Each form is a distinct object, separate from the spreadsheet itself. The spreadsheet is merely the destination for the form responses, for the purpose of reading and using them, and responses sent to the spreadsheet are no longer connected to the form itself. The actual responses that are connected to the form are stored with the form. If you want to clear ...


2

This will save the edit your response URL to a cell in the spreadsheet. put the script in the spreadsheet, not the form. Can also include the var editURL in an email to the user after they click submit to email them the edit URL. // edit response var form = FormApp.openById('XXXXXXXXXXXXXXX'); //enter form ID here var sheet = ...


2

You can run a script that will catch the submitted responses, then add a row to the public spreadsheet with the appropriate data. If you need any help writing this, let me know. Edit Something like this should do it: /** * This will * set a trigger for this as described here: * ...


2

Further to the above answers - This solution doesn't require an extra spreadsheet cell. You can use the inbuilt event handlers for submission of the form to get a unique id. Because the spreadsheet is just the destination for the form, deleting a row doesn't actually delete the response. With that in mind... EDIT: removed need for ID and dealt with date ...


2

Here's how. Add the host (eg. www) and domain name (eg. google.com) without the protocol or an html anchor. In other words: Works www.google.com gmail.google.com Will not work google.com http://google.com <a href="http://www.google.com/">google<a/>


2

You can do this with a normal form and a script, using Form.getItems(), find the item in loop, then Item.asListItem().setChoices(...) Here is some sample code, which I've used in this example sheet and form var FORMID = "YOUR FORM ID HERE"; var LIST_DATA = [{title:"Who's your tutor", sheet:"TutorName"}] function onOpen(e){ var menuEntries = []; ...


2

You would need a Google Apps Script to automatically add your QUERY to new rows. The following script runs when a form is submitted, and populates the D column with the formula from the previous row. That is, before running the script, you need to enter your formula in the first row. function onFormSubmit(event) { Logger.log("Event: " + ...


2

I have answered my own question: Just add another item in the "LIST_DATA" array. Example: var LIST_DATA = [{title:"Who's your tutor", sheet:"TutorName"},{title:"Select subject:", sheet:"Subject"}]; So the code would read: var FORMID = "1rfHTqTj06SE9nZdCSupvAIYAkfmwhn9wOLJnrWuE_6I"; var LIST_DATA = [{title:"Select Subject", sheet:"Subject"},{title:"Who's ...


2

My initial response is yes. How? You'll have to look into Google App Scripts. You're probably better off creating a form via script and then creating a function that validates the dates and times. So perhaps the pseudo code would be... function main() { // Get today's date and the final date for the form to accept responses // var ...


1

You can use this code. Code function onFormSubmit(e) { var responses = e.response; var lastResponse = responses[responses.length - 1]; Logger.log(lastResponse.getId()); } I wasn't able to find a clear cut solution, thus ended up with this. It will simply get the IDof the last entry


1

They can choose to collect this information, but the form will display a message. If you use Google Apps, you can record the email addresses of the people who fill out your form. To do this, select the checkbox next to 'Automatically collect respondent's yourdomain.com username' when you create the form. Recipients of your survey will see a message ...


1

If you will want to edit the form in the future, let her make a copy. If not, you can change form ownership, It's in Sharing settings. Go File → Add collaborators if your boss is not there yet, add her and click "Share & Save" Change her permissions to "ownership":


1

The following formula will auto-expand on new form entries. Formula =ARRAYFORMULA(VLOOKUP(B2:B,DATA!A2:G,IF(C2:C="1st",{4,5},{6,7})*SIGN(ROW(A2:A)),0)) Example See the fowlloing answer I gave: http://webapps.stackexchange.com/a/52050/29140


1

The problem is in the first line of the script. Your form ID is the special ID that identifies the form. You can see it in the address of the form (it's the bit in bold) docs.google.com/forms/d/17rxZ5vzy0OcxibXV6aRpso7Xm_Vs0FpxMLgbchjO998/viewform. You accidentally used the form name instead. That being said, I should have just used the ...


1

I have one suggestion: on the next empty column on your Form Response: =Query(range; "select * where x <> '' order by x" , 1) Where range is the range of the responses and x is the column that you want to sort. Hide the columns where the answers are automatically inserted.


1

Disclosure: I work for Ragic. Ragic is a spreadsheet style online form builder (says so right on the homepage). And as for your requirements: Ragic supports a lot of Excel formulas (to do your cost calculations). Ragic supports Excel LOOKUP function, and linked sheets to look up value from other sheets. Provide checkboxes to select multiple events. ...


1

The spreadsheet is not the actual repository of responses. There is a 'bucket' of responses that is connected to the form itself. The data presentation features use the responses connected to the form. You need to use a script to add the extra responses to the Form object. You won't be able to save the original dates with the old responses, as the ...


1

It sounds like you have two different Google Documents. You have the Google Form that you created and the Google Document that each of your students created with their work. You have permission to your own Google Document form. But you need permission to access your students' Google Documents work product. Just because you have the link to your students' ...


1

I think this tutorial will work, it's more of a hack and I'm sure there are cleaner ways to do this, http://www.immersionmedia.com/blog/customizing-and-styling-google-forms/ This tutorial tells you what code to extract from the form. There are other, better ways to do this that involve validating each of your quiz elements (text box, multiple choice etc), ...


1

To view what was entered you would need to have access to the Google Spreadsheet in which the form data is being saved to. Alternatively there are extensions like Lazarus : Form Recovery which will save text you entered into the form previously, so that you can fill it using that data. Though this extension is more intended for recovering text in a form, ...


1

Try this - it uses the event handler and submitted data to identify the correct response and row, so it isn't affected by race conditions. A test function is included. I've also submitted this code to the original question, but felt that the issue of multiple entries at the same time merited a response. This technique could be used to similar effect ...


1

Still don't have a solution for how to directly get values of unchecked checkboxes, but I was at least able to write a function that compares the correct answer to the submission. This splits the correct answer into an array then compares each item to the submission: function checkAnswer(answer, key) { var kArray = key.split(', '); var nArray = []; for ...



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