How to group data into one cell of a repeating group based on an attribute

Need help Database
1

Hey All!

I have been struggling all day with this, any suggestions are appreciated!

Using a convenience stores inventory:

image
image1501×586 55.6 KB

I am trying to group products of the same the ‘description’ and ‘size’ into one tile of a repeating group:

image
image964×665 32.1 KB

Clicking on the tile would then open a pop-up with options of ‘flavours’ available for that ‘description’ and ‘size’.

Currently I have all the inventory showing in my repeating group…how can I group/filter to only show unique combinations of description and size?

Thanks in advance!

2

can you not filter based on the parent group of the popup?

3

Thanks for the response.

I still want items with other descriptions in that repeating group, just to have each of them only showing once. For example, if i have multiple Vitamin Water entries (one for each flavour) I want it to show up like this:

image

Then when I click on that tile, the pop up shows all the possible flavours that match the description (i.e. vitamin water)

image
image1892×709 96.5 KB

4

OK, I think I know what you mean. Try setting the repeating group or parent group to Inventory, add, ‘do a search for sub-category’ with a constraint on which sub-category with each repeating group.

5

That was my initial thought as well, the problem is that the data set is such that each flavour has the same sub-category and description. So even if I constrain the search by sub-category I end up with 8 vitamin water tiles.

6

try adding :unique elements at the end of the dynamic data

7

I’ve tried that with no success…I thought maybe that didnt work because technically they are unique elements that happen to have the same sub-category?

8

OK How about changing the repeating groups type of content to “text” (i.e. just type in text)

9

Unfortunately that wont work either because it will also have images and numbers. Thanks for trying!

10

Did you solve it ?