Hi all,
I’m sure this is simpler than I’m making it out to be.
I have a repeating region that’s displaying a single datatype.
Within that datatype I have a reference to another table of another data type. That data type has reference to another table that it uses to reference which stage it’s it.
What I’m trying to accomplish is to count how many of the second data type are at each stage within the first data type.
While this isn’t a Kanban, I thought that might be the easiest way to describe:
My repeat region is listing all the Kanban boards that have been created. In each Kanban I link to ‘Tasks’. and each Kanban has say 5 ‘Stages’.
What I want to achieve is showing how many tasks are at each Kanban Stage in the repeat region, so:
Kanban 1
- stage-1: 5
- stage-2: 0
- stage-3: 3
- stage-4: 5
- stage-5: 1
Kanban 2
- stage-1: 3
- stage-2: 1
- stage-3: 0
- stage-4: 2
- stage-5: 10
etc.
I have tried nested repeat region, but this doesn’t seem to give me the ability to count on the join table for the second query (the nested query).
I’ve thought of simply extending my workflows and simply adding to the ‘Kanban’ data type 5 new DB fields - and simply add or subtract numbers to those - but I’m assuming there is a way I can do this that’s a little more efficient than that!
Appreciate any guidance here.
Last updated: