OK, I’ve read everything I can find on sorting RGs, I’ve looked at BDK plugins for RG’s and @keith fantastic list shifter plugin. But alas… I still can’t find away to achieve the following.
I have a Datatype called “Houses”, with a field called “Colour”
And a second datatype called “Paint” with a field called “Colour”
I’m displaying “Paint” in a repeating group and want to sort the Paints based on
how many “Houses” have a particular “Colour”. Something akin to sorting the paints by popularity.
In my head, it would go something like making a list of the number of houses of a specific colour;
(I believe this is possible with list shifter)
Red = 7
Blue = 1
…And then filter/sort the “Paints” in the RG by the value of “Houses’s” “Colour” that corresponds to the Cell’s “Paint’s” “Colour”.
So now the RG’ will show Red, Green, Blue.
Perhaps this simply is not possible in any way, shape, or form, and I should just give up.