Sort Text or Alphanumeric Fields in Numerical Order

Is there a way to sort alphanumeric fields on a pick ticket/advanced PDF so they sort like this:
1
2
100
Rather than this:
1
100
2
Rookie Asked on January 22, 2020 in Items.
Add Comment
1 Answer(s)

One thing I have done is to create a custom transaction line field exclusively for sorting line items in the PDF.  You can define a formula using LPAD, for example:  LPAD({field}, 5, ‘0’) to generate values like:  00001, 00002, and 00100, which would then sort correctly in the PDF.  You don’t have to display the sorting field, it can just be used for ordering a list.

Rookie Answered on January 22, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors: Tipalti