What Would It Take To Sort By A Calculated Value In Bubble?

[SerPounce]

I am using a combination of these 2 plugins:

RepeatingGroup Tools (bdk) Plugin for Bubble

Utilities (bdk) Plugin for Bubble

Quick summary (I can provide a more exhaustive explanation if there is interest and when I have bit more time available):
In addition to the main RG on the page, I have a second hidden RG.
The main RG has the primary data type for its source, while the hidden RG has the related type.

Within the first plugin is the “RG Extractor”. I use this to get the related data out of the hidden RG.
Within the second plugin is “Transform Lists”. I use this to stipulate the sort order.
Then in my main visible RG, there is a condition (actually multiple) to activate the related sorting based on user selection. Took a little while to get working, but thanks to some wonderful support from @gaurav it works perfectly and super quick too.

[JustinC]

This is great news.

But just to confirm before I dive into this, this setup will also work to sort calculated values (values not stored in the database) inside of the primary repeating group??

[robert]

Those 2 methods you mentioned are the only ones I know of, and I’ve used both of them. Would be interested to know of any others.

[SerPounce]

@JustinC

But just to confirm before I dive into this, this setup will also work to sort calculated values (values not stored in the database) inside of the primary repeating group??

Sorry, I really don’t know the answer to this. I’m not that optimistic, because the solution relies on the RG extractor which gets existing data already in the related type.

[JustinC]

OK so it doesn’t seem to be possible as the values are calculated in the RG and displayed to the user… Damn.

[JustinC]

I’d love any way to sort a calculated value on-screen from lowest to highest.

[SerPounce]

@JustinC Actually, it might work…

Here is a screen shot of the RG Extractor element and I updated the last column to be a calculation.

Here is a screen shot of the RG data element which gets the data from the RG extractor. It looks like it will take the calculated field.

[JustinC]

Awesome, thanks for the help on this @SerPounce!

Will start playing around!

[gaurav]

Just posted this that might be helpful :

[Bdk Concepts] Livesorting in bubble

Hello Bubblers, A lot of things can be achieved using a combination of Bdk Plugins. Inspired by @SerPounce’s suggestion & feedback like this, sharing here an an example of Live sorting a RG based on a calculated metric. This example uses 0 workflow steps, doesn’t require saving anything to database, and is very fast. Click here to open bubble page Click here to open bubble editor Below is a screen recording of the demo: It makes use of 2 of the bdk plugins: RepeatingGroup T…

[mxolisipn]

Thanks a lot @eric1.

I can now sort per the nearest physical addresses.