Tag Info

Hot answers tagged

4

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


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

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

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.


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

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

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

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

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

FormEmailer will let control who the email is sent to and what is sent. https://sites.google.com/site/formemailer/


1

Follow these steps Open the Google Spreadsheet file that your form responseas are saved into. Select the whole column, by clicking on the column name letter at the top of it - not just a set of rows in it. Apply the alignment you want. Your selected alignment should now be applied to all new rows that are added to the Sheet from the Form. (I have just ...


1

You cannot add any elements that are not available in the form builder, so you cannot control how the respondent's username is displayed. But the the username is displayed to the user filling in your form, if you're using Google Apps for Business. Make sure the options Require [domain name] login to view this form and Automatically collect respondent's ...


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

No it is not possible to automatically add question numbers to Google Forms.


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

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

So the solution is the correct usage of project triggers. you can use them to control the webapp to run only on form submit:


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

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

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

Oscar is right. You can also add a hyperlink in the confirmation page and it will become clickable.


1

I think Ragic works for you. It's a spreadsheet style online form builder and fully supports creating a form from spreadsheet. You can also import more spreadsheet data to an existing form or export all / or filtered data to an Excel file.


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

Finally...they now support printing it out. https://plus.google.com/u/0/+GoogleDrive/posts/ZSWMyZKC22t


1

I found it necessary to check the "sign-in to view form" box, save, and then uncheck it and save in order to allow access to the form without sign-in (which was being required, for no understandable reason).



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