Sort Repeating Group When Data Coming From 2 Places

Hi there,

I have a repeating group in my app where the data comes from two separate places. One is from a local DB and the other is from an API. I want to give users to sort my team name and avg points. team name is in the local DB and the avg points is in the API.

Ive tried a bunch of ways of solving this but to no avail. Any advice is appreciated

You can only sort a repeating group by fields on its type of content. The way to effectively accomplish this would be to automatically transfer the API data to the Bubble database on some sort of schedule.

For example, you could create a daily workflow that calls the API and saves the “Avg Points” data to the database. Then, the reference in your repeating group could be directly to the parent group’s data type, rather than to the API. Using this method, you’ll be able to easily adjust the “sort” field in the data source.