Hi,
Is there a way to retrieve several data from one repeater and filter for ALL OF THAT in another repeater?
Pls think of having three repeaters - “item”, “color” and “mapping”.
“item” looks like this:
1: ball
2: square
3: triangle
“color” looks like this:
1: red
2: green
3: blue
“mapping” looks like this:
1: item_1 color_1
2: item_1 color_3
3: item_2 color_1
4: item_2 color_2
5: item_2 color_3
6: item_3 color_2
7: item_3 color_3
The data means:
- the ball exists in red and blue
- the square exists in red, green and blue
- the triangle exists in green and blue
I want to pick an instance of the “item” repeater (like “triangle”) and review in the “mapping” repeater in which colors the item exists. Then I want to retrieve the color labels from the “color” repeater which indeed exist (“green” and “blue”).
B/c there for sure is much more data in the “color” repeater and much more crossings, I want to keep the mapping idea (instead of removing the “mapping” repeater, and in the “color” repeater showing nearly-identical rows several times, like “green triangle” and “blue triangle”).