I want to learn about Airtable but there are no resources!

Printed materials have definitely fallen out of favor — both in society at large and especially for learning web apps.

My free Airtable training course has been a huge & growing success for LinkedIn, which is a testament to how much people want interactive video training tutorials.

However, @JonathanBowen wrote 2 Kindle books on learning Airtable — can you print out Kindle books as PDF’s? I’m not sure if that’s a thing or not. See links below:

Welcome to the Airtable community!

Then you already know a lot of concepts that apply, such as normalizing data. However there are also things about Airtable that are going to frustrate you, such as

• how linked records works
• how the primary field is used, but is not a primary key or foreign key
• record limits
• lack of a written querying language

Having more screen real estate helps a lot. Some people have large monitors or second monitors, which are useful in other areas as well. I also use my tablet to display reference info as well.

You can print support pages, although the formatting will be a bit funky. It is unlikely that Airtable will ever provide pdf manuals. PDF files are much harder to maintain, and Airtable is constantly adding features, adjusting documentation, tweaking the user interface, etc.

Dear ScottWord,
Many thanks for your links, which will prove very useful. I will certainly check them out.

However, the other response from Kuovonne has dampened my ardour somewhat. Please see my response to that post.

Thanks, Geoff

Dear Kuovonne,
Thank you for your useful comments. I am immediately concerned that there is no query language. That is suggesting that Airtable can be no more than a simple relational database (even that is sounding doubtful if primary keys and foreign keys are not used in the accepted sense)?

Is there no scripting of any kind? What is a linked record, if not a foreign key to another table?

Many thanks for taking the time to respond and providing an insight.

Regards,
Geoff

There is scripting, but it is done using JavaScript. You can do a lot with the data with scripting, but it requires a different way of thinking about the data.

Linked records are a bit like foreign keys, but all links must be explicitly made either manually, through scripting, or through automations. You cannot join using any field. There are keys, but they are under the hood and not exposed to the user unless you use a formula field that exposes the record ID. There is also no easy way to enforce uniqueness in any field, except an autonumber field.

You can pull data from other tables using linked record fields and lookups/rollups. You should really play around with linked records and lookups/rollups to see what I mean.

Airtable has many other quirks, but understanding linked records is key to understanding Airtable, and linked records do not behave the way linking works in traditional databases.