I have a Repeating Group (RG1) that fetches data from the UserBilling table, and each row corresponds to a single UserBilling entry. Inside this repeating group, there is another nested Repeating Group (RG2) that fetches data from the DateList table.
Important note:
UserBilling and DateList are independent of each other.
I want to fetch data from the EmployeeAttendance table and match:
email ID from EmployeeAttendance to the User ID from the current cell of UserBilling in RG1.
Date from EmployeeAttendance to the current cell of DateList in RG2.
My problem is that I can’t figure out how to match the current UserBilling’s User ID from RG1 with the email ID in the EmployeeAttendance table inside RG2.
Not sure if what i did, always in the same sample app editor I sent you yesterday, is what you are looking for, but I think you should be able to get it.
Check the page called rg.
There, inside the first RG there is, beside the second RG, a group used to store the first RG cell’s index.
From within any element of the second RG you can point to that group’s number to get in which cell of the first RG they are.
Copy only the first RG in a popup element (this popup element won’t be visible in your app, but the copied RG must be set to be visible - look how I did in the editor).
As source for this copied RG that resides in the popup, choose the list of things of the original first RG.
Now you should have everything you need to make the search constraint you are trying to do:
search for the
copied RG list of things: element#group’s number’s id
I mean, your search will be something like:
Do a search for “Attendance Table” → where
attendance table’s id = copied RG list of things: element#group’s number’s id
