Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

How does the rollup function order concatenated results?

335 1
Showing results for 
Search instead for 
Did you mean: 

Hi all–

I have a function that requires a rollup to concatenate values in numerical order. But I can’t seem to control how the rollup is determining the sequence.

I’m basically using this type of logic: Either: Display X most recent linked records OR Display all linked record up to a year prior to most...

And yes, I want to show the last three records… but the rollup function is aggregating the results in a weird sequence. The result is that it gets the last 3 entries according to the rollup, but it’s not actually the last 3. It sometimes throws an entry out of order, although for the most part the results seem to be as predicted.


1 Reply 1

It is based on the order of your records in the “linked record” field that the rollup field is based on.