Airtable is a powerful web based spreadsheet/database hybrid, with an easy to use interface. It's ideal for when you want to store, manage, update and review complex data, without the hassles of running your own database.
Converse's Airtable integration allows you to easily build workflows that can retrieve, search and even update database records held in Airtable, all without writing any code.
You'll need an existing Airtable account to integrate with, if you don't have one, you can signup here
Once you have your account, and created your first table, from the main Converse Dashboard, go into 'Plugins' and search for 'Airtable', and select it.
You will need to then enter your API Key, App Name, and the name of the table.
TIP, you can get these from the Airtable UI.
Finding the Airtable App ID
The App ID is not easy to find.
When logged into your table in Airtable, click the '?' in the top right corner, and then 'API Documentation'.
The URL will then look something like:
The App ID in this case is: appvIBOZikcSH672x
With the plugin configured, you now have a few different modules you can use, depending on your use case.
This enables you to retrieve a list of matching records, and the selection of relevant fields from those records that you require.
You can set filter the results by setting one or more filters to check against the values of the records.
The records are returned as an array inside an object called 'results'.
If you know the ID of the individual record you want to retrieve, you can request an individual record using this module.
If you want to create a new record in a table, you can do so using this module, specifying the field names and the data for them as required.
If you want to update an existing record, and you know it's ID, you can do this using this module
NB: At this time you can only overwrite a record completely, not just update it partially.
If you want to delete an existing record, and you know it's ID, you can do this using this module.
For most Modules there are advanced options to limit and sort results, and to override the default table, if using a different table within the Airtable app.