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

Описание: A very common method of implementing many to many references in AppSheet, is to simply use a SELECT() formula to pull all the related items.
This works, except for the fact that if you change the list of references on one side, how does the opposing side get updated?

More importantly: How can you know what was removed vs. what was added?
Since there's no records storing this information (like there would be with a Join table), you have to get this info some other way.
HOW = include two additional columns, on both sides of the reference, to hold this info

In this video I go over how you can create columns in your many-to-many tables, to help smooth out this difficulty.

KEY POINTS:
You need an EnumList on BOTH sides
You also need a way to isolate out what's been added vs. removed from those lists
Add an EnumList of "Removed" items
Add an EnumList of "Added" items
From these you can then easily execute independent actions for both lists, adding or removing references on the opposing side when changes are made.

-----------------------------------------------------------------------------------------------------------------
WARNING: This method is inherently inefficient
-----------------------------------------------------------------------------------------------------------------

You can find a sample app that demonstrates everything you need to do here:
https://www.appsheet.com/templates/BR...


Table of Contents |-----------------------------------------------------------------------------------------
0:00 Intro
2:11 Client-Side Solution
3:53 Key points for managing many to many references
4:49 Addressing difficulties due to changes made to the list
6:19 Columns to hold the changes
8:27 Why have separate lists of changes?


-----------------------------------------------------------------------------------------------------------------------

/////////////////////////////////////////////////////////////////////////////
/// SUPPORT THE CHANNEL
/////////////////////////////////////////////////////////////////////////////
//
// Schedule a 1-on-1
// https://calendly.com/multitechvisions...
//
// Patreon
//   / multitech  
//
// Merch
// https://multitech-merch.creator-sprin...
//
/////////////////////////////////////////////////////////////////////////

For more information about MultiTech Visions, visit
www.MultiTechVisions.com

Don't forget to check out AppSheetInsider.com

#CitizenDeveloper #AppSheet