Sorting item collection from API

mattpougnet · 2021-11-11T15:46:51.200Z

Hi! I am trying to sort a repeating group by Work order#. When I make the call, this is my result.

I want each Work Order # to have an entry filling out each subsequent field, but currently it is doing this. How do I get these entries to appear as just one work order number and not 77 entries each line?
Thank you!

boston85719 · 2021-11-11T15:51:20.910Z

Is it not possible to do the sorting on the call itself? Many API providers give the functionality of doing this on the call itself.

If it is not possible, then you can still use the ‘sort by’ feature built into bubble…after your API Call datasource dynamic expression, click it again to get the ‘more’ text button to access the operators and select the ‘sort’ operator.

mattpougnet · 2021-11-11T15:57:55.991Z

Thanks! I tried the sort method, here are my results:

image953×261 5.73 KB

and my dynamic data:

Is the order incorrect?

mattpougnet · 2021-11-11T16:30:11.538Z

Bump because I need help haha

boston85719 · 2021-11-11T16:56:23.438Z

Are you showing a list of things in a single Text Element instead of a repeating group for any particular reason?

mattpougnet · 2021-11-11T17:11:20.186Z

Not sure what you are asking. As far as I know this is a repeating group. Is there another way to add data to a repeating group other than adding a text box to the repeating group?

image972×705 12.2 KB

boston85719 · 2021-11-11T19:48:49.174Z

Screen Shot 2021-11-12 at 2.46.55 AM728×397 42.7 KB

You are putting the sort onto the text element…it should be on the repeating group, as should the entire dynamic expression you are placing into the text…your text element dynamic expression should be referencing something like "current cell’s work order number

mattpougnet · 2021-11-12T16:56:40.385Z

Thank you very much!
It is working just fine now:

image971×644 16.2 KB