If you need two tables in your app to have references to each other, then you need to set up a many-to-many relationship between the tables.
In this video, you will learn how to create jnter-dependency between two tables for various use-cases. For example:
A project can have multiple members, and a member can be in multiple projects.
An order can have multiple products, and a product can be in multiple orders.
Get the AppSheet Best P4actices eBook:
https://bit.ly/4bh3JSp
(Thanks for your suppport. 🙏)
Building from this app, watch this next:
https://youtu.be/BtY7ljzD8hI
Recommended related videos:
AppSheet Best Practices
https://youtu.be/nuBAOEPIMo8?si=ymR2kzIGZJWKgKZZ
5 Best Ways to create dropdowns
https://youtu.be/KtTEbu9hYmE
_________________________________________
Do you need coaching and/or consultation with the app that you are building?
Book a call with me. Link found in main channel.
===========================
Video Chapters:
00:00 Types of database table relationships
00:29 Is AppSheet a Relational Database System?
00:49 What do I mean by "Full of Sheets"?
01:06 Subscriber shoutout @magnusgoransson9564
01:58 A small favor from the viewers
02:40 What is a many-to-many relationship?
03:11 Google sheet set up for a proj mgmt app
04:04 AppSheet table set up
04:36 Adding members to a Project
06:20 Why an EnumList will not work
08:00 How to properly connect projects to members
09:16 Creating a "Tasks" join table
14:25 Checking the connections
15:44 Customizing Inline Views (Child tables)
20:16 The inline view dilemma
21:04 Validating the many-to-many relationship
22:00 What's coming next?
===========================
#appsheet #buildingwithappsheet #howto #tutorial #manytomany #projectmanagement #fullofsheets