Concat some records in a repeating group

This is a bit complicated, but I have a list of items in my DB. Each item has an item type field. There is one particular item type that I want to condense in my repeating group and just show a count.

So my repeating group would look something like this

Item 1 Type 1
Item 2 Type 1
Item 3 Type 1
Item 4 Type 1
Type 2 (Count 2)

So all items with type 1 show their full details, but items with type 2 just show a count.


Yes it is possible, just need to take some time to think about how you want it to be set up

do you want r.g. to be full list or vertical scroll?

do you want a full list of type 3 after the type 2 count and then extend that for each type with evens just showing counts and odds showing full lists

lots of different ways to set it up, but yes it is possible to have that type of data displayed

One way you do this is with a nested repeating group. The outer repeating group will contain a list of Types. (If “Type” is its own datatype then that RG will be of type “Type”. If “Type” is instead a primitive value like a text or number, the RG will be of that data type.)

Inside the cell of the outer RG, you put another RG. The source for this RG will be some sort of Search or Filter operation that yields Items of Type 1 (which will be “Current Cell’s Type”). Configure it so that it only shows when this list is not empty. [This will show Items of type 1 as a list.]

Also in the cell, construct a text element. Display in this text element what you want to show for Type 2.

You’d have to muck around with the formatting quite a bit.

You could also just do an RG that displays Items of Type 1 and then, below that a similar looking element that displays what you want for Type 2.

It’s all a bit fiddly to do exactly what you want to do. :stuck_out_tongue:

marketing would like to see Type 2 counts as part of the main list, so Option 1 might be the best avenue.

Of course the other thing that occurs to me is that you should just put a little icon in the cell that toggles between the RG view and the summary view, which is really what you’re designing, if you think about it.

Its more of an unattended digital sign so no interactivity

Ah, dashboard - gotcha.

This topic was automatically closed after 70 days. New replies are no longer allowed.