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
Aug 17, 2022 12:19 PM
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!
Aug 18, 2022 02:38 AM
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.