Airtable is a cloud-based platform designed for creating and sharing relational databases. Its user-friendly interface enables anyone to easily set up a database. With Airtable, you can store, organize, and collaborate on information for any purpose. It put togethers conventional spreadsheet with the robust features of a database with no coding required. Airtable is a multi-purpose tool which can be used for Content Management, manage CRMs and Tracking projects.

This article provides you an overview to get started with the Airtable connector in Peliqan. Please contact support if you have any additional questions or remarks.

Contents

Terminology

  1. Bases : database to store all the information needed for the project. It can be blank or template based where templates(with data) are pre-generated by Airtable. Number of Bases can be created
  2. Tables : A table holds information about one type of item(entity) like products, projects, tasks, campaigns. Each base needs to have atleast one table. A new table can be added or imported from an existing table in another databases.
  3. Fields : It is a column in the table which brings consistency to the data and defines details of data present in a table. Field can contain a variety of data and can be casted into other by editing the field.
  4. Records : unique ****row in a table. records can be made connected among each other from different tables through link .
  5. Views : A view is a particular way to look at and organise the underlying data in a table. A single table can have mutliple views like form, calendar, gallery, Kanban, etc but default being Grid. Users can create their own custom view which might have its won requirement.

Generate API Token

  1. Create an account on Airtable on https://www.airtable.com/. If account already exist perform Sign-In.

  2. Once Logged in, navigate to profile at top-right and then to Developer Hub.

    Untitled

  3. Choose "Personal Access Tokens" from left pane under Developers, and then select the "Create Access token" button on the right of the page.

  4. Provide a unique name and add data.records:read, data.records:write, schema.bases:read, schema.bases:write and user.email:read as Scopes.

  5. For Access to WorkSpaces and Bases, choose All Workspaces Option.

    Untitled

  6. Click on “Create Token” button to create an API Access Token

Get Base ID