Here’s some background. I have a table called Guests and each record has a field called Last Name. But, the Last Name field is calculated with a formula.
In another table called Episodes, every record has a field called All Guests with a Rollup formula that collects all of the Last Names from the Guest records mentioned above.
Here’s the Rollup Formula: SUBSTITUTE(ARRAYJOIN(values), “,”, “-”).
Desired Result: Ben-Levy-Yakov
I want the 3 names to be in alphabetical order. Can the Batch Update App help with that? I assume it will not work on theLast Name field in the Guests table.
Formulas and rollups cannot sort. Batch Update will only sort linked records by the primary field. Since the last name is probably not the primary field Batch Update probably won’t help you. The order of values in rollups matches the order of linked record fields.
By the way, here is a simpler rollup formula. Does the same thing, but just a little simper.
Yes, this is different.
You can open the linked record field cell and drag-and-drop the linked records to rearrange the order.
You can use scripting to rearrange the order.
You can use Batch Update to re-order by primary field value.
I also write an app for the Marketplace for sorting linked records. However it is still in review at the moment.
If you want a script to run automatically, you can design it to run as an automation script. If you want the script to process records in bulk, it can do that too. It is all in how you write the code. However, typically is is difficult to have an automation script run on records in bulk unless it is set to run on a schedule versus being triggered by an individual record.
I’ll send you a direct message with more info on trying out the pre-release version of my app.