Help

List Values in Numerical Order via Rollup

Solved
Jump to Solution
3283 4
cancel
Showing results for 
Search instead for 
Did you mean: 
makasabian
5 - Automation Enthusiast
5 - Automation Enthusiast

Screen Shot 2022-12-07 at 9.40.55 AM.png

Hi! Is it possible to list values in a numerical order from a Rollup field? We want to view this field attached in numerical order. Any solutions to this? Thank you!

 

1 Solution

Accepted Solutions
autumn
6 - Interface Innovator
6 - Interface Innovator

I don't think it is possible to automatically keep them sorted, but it is possible to use the Batch Update extension to sort the linked records. I believe the linked records are what control the order of the rollup data. 

See Solution in Thread

4 Replies 4
autumn
6 - Interface Innovator
6 - Interface Innovator

I don't think it is possible to automatically keep them sorted, but it is possible to use the Batch Update extension to sort the linked records. I believe the linked records are what control the order of the rollup data. 

makasabian
5 - Automation Enthusiast
5 - Automation Enthusiast

This worked, thank you!

Yes, the order of the items in the rollup is controlled by the order of the linked records in the linked record field.

Note that the Batch Update extension only sorts linked records by the primary field value, so if you want to sort by a different column, the Batch Update extension will not work.

If you want to keep linked records sorted, I sell an automation script on my Gumroad store that can keep linked records sorted.

John_Gadd
4 - Data Explorer
4 - Data Explorer

Hello - you can now do this with OpenAI / ChatGPT using Make, allowing it to happen real-time (aka without you having to manually trigger a script or other method) based on a LastModified or other trigger field invoking the Make scenario. Here's a screen shot of how I did it.