I have two related tables in my app, customers and sites. Each customer can own multiple sites. The references were automatically created by appsheet and I think work.
What I would like to do is make it so that the user can view a customer detail and have an option at the bottom to add a site, which will then show as a list at the bottom of customer detail.
This is similar to the way the Order Capture demo app shows a list of orders when viewing a customer. Currently I have the customers spreadsheet populated, but no data in the sites spreadsheet. Do you know how to enable this functionality please?