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!
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.