Tag Info

Hot answers tagged

5

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.


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


2

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


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

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

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

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

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


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

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


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

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

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

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

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

Maybe this has changed in new Google Sheets because in the second and subsequent Forms it seems possible to select Responses, Choose response destination: New sheet in an existing spreadsheet..., Choose: find the Response Sheet for the first Form, Select and for this to work.


1

Instead of using a script, consider to add the responses to another sheet using formulas and there add the three columns. It's worth to say that Today() column will be updated when the recalculation occurs. I.E. Adding a column with the formula =Today() to the responses of a form add the following formula to A1 in a new sheet: =ArrayFormula( { ...


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

It's just a matter of pasting the iframe code. The following <iframe src="https://docs.google.com/forms/d/DOC-ID/viewform?embedded=true" width="760" height="500" frameborder="0" marginheight="0" marginwidth="0">Loading...</iframe> is converted to this after saving the post [googleapps domain="docs" dir="forms/d/DOC-ID/viewform" ...



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