Display array or multiple item relation or query items

Ask for Help
1

The set up: I have a table in which I am capturing the row ids of certain items from another table on a daily basis based on criteria in a query in a workflow. Each row in the table is first the date and then a comma separated list of row IDs. Each row in this table has a different date and generally the row IDs are different.

The issue: I want to display the items that relate to these row items in a collection, grouped by date, with each item listed below the date. If I had just one such row I would create a query or relation matching the row IDs in this table to the main table and then use the query or relation as the source for a collection and display the data. But I’m struggling to conceive of how to display each of the rows. If there is more than one row and you do what I described of using the query or relation as the source you, of course, get the first row and only the first row.

so for example the data in the table looks like this:
Date Data
1/1/25 Item1, Item4, Item7
1/2/25. Item2, Item 5, Item9

I want the collection to look like

1/1/25
item 1 information about item 1
Item 4 information about item 4
Item 7 information about item 7

1/2/25
Item 2 Information about item 2
Item 5 information…etc.

How do I do this? Am I missing something obvious or does it involve something complicated?

2

Would a custom collection work? A custom collection based on dates, and a collection within the custom collection container for data related to each date?

1 Like
3

Hmmm can you put a collection within a custom collection container? I didn’t think you could but if so that would probably work.

4

Let me answer my own question. Yes you can. :rofl:. Wondering now how many ideas I abandoned thinking that wasn’t possible.

I’ll play around with that @Jeff_Hager but that seems like the approach.

1 Like