Hey All,
I looked through the forum for help with this and found something that got me close, but not all the way there. Can someone please help me with this?
I would appreciate any help you can offer.
All the best,
Benjamin
Hey All,
I looked through the forum for help with this and found something that got me close, but not all the way there. Can someone please help me with this?
I would appreciate any help you can offer.
All the best,
Benjamin
Anything?
Doing it only in a repeating group is going to be tricky.
What I might do is create a temporary set of data on page load (for this course) which contains the āpivot tableā.
Then reference that in the repeating group.
Hey @ben4,
Iām not at my computer to test this but I believe your grouping on the attendance RG is causing your issue. Try making the type of content User and then do the same search for attendances but it should look like this: āDo a search for attendances Users: Unique elementsā
That will return only users with attendance records.
In your sub RG where you are displaying the hours you should be able to perform some type of āsearch for attendance where user is parent cells user and date is current cells date: first itemā
In theory that should do what you need to do.
Here I thought I was making progress in my bubble knowledge. @NigelG and @eli, you have both gone over my head. I attempted Eliās suggestion and only got so far. I did the search as you suggested but it lost the grouping, meaning it showed the three records for 1 person enrolled. I wasnāt able to get to the sub repeating group as there were three records where there should be one. Maybe I missed something?
Nigel, Iām sorry to say I didnāt understand anything you mentioned.
ā
ACTUALLY, scratch that, I just kept going with your train of thought, and I got it!!! I appreciate it. Now onto the next issue!!
Thank you guys for the help!
This topic was automatically closed after 70 days. New replies are no longer allowed.