I have a repeating group that is made up of all of my time entries for a task. The repeating group is grouped by the task (the task has multiple time entries).
My Goal: I need to sort the repeating group by a field that is exclusive to tasks (the grouping), not time entries (the Search for).
However, when I go to add “sorted”… I expect to see my fields for “task” so I can sort the repeating group… but I see nothing here.
Once you do a grouping the only fields available to you after are those that you have grouped by. In the grouping you would need to include the field you are trying to sort on. There is no such thing as “sort by task” it would have to be “sort by task.entry-time” where entry-time is a field on the data type task and is also included in the grouping.
Crud Your explanation makes sense… however I must have an issue with my data type structure. Time entry is a data field on Ticket… but doesn’t show up as a group by… my guess is it’s because they are both data types…
Ok, I figured this out – You got me on the right track @bubble.trouble.
In my case, since both were data types, I had to go “one layer deeper”.
Notice that after the “group by: task”, I put in “each items task” – Once I did that, it changed the Type of content to Tickets and then allowed me to then sort by all of the fields for tickets!
Works wonderfully - Thanks for getting me on the right track here.