adding dash after 5 character in zip code
I have a address field and which is having postal code as a sub field , so my question is like after i am entering 5 numbers a dash symbol must come. Do i have any native QuickBase option
Forum Discussion
I presume you are talking about Zip + 4 where there is an optional suffix.
one suggestion is to have the Zip field be called [Zip 5] be a text field and set the field properties to limit to 5 characters. Then have a field called [Zip 4] and limit to 4 characters. Show these in add and edit mode.
Then have a formula field
List("-", [Zip 5], [Zip 4])
This presumes that your data entry is by hand and not imported.
one suggestion is to have the Zip field be called [Zip 5] be a text field and set the field properties to limit to 5 characters. Then have a field called [Zip 4] and limit to 4 characters. Show these in add and edit mode.
Then have a formula field
List("-", [Zip 5], [Zip 4])
This presumes that your data entry is by hand and not imported.