I have a small issue with the Repeating Group and I am not sure how to solve it.
I have a database that contains:
City name
A list of activities (Text type)
A list of days (Date type)
What I am trying to achieve is to have the Repeating Group display each day in a cell along with one of the activities and the city name, vertically. However, when I set the Data Source and set the content type for each text inside the Repeating Group, all the items appear in a single cell.
And when I try to make it expand so each item appears in its own cell, I need to change the content type to Date or Text, which messes up the other fields from displaying correctly.
10 Activity 1 City 1
11 Activity 2 City 1
12 Activity 3 City 1
13 Activity 4 City 1
14 Activity 5 City 1
15 Activity 1 City 1
Summary of my question:
How can I display a database with fields that have lists of data in a Repeating Group so that each item appears in a single cell?
I tried it, and it worked to some extent. The dates appeared correctly, with each cell showing a single date. However, in the activities section, all the activities from the data source for the ‘RG’ appeared in every cell. I understand that this is how the program works, but I am trying to display only one activity per day.
In other words, for the ‘RG’ related to the days, the internal ‘RG’ for activities should display only one activity per cell.
It seems a bit complicated, and I don’t know how to do it
When I select all activities or use the #item index, all activities appear in a single cell. When I select the first activity, it shows the first activity in all the other cells.
