HI, I’m have recently discovered appsheet and have been been very impressed. I have been using it to build an inventory management systems with a good deal of success.
I’ve built a few useful apps but am currently having an issue with my latest. I’m creating an app for warehouse pickers to assemble part kits for production. Each kit has multiple components and quantities of each component. the first column has the name of the kit as per screenshot.
I want to have a view inline that allows you to select the kit name in the first view then show a table of components and quantities. If I customize the columns shown in the first/primary view to only show kits I get a row for every row in the sheet as per picture.
what I would like is for the view to show a single row for each (e55 and 35w). The articles I have read speak about linking multiple spreadsheets which I would prefer to avoid as that can get messy. Also there is requirement for flexibility in the list of kits as they can change and new ones will be created in the future. Any help would be greatly appreciated.