Help

Alphabetize Rollup Result

Topic Labels: Formulas
3410 12
cancel
Showing results for 
Search instead for 
Did you mean: 
Jason_Hull
4 - Data Explorer
4 - Data Explorer

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?

12 Replies 12

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.

Awesome! Thank you. :thumbs_up:

Megan_Smith
4 - Data Explorer
4 - Data Explorer

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