How to Use the Relational Database Design of Airtable

[@homahealthcarecenter]

airtable primary key is important, lookup andd roll up are based on this,good

[@BenGreenSystems]

This + filtering, super important!

[@RonTurchyniakEdTech]

Nice work - AirTable should add "Referential Integrity" options and implement an MS Access Style Queries interface.

[@davidderbyconsulting]

Great job Ben! An excellent tutorial that we can use to educate new clients on the basics of Airtable.

[@BenGreenSystems]

Thanks David! This was originally part of a course, but I decided it needed to be more accessible. Glad you found it useful

[@hmuskus]

Ben. Amazing video. I just have a big doubt that maybe you have addressed in other tutorial. I have 3 databases, each of them have a way to relate with the other... For example, in DataBase A (dbA) I have the email of the user and other data, in dbB I have the email of the user and courses the user must do, in db3 I have the user email and the progress of each course the user must do... I want to relate them automatically with the common fields each database share with the others. Is this possible?

[@engin3ar]

Wow, I just stumbled on a goldmine of Airtable info on your channel...

[@BenGreenSystems]

Welcome aboard! Anything you are currently looking for an answer on?

[@fortmandigital]

This is heavily needed. Thanks Ben!

[@BenGreenSystems]

You are welcome! Glad it helped

[@MagnumIsWild]

how can i use forms to add entries to linked tables from a single form?

[@BenGreenSystems]

Miniextensions is the only one that does this elegantly. I have a way to do this for one additional linked record that is a hack, but works. I will make a video on it. To do so, you need an automation

[@h0ph1p13]

Interesting fact: The word "relational" in "Relational Database" does not have anything to do with the relationships between the tables. Relations are the tables themselves. At the time had their raise, data was stored mostly NOT in tables. So if we had to translate the term it would sound something like "Table-based databases" One of the sources: "Relation is essentially a mathematical term for table. The notion of storing data in tables is so commonplace today that it might seem inherently obvious, but there are a number of other ways of organizing databases." - PostgreSQL DB Manual

[@BenGreenSystems]

Very interesting! I did not know this. I like to think of it as the relationships between the tables, but this makes a lot of sense . Very insightful

[@1jbegic]

This is all good, but how do we use the Form to allow entry to linked tables from a single form? What is explained here is manipulating data in the "database". Is there any tutorial related to the Forms?

[@tommycoe2333]

Forms are just an entry tool. You set up the database the same. You create the form and all the records will be linked.

[@BenGreenSystems]

Correct, and now Airtable has interfaces which are even more powerful than forms. I can make some tutorials on interfaces if needed

[@chancesofrain6480]

Could have been better :)