
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 12, 2023 03:37 PM - edited Apr 12, 2023 03:40 PM
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:
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:
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 : )
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 06, 2024 10:47 AM
@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! 😁

- « Previous
-
- 1
- 2
- Next »