Skip to main content

I have a field linked to another table, and when I use roolup with ARRAYJOIN, it didn’t keep original sequences.


For example, the sequence of the linked field is sa, b, c], but the output of the roolup is “c, b, a”.

I also need help with this exact issue. Any advice?


What’s actually strange with this is that it’s a double-reversal: the links themselves are reversed, and the rollup then “corrects” the problem with the links.


In a test I ran recently, I made a table with these items in the primary field:



I then linked each record one by one to a control table. When looking at that table’s link field, they’re in reverse order. When using a rollup to pull data from that linked table, it reverses the order again, so they’re back the way they belong:



I suppose the point I’m trying to make is this: if you create the original links in the order that you want them in the final rollup, they’ll stay that way through this double-reversal process.


Reply