We are building an application that has users create savings goals. We would like to be able to see all of the goal names our users have created in one place along with the email of the user that created it. Also, we would like the repeating group to be sorted in such a way that each users’ goals are clumped together.
We have set up a repeating group that does a search for goals, but don’t see an option to sort that search by creator, which is what it would seem like we need to do in order to clump them by each creator’s email.
Hi @dserber I think this used to be available as well but is not an option anymore. One way to set this up is to create a repeating group which does a search for Users, and then place a second repeating group (for the goals) inside of the first cell of the User repeating group.
In summary, the outside repeating group would do a Search for Users (constraint: Goals isn’t empty)
and the second, inside repeating group would do a Search for Goals (constraint: Creator = Current cell’s User)
Feel free to let me know if you have any questions in setting this up!
It’s an easy SQL sentence. I’m assuming that due to bubble complexity it’s not as easy as to write
SELECT *
FROM table1 t1
JOIN table2 t2
ON t1.id = t2.id
ORDER BY t2.order_field
But hopefully you can figure something out
Because it’s very useful and sometimes even blocking not to be able to do this. I have to ditch a whole feature in my app due to the UX problems that this will cause.
I can create a new field in the type with the same content as the related thing field, but I see that more as a workaround of course and could create inconsistencies as if the content of the related thing field changes I would need to replicate the changes in all the rows.
I think this used to be available as well but is not an option anymore. One way to set this up is to create a repeating group which does a search for Users, and then place a second repeating group (for the goals) inside of the first cell of the User repeating group.