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

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.


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

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

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


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

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


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

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

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

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

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

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

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


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

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

A stab in the dark (but OP seems unlikely to revisit in the near future to provide clarification of the requirement): =indirect("'Form Responses'!"&"A4")


1

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


1

Whether or not this is practical may depend on the formulae you are using (which you don’t show) but for something very simple like =Sum(A1:B2) you might switch to View, All formulae and replace ( with ($ and : with :$. Then transpose, repeat the process and transpose back. Otherwise “Search using regular expressions” may help.


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



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