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.
I still getting rows for each part in the kit which is the issue. There will be 15 -20 kits requiring completion (of possibly hundreds) and each of those could have 30 items so I’d like the view to show a single row for each kit rather than having a couple hundred rows if that makes sense.
@Josh2
I believe there is a bug. Check this out from @tsuji_koichi
[Inline table view working wrongly](https://community.appsheet.com/t/inline-table-view-working-wrongly/18480) Questions
I already reported to support@appsheet.com and appsheet team should be aware of and working for a fix, but I’m sharing with community member who may see the same issue. When we put the table view as inline, and set the format rule to it like color to change and also grouping for drill down, those two are not working as designed. Hope a fix will be released soon.
@LeventK ok so it looks like I’m not crazy (hopefully). @tsuji_koichi could you please keep me updated on the response.
I tried creating a reference column with MAXROW expression:
MAXROW(FASTENER_KITS, _RowNumber, [KIT]=[_THISROW].[KIT])
which populates a new column in the data with the last row id for duplicate kits
I then referenced that column in a slice with filter condition:
[_RowNumber]=[KIT_REF]
and the equations seem to be valid but when I refresh/save I get an error thrown:
“Column Name ‘KIT_REF’ in Schema ‘FASTENER_KITS_Schema’ refers to ReferencedTableName ‘KITS’. That Table or Slice uses RowNumber as a key which is not a stable key.”
If I could get past that error it might do what I want?
But it seems I should expect grouping to only show unique rows in the view. If that’s the case then hopefully this will be remedied soon.
