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


3

Maybe set your first question as Multiple choice and check Go to page based on answer. Offer No with Continue to page 2 and Yes with Go to page 3, with the first question on page 3 being something like "Please provide details of your existing Dental school Program" and a Paragraph text Question Type.


2

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


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

Where it shows "Option 1" overwrite with text of your choice, and so on for any others:


2

Correct - Google Forms utilizes Google Spreadsheets to store their data, so you are restricted to the limits imposed on Spreadsheets. EDIT: As Jacob pointed out, these limits only apply to old Google Spreadsheets. All limits have been removed in the new version. All spreadsheet limits mentioned above have been removed in the new version of Google ...


1

You can do this using the copyDown add-on by filling in the right formula in line 2. You can find the copyDown add-on here: https://chrome.google.com/webstore/detail/copydown/lipbbdpmkcbplmfnbholpabinnnkbbda


1

You can go to Tools -> Script editor, copy the code and paste it inside the Script editor of your other form.


1

Share the spreadsheet which holds form responses in view mode. They can make a copy of the spreadsheet which will also copy the form for them.


1

The link you still have, contains the ID of the form you created. Building the following URL will bring you to the original form in edit modus. https://docs.google.com/a/<yourdomainname>/forms/d/<yourformid>/edit If you select from the menu Responses(?) > View responses, then it will lead you to the corresponding Google Spreadsheet. Tried ...


1

One option is to use Google Forms validation tools - not as much control, but far easier than a script. They're under Advanced Settings for a text field. The picture below is looking for any 11-digit number, but you could make it more specific eg between 09000000000 and 100000000000.


1

According to Ted J 18/12/2013 the answer is: Currently, we can't time a quiz per se using Google Apps Script. However, you can do a few things like limit how many responses a Form can take or put a hard stop time on the Form. However, there is a free Add-on: I would envisage some inherent problems with any timer due to differences in download ...


1

It would be very far from ideal, but the account number might be entered on a 0-9 Scale for each digit and then reassembled in the responses sheet with the likes of =C3&D3.


1

There is no way that the Form can resolve the issue for previously entered response - it has taken the input value and saved it as a number, meaning the leading values are lost, ie the sheet doesn't know if they were there or not. You will have to fix them manually. What happens if you format the column in the responses spreadsheet as text? Do ...


1

In my experience, if you duplicate the question you want to move, you can drag the duplicate copy of the question to the other page (and then delete the original question).


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

@Salina, Google doesn't currently support this feature - there is no way to save a form and have a user return to it later without submitting it. That does raise an interesting point, though. You can have the user submit the survey and edit their responses later. Instead of forcing the user to page through the rest of the survey to get to the submit button, ...


1

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


1

I'm considering Problem two as off topic here but for Problem One please try something like: =query(importrange("https://docs.google.com/spreadsheets/d/$$$$","Applicant Form Response!A:H"),"Select * order by Col1 desc limit 5") where $$$$ is the rest of the URL for your Responses sheet.


1

This can be done without the need of 3rd party apps by using Google App Scripts. Just to give you an idea the procedure would be: Create a Form in Google Forms and email it to yourself Get the HTML from that email and copy it to your clipboard Create a new Google App script with the following code: function sendFormEmail() { var emailAddress = ...


1

There is a Google Forms add-on called Form Values which at least offers a semi-automatic way: whenever you change your answers in the spreadsheet you need to manually re-populate the choices in your answer, but at least it's rather straightforward to do.


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:


1

This is a derivative of the other answers but it might be useful for future users. function onEdit(e) { var sheet = SpreadsheetApp.getActiveSheet(); var row = SpreadsheetApp.getActiveSheet().getActiveCell().getRow(); var bugCount = sheet.getRange("M2").getValue(); bugCount++; if (sheet.getRange(row, 1).getValue() == "") { ...



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