Different view with combined quantity

[Nani]

I have a child table and parent table, and in the parent table I do record time, email and date of order taken and delivery address and in the child table it has two columns item name and quantity, so once the person opens the parent table and enter these data time, email and date of order taken and delivery address and coming to child table they do multiple entries for the same item name with different or same quantity. Now what I want is in the child table they do make multiple entries, but I need a different view where I can view only one item name and with combined quantity for that parent table

So what should I be doing to get that?

[Aurelien]

Hi @Nani 

You may want to click on "expand", then edit this view and add a "Group by" option with the item name.

And "Group aggregate" option with Quantity.

[Nani]

Hi @Aurelien , thanks for the reply

I know about that method, and I am currently using it. However, I have some automations which generate pdf files, in which I want this combined quantity and combined item name there

[Aurelien]

Ok. This is a very different request.

You will need to use nested Start/End statement in the template.

What did you try so far?