Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to validate zip codes against a list/table

Topic Labels: Formulas
127 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,

I need to validate zip codes in applications against a list of zip codes within certain city limits. For example, if an applicant submits a zip code and it’s not listed in my other table containing a list of eligible zip codes, there would be a column flagging me something like need verification or ineligible.

Is there a formula or some way to do this? Thank you!

1 Reply 1

There are several ways of doing this. Probably the easiest way would be to create an automation that searches the zip code table, and if no matches are found (i.e. the length of the results is 0), then update the application record with your flag.