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.
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.
> Create record in Airtable on Google Form Submission
Create record on Form Submit
Setting up Airtable in Form Director
- Choose Airtable from the list of apps
- Name your service
- Choose Create record under services
You need to configure three main elements
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 is required to connect to your table
To Get Table Url
- Click on the base you need to send Form response
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
Steps for mapping from field with Slack 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
You can see a new record in your Airtable