Number Sorting Issues

addedtouchphotos's Avatar

addedtouchphotos

22 Sep, 2017 04:25 PM

This has been an issue for a long time but it still remains one. Timestone has a weird way of sorting numbers. It will sort numbers based on the first digit, regardless of the actual value. For instance, 1111 will come before 703, despite the value being higher.

The main issue is that when I print to jpeg, windows will correctly sort the 703 before the 1111 because the value of the number is smaller. This causes issues when trying to print item sheets sorted by homerooms etc. Especially when using the "stacked" feature in order to cut things with a stack cutter. The order of things can get quite jumbled.

I have attached two screenshots to show how it currently sorts and how I think it should be work.

  1. Support Staff 1 Posted by Dino Apolito on 25 Sep, 2017 02:47 AM

    Dino Apolito's Avatar

    It looks like your homeroom is field is a TEXT field in which case it is sorting correctly for a text field.

    If this field needs to be a TEXT field (because you might have characters in there) you will need to pad the numbers. Eg
    001
    002
    076
    121

    If that field only ever contains numbers and you want it sorted like numbers then the field needs to be of INTEGER datatype. See the attached where the 'Sort' field is an Integer and is sorted ascending to achieve the result you want.

    HOWEVER BE WARNED
    If you change the field to Integer now, any text that might be in there in any jobs will be erased.

    If you want to go down this path I suggest you make a new field for future jobs and leave current field alone.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Already uploaded files

  • Current_Sorting_Mode.jpg 225 KB
  • Ideal_Sorting_Mode.jpg 230 KB

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac