List line items linking to other sheets

I know we went back and forth on this in the previous forum, but never got anywhere.

One solution would be one sheet. Create one set of columns for one page. A second set of columns for the the second page and so on. Only fill the columns that relate to that specific page and only those components will show depending on which list item you select. The only downside is that it doesn’t work well if you need to add or edit records as you would need all components to show in Add/Edit.

A better alternative is to create a sheet that will serve as your tab in the app and set that tab to detail view. Create columns in that sheet with a reference to each sheet that you want to show different data for. Then create the separate sheets that would have different layouts, and lay them out how you want. On the first sheet that serves as your tab, add an inline list for each column that you have set up a reference for. Remove the label for each inline list. This will give the visual effect of one list, but each item will reference to a different sheet.

In my app screenshot, it looks like one list, but each item points to a different sheet entirely and the layouts are completely different.
Capture

If you are willing to share your sheet or make your app shareable, I think this could be laid out pretty quickly.

1 Like