This video will show you how data from different spreadsheet can be merged into one table without having to enter information individually (and manually).

This video will show you how to create a web form that populates a spreadsheet automatically. Bear in mind that if people complete the form it will create a new record, so it can lead to duplications.  If you do not want data duplicated you can create a new table and then merge data with an existing database as shown in the previous video.

This video will show you how you can create certificates en mass at the click of a button.  You can create multiple personalised certificates at the same time without having to manually create each one.  You can also use this principle to customise any kind of document like a contract or consent form if you hae created the template for it using a programme called formstack.

This video will show you how to send an Airtables email from a list that you have filtered and sorted.  Before you do, make sure that an airtable email is the correct form of communication.  You must bear in mind that 

1. You cannot include attachements in this email. If you want to do this you need to look at the ‘automations’ video which appears next in this training module.  

2. You cannot use photos and images in the email.

3. You must feel confident that there are no duplications in your email list.  If there are 2 or more similar records then the email will be sent to those records individually, resulting in 2 or more of the same email going to the same person.  If you want to remove duplications first, then use the campaign software to filter your list, and send a campaign.  Or you can use the campaign software to remove duplicates, download the subscriber list and import them onto a new airtables spreadsheet and send you email via airtables.

So what are the benefits of using an airtables email?

1. It’s quick an easy – no need to use the email campaign software and design complex looking emails first.

2. It is more reliable.  These emails are most likely to reach their destinations compared to email sent by the email campaign software or even your Gmail account!

This video will show you how to use automations in airtables.  Automations will help you to send an email with an attachment in a personalised way.  This will save you time so that you are no sending one email at a time with an attachment.  Please remember to watch this video every time you attempt an automation because it can be a bit tricky!