vortisales.blogg.se - Airtable tutorial

Airtable tutorial how to#

Airtable has numerous templates to choose from, but for this tutorial we'll make one from scratch.

For example, if you're making a database of Lost Pets, you might want a table for each Pet ( Grumpy Cat), Owner ( Fussy Old Guy), and Location Spotted ( Central Park) Gather digital photos of items in your collection, thinking about at three related concepts you might want to put into separate tables.

Airtable tutorial how to#

See our previous tutorial on how to do this. For this assignment, your schema should have at least one one-to-many relationship as well as at least one many-to-many relationship. In the process, I hope you get a better sense of why linking tables in this way can save you typing and reveal connections hidden in the data.ĭrawing a database schema beforehand will help you decide the relationships between these tables. In this tutorial, you will learn how to create a simple database in Airtable and add one-to-many and many-to-many relationships. Airtable is a online platform that in some respects is halfway between a simple spreadsheet like Excel or Google Sheets and a fully fledged relational database like MySQL.

Why Airtable?ĭesigning a relational database can be intimidating, especially when you start with something abstract like a database schema. Note: this draft presents only a synopsis of this tutorial.