Sorting issues

[richardbabley]

Hello,

I've set up a script to sort records in a Health and Safety Database, but two of my fields are in number format, while the rest are text.

My Serial Number fields is sorting like 1, 11, 12, 2. I want it to sort numerically like 1, 2, 11, 12.

How do I fix this?

Thank you!

Richard

H&S Database Test.fmp12 2.zip

[eos]

Try this for the Sort List Key calc - and make sure the popup selection field is Sort Selection, not Sort List Key.

Also, you should check the options for the Serial Number.

Let

( [

theSortField = GetField ( Sort Selection ) ;

theSortName = GetFieldName ( theSortField ) ;

fieldTypeIsNumber = PatternCount ( FieldType ( Get ( FileName ) ; theSortName ) ; "number" )

] ;

Case ( fieldTypeIsNumber ; Right ( "00000000" & theSortField ; 9 ) ; theSortField )

)

Will work till your billionth record!