Sorting Linked Records after "Find Records" automation step jumbles them 🤪

Topic Labels: Automations Formulas
Jump to Solution
2385 10
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Hi folks,

I've been trying to solve this puzzle all day; there are quite a few scripting examples in the community here that I've tried to adapt to my use, to no avail.

Here's the situation:

Screenshot 2023-04-12 152729.png

These two columns should be ordered exactly the same, except that the one on the right gets jumbled up during a "find records" step in an automation that populates this field.

They're ordered this way in the line items table, but for some reason the "find records" step jumbles them up:

Screenshot 2023-04-12 153412.png

I need a script or formula that will re-order the line items in ascending order according to the purple-circled numbers in the line item IDs. 

I have used Batch Update to do the job, but I'm looking for an automated solution that will sort the line items for use in a Zap that creates an invoice - and the line items need to be in a particular order.

Thanks for your help in advance,

Shawn : )


10 Replies 10
7 - App Architect
7 - App Architect

@InfoWrangler Would you be able to add a screenshot of your entire automation so I could see how you are using this script within the automation? Also, thanks for posting the script - super helpful! 😁