Sorting Issue - 1,10,2,3,4,5,6,7,8,9

Help Center Get Answers
1

I’m having a simple problem and can’t seem to find a solution:
My table is sorting items in a weird manner: 1, 10, 2,3,4,5,6,7,8,9
Any creative ways to force it to sort items in the correct order?

I have tried renaming the other numbers 01,02,03, but Knack removes the 0

Thanks for any help!

1 Like
2

I have the same problem, and couldn’t find a solution without Javascript.

What would be needed from Knack is a new equation type that converts a text into a number.
On such a numeric field, it would be possible to sort properly.
If some text can’t be converted, “NaN”, blank, or zero could be used.

If you need a temporary solution though, it’s possible to create a task and convert from there, using this rule:
Set “number field” to field value of “text field”.

But it will be a “one-shot” deal.

Cheers,
Normand

3

You can do as Normand said but with a Conditional Rule instead of a Task so the fields will stay in sync.

4 Likes
4

@KnackPros That’s a very elegant solution, indeed.

It gave me the idea of try the same thing but with a record rule and it also works nicely.

So with both the task as a first pass to update the exiting records, combined with one of the two rule methods will solve the problem completely.

Cheers,
Normand

1 Like