Tag Info

Hot answers tagged

4

Choose the question type as Text Click on Advanced settings Check Data Validation Choose Text Choose Email Address (optional) Type in a custom error message


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

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

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

The short answer is: You can't do that using Google's form builder. The longer answer is that you can copy the form's HTML code and host it on your own website. That HTML code may then be modified to have the button display any text you'd like. Copying and hosting the HTML code does have its drawbacks. If you edit the form from Google's form builder, the ...


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

Part of my answer would be: this is a known bug (newly received form submissions do not respect the format of the columns that they are landing in, as they did in the old version of sheets). Depending on what you are doing with the data afterwards, another option would be to reproduce the form submissions on another sheet, with the correct format. For ...


1

You might have to open up the spreadsheet where the results are stored, and make your own manual summary. I don't think that Forms automatic summary can cope with this in any way.


1

Create a "pivot table report" inside the Responses Sheet (Data -> Pivot report table) in the "Report editor" on the left, insert the values of the Form as "Rows" . format the columns as you like. How to create and edit a pivot table report in Google Sheets: https://support.google.com/docs/answer/1272900?hl=en


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 need to use "Multiple choice" or "Choose from a list" and then check "Go to page based on answer". Now you need to create a page break and place your extra two options there (Add item > Page break). Then after each choice in the original page, you need to select the page you created. Therefore when the user selects that choice he will be redirected to ...


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

do you have any suggestions for a way to do with with another application? This is possible with our product, JotForm. Please see How To Add Options in a Payment Form tutorial for details. The tutorial assumes you already know how to use JotForm so first do these steps: Go to JotForm site and create an account Create a new form Add "Purchase ...


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

Thanks for your great answer, @Tom Horwood! Here is my suggestion for the script is used for my project. I have modified the script of Tom to adjust when fields have different types of data (and in my case Section Headers where we should not do anything for). I used a "switch" and a "asTypeItem" to do the trick but if anybody got a better suggestion, I'm ...


1

Including a question of type Date in New Sheets and checking include year results in something like this:



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