Establishing Many to Many Relationships in AppSheet

Creating a One to Many relationship in AppSheet is fairly straight forward in AppSheet. However if you need to create a Many to Many relationship between two tables there is no documented path. In this video, I try to outline a method that you can use to create Many to Many relationships between tables.

App Template: https://www.appsheet.com/templates/ap...

00:00 - Intro
00:40 - App Demo
03:23 - Adding Columns to Track Changes
04:55 - Setting the Column Type Enumlist as a REF
06:36 - Fixing Empty Enumlist REF Dropdowns
09:28 - Columns to Track Changes
10:59 - Calculating Added or Removed Entities
14:26 - Create Actions to Update the Related Table
19:01 - Creating the Automation Bot
23:42 - Testing the Automation Bots
26:58 - Creating Inline Views from Enumlist Fields
30:54 - App Cleanup
34:04 - Summary of all the steps