Building Strong Connections with Many-to-Many in AppSheet
ฝัง
- เผยแพร่เมื่อ 25 พ.ค. 2024
- 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:
bit.ly/4bh3JSp
(Thanks for your suppport. 🙏)
Building from this app, watch this next:
• Mastering AppSheet fie...
Recommended related videos:
AppSheet Best Practices
• Level Up Your App Deve...
5 Best Ways to create dropdowns
• Top 5 Ways to Make Dro...
_________________________________________
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 - แนวปฏิบัติและการใช้ชีวิต
Wow!
Did it help? 😁
great explaination
Thank you 🙏
thanks! your content is really useful!
Glad you think so!
Thank you for the video and clear explanations. It really helps. I have subscribed and gave you a thumbs-up and will follow what is coming. Great content!
Thank you very much!! Welcome to the Sheety community. 😁
@@FullOfSheets Thanks!
Welcome, mate!
fantastic! thanks!
Thanks bro.
Perfect timing! This is exactly what I needed to know.
Now, please stop everything else you are doing and go and make the next video :-)
😆 ok ok. I will release soon. 😁
Continuation video already relased. Thanks.
@@FullOfSheetsthe only new video I see in your feed is the Context one. Can you give us the link to the continuation video?
@andyburnett4918 Yes. Thst is the continuation. The Context() one starts from where we left off in the Many-to-Many video.
Brilliant! I am off to watch that one right now. Many thanks.
Excellent video, explanation and content. Great job! Very interested in reaching out to you, or members of your community for specific AppSheet project. What are the next steps?😊
Much appreciated! If you need to reach out, please check the contact form in my Channel's description.
Hi, can I request tutorial for appsheet that request for approval of 1 or more person.
Can we have a tutorial where there will be an approver? #appsheet #buildingwithappsheet
Hi, how do I assign roles and task to which users? and to set or know when the task is done, pending or have no progress yet?
It's in the subtable as you've seen in the video. One you created that ref connection, then the Projects table would automatically have a Related TASKs virtual column.
The detail view of the project would then have an inline tasks table with a View and Add button on the lower right.
thanks! I'm creating a IT ticketing machine for software/hardware problems and who will do the job
@@FullOfSheets
Awesome! But do you mean that each ticket has multiple tasks assigned to different people?
can you create a tutorial for that?
@@FullOfSheets
You actually haven't answered my clarification question. 😁
Hi
I like the way you explain the various subjects in AppSheet.
As my hearing is not what it used to be when I was younger I have a request.
The backgound music is drowning your voice (for me) maybe is can be toned down a bit.
Also the sound of your voice mike is a bit muffled. Maybe add som more "high"?
Hi,
Thanks for the feedback. I apologize for the music as it is quite difficult to monitor it during editing as I only use Bluetooth Headphones.
Also, I use a lapel mic and I can only remove background noise. I only edit my videos via phone and there are no audio eq controls in the app I am using.
Does my video captions not work for you?
The music is really distracting.
Thanks for letting me know. I'll try to do something about it. This is the knly video where I uploaded thenvideo without music then only added the music later onnusing youtube studio.
I'll check if there's a way I can lower down then volume.
Can you check if it's better now?