Adding list items in Repeating Group

Questions
1

Hi All,

User DB example:
Name: John
Product List : Product1, Product2, Product1, Product3, Product4
Qty List: 1,2,2,1,1

I would like to show them under one repeating group,
Repeating Group Example under John name:
Product 1 ----> 1 qty
Product2 ---->2 qty
Product 1 ----> 2 qty
Product3---->1 qty
Product3---->1 qty

I checked the forum but I did not find the right answer. I placed 2 RG on top of each other on design but I do not think it is right solution.

Is there any idea how to show it?

Thanks

2

You’ll need to set up nested RGs.

So your main RG would be of type User (as mentioned under DB example)
and in each cell of this RG, create a group and insert another RG that has it’s data type as a list of numbers. The data source on this can be parent group’s User’s Qty List. The Group created will have it’s data type as User / current cell’s User.

On each cell, you can reference the Qty List number as current cell’s number and you can also reference the corresponding product as the Group's User's Product: item #current cell's index

Cheers,
Ranjit | Atomic Fusion

1 Like