We're setting up your new app...


Different Inline Views

How to setup duplicate inline views, but with different types

Industry: Education
Function: Education_and_Training
The purpose of this app is to demonstrate how to setup a parent-level table so that it displays two versions of an inline view - each with their own type. - This is extremely helpful for providing some higher-level analysis (right inside a detail view) For Example: - You could see a table view of employees (such is the case in this sample app) - but also view that same list in a chart view Same data, different view. -------------------------------------------------------------------------------------------------------------------------------------------------- The key to making this work is centered around the fact that AppSheet treats slices the same way they treat tables - you can essentially interchange one with the other (in most instances). Another aspect of the AppSheet platform that plays into this, is the fact that slices and tables each have their own separate view controls. This means that I can have a (Table-type view) for the root main table, and a (Chart-type view) for a slice of that same root table. -------------------------------------------------------------------------------------------------------------------------------------------------- By combining these two elements together, you can create a way inside your app to display the same data (meaning the same list of records) - but with two completely different view types.

How we built this app

The steps involved in making this work are as follows: 1) Create a slice of your child table (no slice condition formula) 2) Create a view for your slice (different from your main table view type) 3) Copy the REF_ROWS() formula from your parent table into another column 4) Change out the table name in your REF_ROWS(), changing it from the root table name to the slice you made, and updating the "Referenced table name" in the column settings correspondingly. --------------------------------------------------------------------------------------------------------------------- For more information, and a step-by-step tutorial, click the link below - https://www.youtube.com/watch?v=4NmliThT86E
This is a preview of the data sets used in the app.


This is a high-level model of both the data entities and the UI elements in the app.
Start for free