Show a "detail view" for each item in a reference list within the same view

Hi,

I am making a check list app where each customer has many sites, each site has many areas, each area has many pieces of equipment and each piece of equipment has a single basic equipment type. Each basic equipment type can have many stock check list items. And each stock checklist item can have as many possible selection options as you want when setting up the stock checklist item. In addition, I have set up the app such that a “notes” field is hidden until one specific option is selected.

Everything is accomplished by way of parent-child tables with the exception of the stock check list items. The possible selection options are entered as an enum list.

This allows me to set up the detail view for each “related checklist item” to allow quick edit for the selection and it allows me to show the possible selections as buttons and not a drop down. Which I think is pretty slick.

I find that the parent-child-grandchild-great grandchild… nth grandchild navigation is very cumbersome though.

I am currently looking for some way to come up with a view that could be comprised of some scrolling list of “detail views” for only the items related to the current row of the parent record…

I am aware of the side show mode but that just doesn’t quite work for my application. I would really like to see all related records on the same page which can be scrolled vertically.

Please keep in mind that I have designed this app to be very robust and that creating a separate checklist table is not within the realm of possibilities…

Have you looked at the interactive mode of the dashboard view?

https://community.appsheet.com/search?q=interactive%20dashboard

2 Likes

Thanks Steve.

What I am actually looking for is the ability to come up with a view that could be comprised of some scrolling list of “detail views” for only the items related to the current row of the parent record… The details views is the key.

Clicking in to an area I get this for ‘Area Details’ View:

When I click on one of the entries in ‘Related Checklist Entries’ I get this ‘Checklist Entries Detail’ View, Call this item A:
image

What I would like to achieve is: Instead of seeing a list of ‘Related Checklist Entries’ in the ‘Areas Details’ View I would like to see a scrolling list of the ‘Checklist Entries Detail’ Views (item A). This scrolling list will only show items from ‘Related Checklist Entries’

Currently what I get from interactive dashboard is a single block showing a single ‘Related Checklist Entry’ that can be manually scrolled by clicking the arrow.

image

instead of just displaying a single block that can be manually scrolled by clicking an arrow I want to see all items stacked within the same view.

AppSheet doesn’t offer a scrolling detail view like you want. The closest AppSheet has is the card view:

Not to be confused with the card layout of a detail view: