Number format and leading zeros

Viewing 4 reply threads
  • Author
    Posts
  • January 2, 2019 at 4:29 AM #33082

    Victor Warner
    Participant

    I would like to know whether it is possible to display a field which contains numbers with leading zeros? For example

    001
    010
    099
    100

    January 2, 2019 at 10:49 AM #33083

    Leo
    Participant

    You can use a text field for that purpose. I don’t think calculations can be made with tis format even in a number field

    January 2, 2019 at 12:58 PM #33089

    Brendan
    Keymaster

    That’s right. Number fields are designed exclusively for mathematic type purposes, so leading zeros are ignored. You’ll need to use a Text field.

    January 2, 2019 at 3:55 PM #33099

    Victor Warner
    Participant

    Thank you for the information. And problem solved by using the Format function in a calculation field which refers to an auto-increment number field.

    January 2, 2019 at 7:43 PM #33107

    Brendan
    Keymaster

    haha.. oh yes, there’s that too! :) Sorry I didn’t think of that. There’s so much you can do in Tap Forms that even I forget about some of the little things :)

Viewing 4 reply threads

You must be logged in to reply to this topic.