• Documentation >
• Apps >
• Surveys and Forms >
• Google Forms

Google Forms

Getting Started with Google Forms

The Google Forms modules allow you to monitor, search, add, update, or delete responses on your Google Forms.

To upgrade to a new version of the Google Forms app, you need to upgrade all modules manually by Replacing Legacy Modules with New Modules.

Prerequisites

• A Google account

• A Google Spreadsheet from the corresponding form created

In order to use Google Forms with Ibexa Connect, it is necessary to have a Google account. If you do not have one, you can create a Google account at docs.google.com/forms/.

Module dialog fields that are displayed in bold (in the Ibexa Connect , not in this documentation article) are mandatory!

Connecting Google Forms to Ibexa Connect

To connect your Google account to Ibexa Connect follow the general instructions for Connecting to services.

After you click the Continue button, Ibexa Connect will redirect you to the Google Forms website where you will be prompted to grant Ibexa Connect access to your account.

Confirm the dialog by clicking the Allow button.

To work with your form responses, there must be a spreadsheet created from your responses.

Creating a Spreadsheet from the Form

1. Open your form.

2. Go to the Responses tab.

3. Click on the Create Spreadsheet button.

4. The spreadsheet is created from the form and you can now proceed to work with your form responses in Ibexa Connect.

Triggers

Watch Responses

Watches a form for new responses.

Spreadsheet	Select the form you want to watch for new responses.
Sheet	Select the sheet that contains the form responses.
Row with headers	Specify the header row of the table. Default is A1:Z1.
Value render option	Select how values should be represented in the output. Formatted value Values will be calculated & formatted in the reply according to the cell's formatting. Formatting is based on the spreadsheet's locale, not the requesting user's locale. For example, if A1 is 1. 23 and A2 is =A1 and formatted as currency, then A2 will return "$1. 23" . Unformatted value Values will be calculated, but not formatted in the reply. For example, if A1 is 1. 23 and A2 is =A1 and formatted as currency, then A2 will return the number 1. 23 . Formula Values will not be calculated. The reply will include the formulas. For example, if A1 is 1. 23 and A2 is =A1 and formatted as currency, then A2 will return "=A1".
Date and time render option	Specifies how dates, times, and duration should be represented in the output. This is ignored if Value render option (above) is set to Formatted value. The default Serial number.
Limit	Set the maximum number of responses that Ibexa Connect will return during one cycle.

Actions

Add a Response

Adds a form response to the bottom of the sheet's table.

Spreadsheet

Select the form that contains the sheet you want to add a response to.

Sheet

Select the sheet with form responses you want to append a new response to.

Sheet columns

Enter the desired values to the sheet columns.

For the Timestamp column in the correct format, use the following value:

formatDate(now;DD/MM/YYYY HH:mm;UTC)

Value input option

Specify how input data should be interpreted.

Raw	The values the user has entered will not be parsed and will be stored as-is.
User entered	The values will be parsed as if the user typed them into the UI. Numbers will remain numbers, but strings may be converted to numbers, dates, etc. following the same rules that are applied when entering text into a cell via the Google Sheets UI.

Insert data option

Specify how existing data is changed when new data is input.

Overwrite	The new data overwrites existing data in the areas where it is written. (Note: adding data to the end of the sheet will still insert new rows or columns so the data can be written.)
Insert rows	Rows are inserted for the new data.

Update a Response

Changes a selected response.

Spreadsheet	Select the form you want to update the response for.
Sheet	Select the sheet that contains the form responses.
Row number	Enter the number of the row that contains the response you want to change.
Values	Enter the new values to the desired columns.
Value input option	Specify how existing data is changed when new data is input. Raw The values the user has entered will not be parsed and will be stored as-is. User entered The values will be parsed as if the user typed them into the UI. Numbers will remain numbers, but strings may be converted to numbers, dates, etc. following the same rules that are applied when entering text into a cell via the Google Sheets UI.

Delete a Response

Deletes a selected response.

Spreadsheet	Select the form you want to delete a response from.
Sheet	Select the sheet that contains the form responses.
Row number	Enter the number of the row that contains the response you want to change.

Searches

Search Responses

Retrieves a list of the responses by specified filter settings.

Spreadsheet	Select the form you want to search in.
Sheet	Select the sheet that contains the form responses.
Order By	Select the sort order.
Column range	Select the column range you want to search.
Filter	Define the filter to filter returned responses by.
Sort Order	Select whether to sort returned responses in ascending or descending order.
Order By	Select the column you want to order returned responses by.
Value render option	Select how values should be represented in the output. Formatted value Values will be calculated & formatted in the reply according to the cell's formatting. Formatting is based on the spreadsheet's locale, not the requesting user's locale. For example, if A1 is 1. 23 and A2 is =A1 and formatted as currency, then A2 will return "$1. 23" . Unformatted value Values will be calculated, but not formatted in the reply. For example, if A1 is 1. 23 and A2 is =A1 and formatted as currency, then A2 will return the number 1. 23 . Formula Values will not be calculated. The reply will include the formulas. For example, if A1 is 1. 23 and A2 is =A1 and formatted as currency, then A2 will return "=A1".
Date and time render option	Specifies how dates, times, and duration should be represented in the output. This is ignored if Value render option (above) is set to Formatted value. The default Serial number.
Maximum number of returned responses	Set the maximum number of responses Ibexa Connect will return during one execution cycle.

Search Responses (advanced)

Performs a search using the Google Charts Query Language.

Spreadsheet	Select the form you want to search in.
Sheet	Select the sheet that contains the form responses.
Filter	Define the search query using the Google Charts Query Language. E.g. select * where C = "John" to retrieve all values for the row where the C column is "John".
Maximum number of returned rows	Set the maximum number of responses Ibexa Connect will return during one execution cycle.

Changelog for Google Forms App

last update: 2020-08-31

New modules:

• Search Responses

• Search Responses (Advanced)

Deprecated modules:

• Select Responses Search Responses (Advanced)*

Deprecated modules:

• Select Responses