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
Solved! Go to Solution.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
Hi,
Yes, a display pattern of num{9999} will display a four digit number with leading zeros.
Good luck,
Niall
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
It worked. I was including the quotation marks. Thank you
Views
Replies
Total Likes
Views
Likes
Replies