8/27/2021»»Friday

Airtable C#

8/27/2021
    14 - Comments
  1. Airtable Sdk
  2. Airtable Github
  3. Airtable Survey
  4. Airtable Form To Edit Record
  5. Airtable Forms Prefill
  6. Air Table Spreadsheet
  7. Airtable Notes

To pay for an upgraded workspace with Airtable c redits, the credits first have to be applied to that workspace that is on a Plus or Pro plan. Open account page. You can apply credits to a workspace by going to your account page, and then clicking into that workspace's settings page in the left sidebar. Transfer credits to a workspace. Dynamic Airtable Metadata Discovery. Our Airtable Connector delivers metadata information based on established standards that allow Tableau to identify data fields as text, numerical, location, date/time data, and more, to help BI tools generate meaningful charts and reports.

What this scenario does: Retrieves attachments from emails and uploads them to Airtable.

Level Of Difficulty: Intermediate

Implementation Time: Approximately 15 mins

Prerequisites: A Google and an Airtable account with all connections added. Familiarity with the functions of an Array Aggregator.

Airtable Sdk

If you’re uploading attachments to Airtable, you’re probably uploading a single attachment to a record resulting in numerous unnecessary records. Let us show you how to retrieve and upload multiple attachments to a single record instead. Let’s begin.

The scenario consists of the following modules:

  • Gmail > Watch email
  • Gmail > Iterate attachments
  • Google Drive > Upload a file
  • Array Aggregator
  • Airtable > Create a record
Airtable notesAirtable

Here’s the scenario:

Airtable Github

Let’s open the Gmail > Watch emails module to configure it. Select the Folder that you want to watch as well as the Criteria. Then enter the Maximum number of results that will be returned during one execution:

Airtable

Airtable Survey

Next is the Gmail > Iterate attachments module that separates the attachments in order for each attachment to be uploaded to Google Drive. Once added, the Source Module will be automatically selected since there is only one preceding module:

Moving on to the Google Drive > Upload a file module and as the name suggests, the attachments retrieved from the emails are uploaded to Google Drive using this module. Select the Destination Drive, Target folder and the Gmail > Iterate attachments as the Source file:

Air table c# example

Following the Google Drive module is the Array Aggregator which combines the attachments into an array in order to upload them to Airtable as a single bundle instead of individually.

*It’s important to note here that you will need to add the Airtable > Create a record module first before configuring the Array Aggregator for it to be a selectable option under the Target structure type.*

Under Source Module, select the Gmail > Iterate attachments module. Another device is using my ip address. Under Target structure type, select the Airtable > Create a record: Records attachment:

In the File URL field, map the Direct download link element outputted by the Google Drive module and in the File name field, map the File name element outputted by the Gmail > Iterate attachments module. If you would like to capitalize the file name, use the capitalize function found under the Text and Binary functions tab:

Last in the scenario is the Airtable > Create a record module. First select your Base, then map the Subject element (or whichever name you want) outputted by the Gmail > Watch emails module to the Name field and map the Array element to the Attachments field:

All done! Let’s go ahead and execute the scenario.

Airtable Form To Edit Record

Scenario execution:

Airtable Forms Prefill

The scenario executed successfully and an email was retrieved containing 3 attachments that were iterated and uploaded to Google Drive. The attachments were then aggregated and sent to Airtable:

Airtable

Here’s the record created in Airtable:

Air Table Spreadsheet

Quite easy right? Hope you found this tutorial useful.

Airtable Notes

Happy Automating! 🙌