Expand my Community achievements bar.

Learn about Edge Delivery Services in upcoming GEM session
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

4 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