Let’s see if I can stump EVERYONE, or if someone will be able to solve this mystery…
I have a repeating group. It is showing a list of “Things” based on current User ID, and is grouped by one of the fields within that thing, finding a sum based on that grouping. That much is working perfectly.
The thing is I need to introduce one more critical piece of logic. I only want a Thing to show up if it has a status of “Active” within a different data Type (table).
Ideally, the logic would read something like this:
Search for “Thing”:grouped by “Field”:filteredby [value within field of different data Type which has a cooresponding ID to the things being grouped together]
You might be wondering why this “status” value can’t just be stored in the same data Type. There is an answer for this. The data Type in question has many, many Things all with the same name (or ID) because it serves as an open-ended log to capture entries, which (forgive the repetition) is then displayed based on a :grouped by with a “sum”. Confused yet? Me too. PLEASE help :).