AnsweredAssumed Answered

script to read first three of zipcode field to determine borough

Question asked by shoe3697 on Jan 2, 2018
Latest reply on Jan 2, 2018 by TonyWhite

Have a zip code field where user enters 5 or nine digit zip code. Would like to read first 3 characters and auto populate a Borough field with the correct entry. For example, if Zipcode starts with 112xx, or 112xx-xxxx the Borough field would auto populate with "Brooklyn". If Zip code starts with 100, or 101 or 102, Borough field auto populates with "New York", to represent Manhattan.

Outcomes