Alphabetize Rollup Result

[Jason_Hull]

I am doing a rollup on a field that has text (2-letter US State):
ARRAYJOIN(ARRAYUNIQUE(values),"\n")

I am wondering if there is any way to alphabetize the result output?

[kuovonne]

Chris_Dukes:

how do I get started writing a script to re-arrange the order in the All Guests field?

It depends on how much experience you have with writing code. If you have not written code before, start by learning to code. If you know JavaScript already, start with the Scripting Documentation

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.

[Chris_Dukes]

Awesome! Thank you. :thumbs_up:

[Megan_Smith]

@Chris_Dukes, did you ever figure out how to script the arrayjoin(values) to return a list in alphabetical order? Thanks for the reply!