Re: Valid if 5 digits for zip code field

Tom_automated · 10-28-2020 05:18 AM

I have a data field zip code that I have set to address type. What’s the expression I need to validate that the field is 5 digits only?

I’m looking for something like: matches("[0-9]{5}"). Yes, I realize I can set it to number but I’d like to pull up the zip code on the map. Thanks in advance.

Steve

Valid If:

([_THIS] = RIGHT(("00000" & NUMBER([_THIS])), 5))

Tom_automated

As I said, I have this set as type address because I need the geocoding. There is no max/min details for type address. I tried just the Valid If expression but that fails.

Koichi_Tsuji

It dont think the data of 5 digit will not be recognized as address even we set the data type like that.

Steve

Valid If:

AND(
  (LEN([_THIS]) = 5),
  ([_THIS] = RIGHT(("00000" & NUMBER([_THIS])), 5))
)

See also:

Tom_automated

It does. Or at least appears to. I have my address split as a combination of Street + City + Zip. I have set each field as address. I can View Map of (Street) or View Map of (City) or View Map of (Zip) in the Deck view. In the Map view I have set the combined Address as the Map column. Now when I click the View Map of (Street) in the Deck View, it shows a map with the deck. If I click View Map of (Zip) or city in the deck view, it shows me a more zoomed out map and the deck.