Share
Report
57Hello all,
I have two collections of data (collDates: representing seven consecutive days; collRoomList: representing six exam rooms).
I'm trying to marry the two into a gallery, something like this:
| 12/13/2022 | Exam Room 1 | D.0910.08 |
| 12/13/2022 | Exam Room 2 | D.0910.10 |
| 12/13/2022 | Exam Room 3 | D.0920.07 |
| 12/14/2022 | Exam Room 1 | D.0910.08 |
| 12/14/2022 | Exam Room 2 | D.0910.10 |
| 12/14/2022 | Exam Room 3 | D.0920.07 |
I think I have the necessary details in the parent collection I've built (although potentially looped incorrectly). This is the formula I'm currently using:
The problem I'm running into is actually getting the nested data out from the collection and into my gallery. I am able to display individual records, but I'm struggling to display the entire collection.
For example, these two values in the items property of my gallery will display single records from the collection (the first and third records respectively):
First(collTableData).Value
Index(collTableData,3).Value
Either of those two formulas display that particular record in the gallery:
I've tried using a ForAll to cycle through collTableData, but all my efforts always seem to lead back to a collection of tables. 😞
Any suggestions on how I can display the entire collection in my gallery? Thanks in advance! 🙂
All responses (
Answers (
