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

Avatar

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

Avatar

Correct answer by
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

0 Replies

Avatar

Level 10

Hi,

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

Good luck,

Niall

Avatar

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

Avatar

Correct answer by
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.

Avatar

Level 1

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