Sort numbers issue

Tagged: ,

Viewing 2 reply threads
  • Author
    Posts
  • November 30, 2011 at 3:28 PM #3547

    Marcelo
    Participant

    Hi, this is a relly great db app always implementing new things, but i found a “problem” when sorting db using a number field. Tap forms sort in this way: 1,10,100,1000…2,20 and not in this expected form 1,2,3,4,5,6…etc… It´s an app problem or a field problem?.

    thanks…

    (excuses for my english, it´s not my country language)

    November 30, 2011 at 3:47 PM #4948

    Marcelo
    Participant

    Ok, I’ve found the problem, it´s not a number field, it´s a text field with numbers. When try to change the Field to Number in Edit Form, lost all data…What can I do?

    November 30, 2011 at 7:46 PM #4949

    Brendan
    Keymaster

    Hey Marcelo,

    If you switch back to text, your data will come back.

    You should export your form’s records and then switch the field type, then re-import your data.

    Thanks,

    Brendan

Viewing 2 reply threads

You must be logged in to reply to this topic.