# Validate complete and incomplete addresses **URL:** \ **Category:** Ask for Help\ **Created:** [November 20, 2024, 11:38am UTC](https://community.glideapps.com/t/validate-complete-and-incomplete-addresses/78058 "2024-11-20T11:38:00Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![agung\_taufik1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik1/32/80541_2.png) [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)\ **Post date:** [November 20, 2024, 11:38am UTC](https://community.glideapps.com/t/validate-complete-and-incomplete-addresses/78058/1 "2024-11-20T11:38:00Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/0/50bbdded3391bd62e71788671e31f0cc0cfcd915.png) 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) ) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 21, 2024, 12:14am UTC](https://community.glideapps.com/t/validate-complete-and-incomplete-addresses/78058/2 "2024-11-21T00:14:44Z")
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? ---
**Author:** ![agung\_taufik1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik1/32/80541_2.png) [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)\ **Post date:** [November 21, 2024, 7:42am UTC](https://community.glideapps.com/t/validate-complete-and-incomplete-addresses/78058/4 "2024-11-21T07:42:28Z")
> [@ThinhDinh](#): > > But I guess you would have to validate other cases than just PT/Kantor? 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 ---
**Author:** ![agung\_taufik1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik1/32/80541_2.png) [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)\ **Post date:** [November 21, 2024, 12:24pm UTC](https://community.glideapps.com/t/validate-complete-and-incomplete-addresses/78058/5 "2024-11-21T12:24:09Z")
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? ---
**Author:** ![micheal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/micheal/32/80181_2.png) [@micheal](https://community.glideapps.com/u/micheal)\ **Post date:** [November 21, 2024, 12:24pm UTC](https://community.glideapps.com/t/validate-complete-and-incomplete-addresses/78058/6 "2024-11-21T12:24:29Z")
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 ---
**Author:** ![agung\_taufik1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik1/32/80541_2.png) [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)\ **Post date:** [November 21, 2024, 12:26pm UTC](https://community.glideapps.com/t/validate-complete-and-incomplete-addresses/78058/7 "2024-11-21T12:26:46Z")
I am still using the free version. Can map integration work with the free version? ---
**Author:** ![micheal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/micheal/32/80181_2.png) [@micheal](https://community.glideapps.com/u/micheal)\ **Post date:** [November 21, 2024, 12:30pm UTC](https://community.glideapps.com/t/validate-complete-and-incomplete-addresses/78058/8 "2024-11-21T12:30:41Z")
ohh nope. I guess you’ll have to create various scenarios then ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 22, 2024, 12:22am UTC](https://community.glideapps.com/t/validate-complete-and-incomplete-addresses/78058/9 "2024-11-22T00:22:48Z")
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.