Quick Overview

magic_tables can be synced with a tables of a base in Airtable. This allows you to use Decisional to upload sources and generate a magic_table which can then be synced with a corresponding table in airtable.

Here is how you can sync your magic_table to a table in Airtable.

Open the Magic Table

Open the knowledge_engine that holds the magic_table that you would like to have synced, open this the the workspace.

Go to Manage Columns and add an Airtable token

Click on the in the top right of the magic_table you will find the option to “Manage Columns” click on this and then select the “Connectors” tab. This will allow you to choose an option to fill in your Airtable personal access token and click on the “Connect to Airtable” button (you can create the token here in Airtable; you need to remember to provide the right scope and access to tables)

Configure the column mappings

Now you must choose the appropriate Airtable “Base” and “Table” from the drop downs. Once you have selected those, map each column in the magic_table to the column in the Airtable “Table”. After you are donw with the mappings click on the “Update Mappings Button”

Column Mappings must have the same type on Decisional as it is in Airtable or it will lead an inconsistent column mapping. Additionally, linked records type of column mappings need to be configured to the right linked record table. These are populated as single select fields and are updated every 15 mins.

Sync with Airtable

Now that the Airtable columns, table and base is mapped, you can click on the “Sync Airtable” button found on the bottom right corner of the magic_table

State Visibility of the Cell Values

During the syncing process, each cell will start showing a line on the right hand side of each cell. As the the syncing takes place, each cell will be going through the following states:

  • GREY - the cell value is mapped but not picked up for processing yet
  • YELLOW - the cell value is mapped and has been picked up for processing
  • GREEN - the cell value is synced to the corresponding cell value in Airtable