Validate complete and incomplete addresses

Ask for Help
1

image
image1057×232 14.2 KB

I need help validating addresses to ensure they are complete.

Here’s the concept: A warehouse admin will input the shipping address provided by customer service. If the address is intended for an office location, the address must include the words “Street” (Jalan) and the name of the office/company to be considered complete.

Example:

  • PT/Kantor Muda Gemilang, Jalan Dr. Husein Kartasasmita No. 365, Kel. Banjar, Kec. Banjar, Kota
    (This is complete because it contains both the name of the office/company and the word “Street” (Jalan).)

If the input is:

  • PT/Kantor Muda Gemilang, Dr. Husein Kartasasmita No. 365, Kel. Banjar, Kec. Banjar, Kota
    (This is incomplete because it only includes the word “Kantor” (Office) but does not have the word *“Street” (Jalan) )
2

Add an If-Then-Else column.

If Input Address does not include “Jalan” then return nothing.
If Input Address does not include “PT/Kantor” then return nothing.
Else return true

But I guess you would have to validate other cases than just PT/Kantor?

4

Yes, that’s right, apart from validating office/PT addresses, there are other addresses that must be validated, for example school addresses and many more

5

Thank you, this method worked.
This is similar to the formula “IF(AND(ISNUMBER(SEARCH”, right?
What if we add “OR” to it? Can this be done in Glide?

6

If you want to validate the address of any place, like you said, I think you need to use the map integration.

But if it’s a regular pattern they all follow then thin method is best

7

I am still using the free version. Can map integration work with the free version?

8

ohh nope. I guess you’ll have to create various scenarios then

9

Not sure what you mean by the Excel/Google Sheets formula, but if you can line out all your logic, we’ll try to help.