Searching for Cities only within an Address

[mlipa]

I’ve noticed that when you Import, Create, or Edit a record containing an address field you’re required to separate the address, city, state, etc. Documentation also states that in the background the Address is saved under separate columns and not as a single string.

However, in the search component you don’t get any of that granularity. When you drag in an address in the builder search component it shows all the fields, but on the front end you’re not actually able to see the separate fields.

So the issue we are having is if we are searching for a certain City, the Address “contains” search provides not only cities with that name, but also any streets that may also have that same name. I’d rather not have to create a separate field to search from when the data is already there.

From a user standpoint having the same address form layout as when you Create or Edit an address would be nice. Alternatively, allowing me to choose which portion of the Address Field I want searched would also work.

[GREDDIE]

You can edit the address field and decide which fields are in that collection. another alternative is to just create your own separate text fields for the address, personally I find this easier.

[andreas]

Had the same exact issue
If you want to keep the auto complete function, you need the adress field. What I did is using an equation field to just get the city value of the adress field and I just use that in my search components. I just recently switched to that. Beforehand I used a textformula which also worked but the search operators are way more limited on text formulas. It’s basically limited to variations of “is”. With the equation field you can use “contains”

[mlipa]

That works great, thank you!

I tried to use a pipe, but it wouldn’t let me select the City part of the address. This is far simpler.