Help with referencing one item and getting a List of child items, and how to present them

[Shlomo_Green]

Hi all,

I hope you could help. I’m posting this after thoroughly searching the AppSheet documentation and through the forum.

I’m trying to build a building inspections app. Sometimes I need to inspect a specific area (entrance, lobby, garden), sometimes a specific system (fire safety system, water supply system) or facility (gym, tennis court).

Each of the above are comprised of many items, and many times an items can relate to a facility as well as an area.
An example of an item: parking-gate (relates to area: parking lot; system: entry-control-system; facility: none).

I’d now like to build an inspection form, where the user chooses what is being inspected (area, system or facility) and get’s only the relevant list of items to inspect.

Example 1:
User chooses to inspect the AREA: Lobby and is presented with items: door, mirror, spot lights, each with the options of in-order / not.

Example 2:
User chooses to inspect the FACILITY: Gym and is presented with items: treadmill, bench, TV

I can’t seem to figure out how to pull the list of items that are related to the chosen area/system/facility, and mainly how to convert that ref to a yes / no item.

Any help is much appreciated!

I’m pretty sure this user here was asking a similar question but didn’t see responses:

Inspection App with Questions based on Location & Equipment Questions

I’ve got a couple different workflows that would benefit from the app being able to load a set of questions from the database for a selected location and or piece of equipment. These questions all have a yes/no response and then possibly a comment or picture if the item is not in compliance with the question. I’ve been struggling with how to do this efficiently. The sample apps for this type just show a list of generic questions vs. specific questions that apply to that piece of equipment. …