Under construction!

As we are finalizing some aspects of the system the documentation is being updated to reflect the changes. We appreciate your patience!


Building Data in Airtable

Creating Tables & Importing Data

When using Airconnex you're free to design any database you need according to your business requirements and workflows. To do this you will be using Airtable. For new Airtable users this video will explain some very basic steps to building creating tables and importing existing data from CSV files.

Attachments, Files & Media

Airtable is amazing in its ability to attach files directly to records. However it can be a bit frustrating to manage. We find ourselves having to reupload files if attachments are accidentally removed. A recommended practice it to use one table for all the media, and link to the records instead of attaching them directly. That way, only the link is removed (not the file) and can be reinstated easily.

Important : Linked Fields

You can use linked fields to create relationships between fields in different tables, such as categories and products. Although the linked field will show you a text value, this is not actually the value saved in the field. The real value is a record id, so that links can work even if two records have the same name, or the name changes. It's very important to keep this in mind whenever working with linked field values.

Linked Categories

The most conventional way to categorize data in a table is to create a linked field with the list of categories. This method provides various benefits and best suits larger datasets such as product feeds.

Kanban Categories

In some cases data is more difficult to categorize because the categories need to be made on the fly, and balanced depending on how many and which items are in each. In these cases using a Kanban view can be very helpful to speed up the process.

User Tables

Because you can build your own tables and fields directly in airtable, the approach to user tables can be much more flexible than other systems. Take advantage of this flexibility by creating different tables for each user type, rather than a single table with a mix of fields.

Connecting & Syncing

Syncing your Data

Before you start building, you need to connect and syncronize your database tables with airconnex. You can also connect tables from multiple different bases. To do this just visit the admin menu and add a connection, then follow the prompts.

Quick Syncing

Once changes are made within Airtable you may want to resyncronize your data into Airconnex. This can be done in various places, but the easiest is to click on the admin menu and use the small sync buttons next to each connection.

Filtered, Hidden & Empty Values

Three aspects of syncing data from airtable that you need to understand to avoid confustion relate to filtered, hidden and empty fields. Any records filtered from a view, or that do not contain any value (empty) will not be imported. Fields that are hidden are still imported.

Managing User Accounts

User tables are syncronized the same as other connections, but have an additional management interface for managing the accounts and passwords, and viewing recent logins etc.

Pages & Dynamic Pages

Planning your Website

It's much easier to build pages from the ground up than to change them, so we strongly recommend you map out your project in a diagram application like whimsical or miro before you begin. Below you can find a link to images for each Airconnex block type, which you can use to create a quick diagram of your site. You should also consider the url structure and how users will navigate your site.

Creating 'Normal' Pages

Top level pages such at the homepage, contact, etc without any dynamic data would be considered 'normal' pages. These pages can be added from the admin menu, using a simple form and links to these pages can be added in the menu and footer.

Editing 'Normal' Pages

To edit a new page, there will be a prompt in the middle of the page. You can also access the editor from the admin menu. The editing system is a modified WordPress Block editor, so it should be familiar to most wordpress users of later versions.

Creating Dynamic Pages

Before a page can be dynamic, there must be some way for the user to navigate to it – this is done with a Loop Block. Within the loop block, just add a dynamic page then publish the loop and visit any page. You will see a prompt to confirm the page is dynamic, and then you can begin editing the page using dynamic data.

Editing Dynamic Pages

To edit a dynamic page, first visit the page – then click on any of the 'edit' links (on the page, in the buttons at the bottom right of screen or in the admin menu). Once inside the editor, you will find dynamic page values inside the Airconnex Data menu. Click to copy these values and paste them inside Airconnex block, or anywhere on the page.

User / Login Pages

By adding a login block to any page, you can limit access until a user from a specific table has authenticated themselves. Users can get passwords on signup if you have passwords set to issue automatically, or you can issue passwords to your users from the connection > user management page.

Categories

Linked Category Pages

By far the best method for creating categories which also allows multi-tiered category systems – is to use linked fields. Once you have created the structure in Airtable, you can replicated it in Airconnex using a combination of loops and dynamic pages.

Keyword Categories

A method for categorizing data that's very useful for specific circumstances is to use a keyword system. This is especially useful when you dont have the categories in the same base as the content you want to filter, or you have too much data to categorize using a 'select' method.

Loops & Blocks

Hero Blocks

The hero block can be used at the top of a page to provide a large section to visually orient the visitor on the content below.

Loops

The loop block displays multiple records on a single page. The loop can show all the records in the table, a limited number, or be filtered by values. Each record in the loop can link to a dynamic page, or to an external url.

Video (MP4) Loops

You can use airtable to host and stream MP4 video files, and present them on your Airconnex website for people to watch. Of course, you can see this in action right here on this page. Click the video to see how it's done.

Icon Loops

As well as SVG icons (which work like normal images) you can use text icons from the Fontawesome libary. Just visit fontawesome, choose the icon you want to use and copy the html value into an airtable text field. After you sync in the values you can use them in the image field of the loop to display icons.

Forms

Adding Records

To add a record to a table just use the most basic for configuration 'Add Record' and choose which connection to add the record to. Once a record is added it will also be syncronized into Airconnex automatically.

Editing Records

On dynamic pages, you can use 'edit record' forms to update values for the record connected to the page. Using this method, and the 'redirect after submit' option you can build multi-page forms and complex workflows.

User Account Forms

Similar to dynamic pages, any page where a user is logged in will enable you to create a form that edits the users' record in airtable and instantly syncronize the data back in again. This type of form is great for user profiles and portals for users to manage their own data.

Signup Forms

To let users add themselves to your airtable data – use the Signup form. This works just like the 'add record' form but with a few extra options to handle the workflows after the form is submitted. You can choose to send the user a password immediately, or manually review and send later. You can also choose whether the user should be automatically logged in after signing up.

Front End / Article Editor

The front end editor allows you to easily create article editing systems that syncronize directly with airtable, and even contain inline images and html tags.

Sections

Sections & Styles

Every block in Airconnex has a configuration tab for the Section it is inside. You can add styles, text, background images and colors, and even use conditional logic to hide sections based on dynamic values.

Project Guides

Learn from some interesting example projects our team have completed.

Ecommerce Website

Blogging System

Datafeed (CSV) Website

Single Product Website

Travel Blog

Multivendor Marketplace

Training Course

Page Guides

Learn how to build some common (and not so common) page layouts using Airconnex Blocks.