I am trying to sort data in a repeating group (a list of things coming from a search) by recurring count. As an example if “Business A” existed in the search 1 time and “Business B” occurs 5 times, “Business B” would be at the top of the list since it occurs the most times in the search. I understand Bubble does not offer this ability, so I am exploring Blockspring.
Blockspring provides a block called “Sorted Unique Count List” which appears to meet the need.
I am trying to use the Blockspring Plugin and during the setup if I manually type in sample data I can successfully display the data in the correct sorted order in a repeating group.
When I use the Blockspring API it automatically populates JSON with the sample data in this format:
However if instead I want to dynamically send the API a list of business names coming from a Bubble search, how can I send that in the correct JSON format? If I simply add the search it will put all the items in a single row comma separated, so Blockspring only sees 1 row of data which prevents any sorting of things. I am hoping there is another way to populate the data source in the correct JSON format. Thanks.