![]() ![]() Notice that all of these tables share similar data types with similar fields namely: Name, Status, Email, Website URL, etc. ![]() To show you a real example from our business, here are three separate tables that we decided to join into a single table: ![]() While most real life examples are more complex the principle is the same: you identify similar categories of information that reside in separate tables and you join them in a single table that acts as the parent category, so to speak. If you’ve got a table for “Cats” and a table for “Dogs”, you want to put them in a single table called “Animals”. Thinking about and setting up your new tables (For instance, in our People tab, we have a “customers” view, a “team members” view, a “partners” view, and so forth.) So we decided to do a little housekeeping by consolidating multiple related tables into single tables wherever it made sense to do so.įrom there, we just created Airtable Views to easily look up the various sub-categories of information in a given table. (And for that matter, so can Partners, Affiliates, and any other type of “person”.)Īs you might imagine, it can get messy to have your data in too many different places. In this case, both customers and team members can be grouped under the umbrella term “people”. Over time, as we’ve continued to add new tabs and new categories of information to our control center, we started to notice multiple tables with redundant data.įor example, we initially had a table for Customers and a separate table for Team Members.īut in Airtable, you ideally want to place similar categories of information in one table. You see, here at MemberFix we run many aspects of our business from within an Airtable base that we call our MemberFix Control Center. In this article you’re going to learn how to consolidate your Airtable data into fewer tables so that you end up with a neater, more organized base.Īnd let me be clear: this is not a “theoretical” article! Update linked records mapping to the new table. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |