Database

Google Forms + Database Integration

Create record in any Database table on Google Form Submission.

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.


Now, you are all set to store data into your Database