Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Question on numeric field

Tally63
Level 1
Level 1

I have a numeric field that reads Object>Field=Numeric>Pattern Display=Num.Integer()

When entering zeros as numerical data at the beginning of the number; the zeros will not appear.  Do I need to change the pattern?  Thanks

1 Accepted Solution
gkaiseril
Correct answer by
Level 7
Level 7

Click on the field that will be using the leading zeros.

Make sure this field is set to Numeric Field (Object Palette - Field tab - Type:)

On the same Field tab is a button that reads "Patterns..." click on the arrow

Click "Display" and in the "Pattern:" field type "num{99999}" (this will give you a five digit input (45=00045) adjust the number of 9's according to your need.

Do not include the quotation marks for the  text to enter.

View solution in original post

4 Replies
Niall_O_Donovan
Level 10
Level 10

Hi,

Yes, a display pattern of num{9999} will display a four digit number with leading zeros.

Good luck,

Niall

Tally63
Level 1
Level 1

Hello,

I'm sorry but I am a newbie.  Do I type that formula in the Pattern Display field or under  Zero Display?  When I type in under Pattern Display; I receive an Invalid Error message.

Thank you for your assistance

gkaiseril
Correct answer by
Level 7
Level 7

Click on the field that will be using the leading zeros.

Make sure this field is set to Numeric Field (Object Palette - Field tab - Type:)

On the same Field tab is a button that reads "Patterns..." click on the arrow

Click "Display" and in the "Pattern:" field type "num{99999}" (this will give you a five digit input (45=00045) adjust the number of 9's according to your need.

Do not include the quotation marks for the  text to enter.

Tally63
Level 1
Level 1

It worked.  I was including the quotation marks.  Thank you