Many to Many References With SELECT() in AppSheet || The Brute Force Method

[@tom-greg]

Great video as allways! I would love to see a video on how to generate a custom/filtered CSV-file. Lets say you have Customers -> Locations -> Inventory. I would like a button in the customers list that generates a CSV with the Inventory of that customer, sorted/grouped by locations.

[@gnorpflorbsen8665]

Why this over dynamic slices of a lookup table associating primary keys? Would that not be cached on the device?

[@MultitechVisions]

A lookup table is actually how I prefer to do it; it future proofs everything. Just offering an option. ;)

[@tanjidahmedjony4667]

Love 😍 You Big Brother 🥳🌻

[@bellacintron4963]

I'm trying to follow but I can't figure it out. I'm trying to connect persons in a STUDENTS TABLE with a FRIENDS TABLE. The student table has all the people in the class, and the friends table is used to connect who's friends in the class. The friends table uses the student table as a reference for names. How can I make it so that when I make student 1 a friend of student 2... student 2 reflects that it is a friend of student 1? Currently I have to enter the friendship connection on both student 1 and then student 2 to show that they are friends. Is that even possible? Thank you in advance.

[@MultitechVisions]

Many-to-Many is difficult to get your mind around; but once you finally figure it out and things click, it get's easier to implement. The hard part is making sure you get all the appropriate update actions in place, in the right order; check out the sample app linked in the description.

[@richinman9721]

So helpful! I really like the client side solution. Looked under the hood at your app and it looks like `[_THISROW_BEFORE]` does work. 👍