search

cityofaustin / atd-data-tech

Austin Transportation Data & Technology Services
17 stars 2 forks source link

KNACK - Living Streets - Restrict zip codes to 5 characters only #17609

Open atdservicebot opened 5 months ago

atdservicebot commented 5 months ago

What application are you using?

Smart Mobility Office Portal

Describe the problem.

Hi there,

In the Living Streets Knack portal, please restrict all zip code fields to be no more than 5 characters long please.

Describe the outcome you'd like to see when this feature is implemented.

some users put in a 9 digit zip code with a dash, and that messes up some of the powerBI functions

Describe any workarounds you currently have in place or alternative solutions you've considered.

manually deleting the extra digits

Requested By Jonathan S.

Request ID: DTS24-115215

patrickm02L commented 2 months ago

9/3/24 Sync with Karo

To implement this, we need to create a custom field and map it accordingly. Currently, the address field includes the street name, street number, and ZIP code. We'd need to parse this with custom code, which is quite complex.

We recommend exploring a solution in the spreadsheet to create a custom script that removes the dash and the last four digits of the ZIP code.