Database
Google Forms + Database Integration
Create record in any Database table on Google Form Submission.
How to integrate your Google Form with Database?
You can integrate Google Forms with Databases using Form Director. Form Director enables you to connect Google Forms with Databases like MySQL, Datastore MongoDB, etc. allowing you to create any record in these Database tables based on form responses. When a user submits a Google Form, the responses are automatically sent to the preferred databases.
What is Form Director?
Form Director is a Google Workspace add-on that directs data submitted from Google Forms to applications like Google Docs, Forms, Sheets, Contacts, Calendar, Tasks, Email, Trello, Slack, QuickBooks etc.
Installation:
It is available in the Google workspace Marketplace.
Please check installation instructions to install the add-on.
What is Database?
A database is a data structure that stores organized information. Most databases contain multiple tables, which may each include several different fields
Google Forms to Database: Use Case(s)
> Create Record or Document on Database Tables/ Collections
e.g. Create Customers, Orders, Tickets, Invoices, Payments, and literally anything on your Database table by submitting Google Form
Google Forms
Create Record/Document on Form Submit
Form Director
Database
Demo Video: How to create record on Database Table from Google Forms?
Supported Databases
The currently supported databases are classified into two categories
Standard Databases
Premium Databases
Standard Databases
Connect with MySQL and create record on table from Google Form Response
Connect with MS SQL and create record on table from Google Form Response
Connect with Oracle and create record on table from Google Form Response
Connect Cloud SQL and create record on table from Google Form Response
Connect with Cloud Firestore, and create document on collection from Google Form Response
Connect with Cloud Datastore and create entity on kind from Google Form Response
Premium Databases
Setting up service
Name your Service.
Select the Application as Database.
Select the service as Create Record.
Creating new Database connection
Create a database connection.
You can create a new database connection on clicking on "Create new connection".
Provide Details such as connection name, database type, host name, database name, user name and password.
you can test your Database connection by clicking on "Test Now".
On successful connection it displays "Connection tested successfully".
On failure connection it displays error message.
SELECTING DATABASE AND ITS TABLES
Once you have a connection you can select the connection.
Click on the "+" icon to create more new connections.
Click on the edit icon to edit the connection as required.
Click the dropdown to select the saved connections.
Selecting a connection will connect you to the database.
On a successful connection, the list of tables in the database gets shown.
You can select a table in which your form data to be stored.
Note: Users can create any number of connections and use it across services in Form Director.
Setup Mapping
Click Setup Mapping and setup the mapping.
Mapping of form fields to that of Document fields is to be done in order to create record with your form data.
Click on the add icon to add new mapping.
Once you have done mapping you can save the service.
Note : Mapping should be done between app field and form field of same type.
Notification
Notify your audience with success or error notifications.
Switch on Send Email to send email during execution.
Email Template
Send your own customized emails on form submission to your audience.
Attachment
Select the attachment to email from file upload in Google Form.
Click Pick Drive Files to attach files to Email.
Finish Setting Up
Save service
You are all set to create record on your Google Form submission.
Submit Google Form
Boom! you get a new record (doc/ entity) on your database in a few seconds.
