I know this should be simple, but I'm trying to get a zero to display as the first character in a field when necessary. For example last 4 of SSN. Any help would be appreciated.
Solved! Go to Solution.
Views
Replies
Total Likes
Hi,
You can achieve this in the Patterns dialog. Select the object and go to the Object > Field palette. There you can click the Patterns button and edit the Display Pattern.
For example, this would display a number without leading zeros: 12
num{zzz9}
Whereas if you use 9 it will display leading zeros: 0012
num{9999}
Hope that helps,
Niall
Views
Replies
Total Likes
Hello Tony,
can you please elaborate your doubt, means would you
like to make a field zero as the starting character.
please give a clear example.
Thanks,
Debadas
Views
Replies
Total Likes
Hi,
You can achieve this in the Patterns dialog. Select the object and go to the Object > Field palette. There you can click the Patterns button and edit the Display Pattern.
For example, this would display a number without leading zeros: 12
num{zzz9}
Whereas if you use 9 it will display leading zeros: 0012
num{9999}
Hope that helps,
Niall
Views
Replies
Total Likes
Sorry Debadas about the lack of clarity.
@Naill, yes it does.
Thought the Allow Zeros check box would have been the answer, but it wasn't
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies