Airtable

What is Form Director?

Form Director is a G Suite 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 G Suite Marketplace and Chrome Web Store. Please check installation instructions to install the add-on.

What is Airtable?

Airtable is the all-in-one collaboration platform.

Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.

Use Case(s)

> Create record in Airtable on Google Form Submission

Google Forms

Create record on Form Submit

Form Director

Airtable

Setting up Airtable in Form Director


  • Choose Airtable from the list of apps
  • Name your service
  • Choose Create record under services

Configuring Airtable

You need to configure three main elements

API Key

Airtable uses Api-key authorization to connect to your account.

To Generate Api-Key

  • Once Key is Generated copy and paste it in Key placeholder

Table Url

Table Url is required to connect to your table

To Get Table Url

  • Click on the base you need to send Form response

Fields

Fields are the table headers, Airbase doesn't have a direct way of getting table headers so you need to enter your required table headers.

Enter the headers comma separated in Fields text box and click on Check app fields


In the above picture Name,Age,Father Name,Date Of Birth are the Fields

Mapping

Steps for mapping from field with Air table fields

  • Click on setup mapping
  • Choose the form field
  • choose the app field
  • click save

Finish setting up

  • Save service

You are all set to send form data to Airtable on your Google Form submission

Submit the Form

Submit the Google Form

See Airtable

You can see a new record in your Airtable