Jul 26, 2022 08:14 AM
I am an old school database developer and have recently discovered Airtable. I am intrigued and have signed up for the free account to try to discover what it’s about and how it all fits together.
However, I am gobsmacked that there appears to be no downloads available to study Airtable. I am unable to learn from a screen. Whenever I teach myself new skills I do it by pouring over reference manuals and experimenting - that’s the way I learn.
I simply cannot concentrate when some is spouting information at me in a webinar or a training video, clicking on various things instructing you to do this and that with out learning the REASON and UNDERLYING logic behind what you are doing. I also cannot read from the guides displayed onscreen, mainly because you have to keep swapping form the guide to your workspace trying to copy the examples. What I need is a printed manual I can learn from. I am not asking Airtable to provide printed manuals, just PDFs that I can download and print myself.
Does anyone have a view on this?
Jul 26, 2022 09:52 AM
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:
Jul 26, 2022 09:00 PM
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
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.
Jul 27, 2022 02:32 AM
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.
Jul 27, 2022 02:38 AM
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.
Jul 27, 2022 04:41 AM
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.