Tag Info

Hot answers tagged

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.


3

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


3

The problem was due to Google Forms adding a new row every time. If you are having the same problem here's what you need to do to fix it: Where you previously had your formula change it to: =arrayformula('YOUR SHEET NAME'!A2:A) Change the sheet name, and enter the cell you want to target, as-well as the column. Make sure you delete all other formulas ...


3

No, there's no way. Google's help says Please note that while users will be asked to log in to their Google Account in order to access and fill out the form, their actual usernames will not be recorded. Some alternative approaches (taken from here): You could make completing the form "inviation only" and email people a unique code that they have ...


3

I do not think that Google Forms has any feature like that. One option might be to ask respondents for their email address (or some other identifier) and only to accept the first entry (ie the one with the minimum date/time) each day.


3

Step 1: Open the form. Step 2: Click on "Responses" from toolbar. Step 3: Click on "Change response destination". Step 4: If you want to save responses in existing spreadsheet with a new sheet, choose "New sheet in an existing spreadsheet" or if you want to save responses to a new spreadsheet choose "New Spreadsheet" and "Type the name" for new ...


3

There's a defect listed on the Google Apps Script issue tracker. We'll have to wait it out to see when a project member responds to it, I'm assuming.


2

Short answer Google Forms doesn't include a limit on the number of responses as built-in feature but you could extend the of Google Docs editors features though add-ons or Google Apps Script. Alternatives formLimiter From: https://sites.google.com/a/newvisions.org/scripts_resources/add-ons/formlimiter formLimiter automatically sets Google Forms to ...


2

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


2

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


2

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


2

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.


2

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() == "") { ...


2

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


2

I would copy the list from http://www.listofcountriesoftheworld.com/ and paste it in a sheet. Then I would use the add-on formRanger to fill the question with the content of that column with names.


2

If you're willing to install an extension, the Form Values extension should help you here. From the description in the Add On store: Do you find yourself regularly typing the same choices in for multiple choice, list or check box questions when creating forms? Form Values allows you to store and use lists that you use regularly in forms. This ...


2

Just copy paste the following in your Google forms. The form dialog automatically creates new items when the pasted text contains linebreaks. The following list is posted so that the future readers do not need to remove the numbers from the list provided by listofcountriesoftheworld.com. Editor's note: the list below may go out of date as countries are ...


2

There is no way to dynamically change the confirmation/thank you message. However, you could use the Autocrat add-on (or adapt its code) to send your customers a confirmation email with the reference number.


2

Your Google Form decides which column to store the data in - you do not control this. And the design you're aiming for (different weeks data in different columns) is likely to cause long term problems. But there is a better approach: In general, the first column in the sheet which it stores data in is labelled Timestamp, and contains the date/time when ...


1

Short answer Google Forms doesn't have such feature and can't be extended through add-ons or Google Apps Script. Alternatives Instead of a single form, create a form for each required combination a web app


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

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

The absolute simplest approach is to just put StoreNumber onto the form, and ask people to complete the form once for each store that they own. This is the easiest way to deal with the fact that they may own different numbers, eg one may have two, another four.


1

This happens because your Google Sheets is linked to a Google Form. When you copy the sheet you also copy the form. You can create a new (not a copy) Google Sheet and copy the content from your old Google Sheet to it. Copying this new sheet will not create a new form. Please be more clear about the auto-creation feature you are talking about.


1

I have just hit this problem, it's really annoying and there is no way I'm going to do it manually. Luckily I thought of this before I sent the form out, if you already have responses then this won't help (unless you send it out again). To solve this problem I have: Set the question type to "Text" Under "Advanced Settings" I have selected "Regular ...


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

I think I found a solution based on the INDIRECT formula. Assuming to have the spreadsheet "Responses" with the raw inputs from the form, and the spreadsheet "Processing" to rework the answers, you have to create a third spreadsheet "References". This third spreadsheet will contain, as plain text, the references you need. For example, you could create a ...


1

EDIT to include the essential information from the link, original answer here at bottom. The first two methods do not solve my problem, as cells referred to in formula continue to update the reference as extra records are added from the form. Method 3 answers my problem as specified in the question.... Method 1: Duplicate the sheet. Click on the little ...


1

It looks like this issue is due to a bug in the new Google Sheets, but you can use this simple script as a workaround. In your sheet, go to Tools > Script Editor. Erase the existing code in Code.gs and add this instead: function setCellAlign(range, alignment) { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheets()[0]; var ...



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