Filter On Address Field

By: Frank O Redey | Asked: 12/08/2023
ForumsCategory: Code HelpFilter On Address Field
Frank O Redey asked 4 months ago
All, I am looking for a way to filter a View on an Address Field.  An Address Field however is not available in the Filter Entries dropdown of a View.  Appreciate the help. 
Rob LeVineRob LeVine replied 4 months ago

How do you want to filter? Please be specific about your use case.

Frank O Redey replied 4 months ago

I'd like to filter in a View, using the View's "Filter Entries" GUI. I'm new to Formidable, not sure how to better describe how I want to filter... thanks.

3 Answers
Rob LeVineRob LeVine answered 4 months ago
Well, there's not going to be an out-of-the-box solution to comparing an autocomplete address field to what's in the database, however, if you want to filter such that you're checking to see if "Main St." is in the address, I can suggest a way to do that. Again, a use case would help. User logs in, user selects X, enters Y and then...etc.
Frank O Redey answered 4 months ago
ok, thanks:  Starting condition:  I have a large number (10k+) of Entries of Home Addresses generated via Google Address in Form A (hence they are each unique).  I am now storing the Addresses in a one line "Text" field since View Filters support Text fields.  Next:  A user later uses Google Address to enter a unique address into a Form B (same one line text field captures the Address). Goal:  I'd like to be able to Filter Form A's list of addresses with Form B's user entered address.  I am using a nested View structure - View B passes a param=address to View A's View Filter.  Since Google Address generated both A an B addresses, there should be the ability to uniquely match.   However:  1) setting Form A's View Filter to "equals" returns "No Entries".  2) using "like" or "starts with" returns multiple non-unique Form A entries. Thanks in advance for any suggestions.    
Rob LeVineRob LeVine answered 4 months ago
The image you attached came across so small I can't see it. I created a form with a text address, a "regular" address field, and an autocomplete address field and when I used the filter to find part of the address, the correct rows were returned to me. [Autocomplete Address Field] [Like] [City Name]

Making the Best WordPress Plugin even better - Together

Take on bigger projects with confidence knowing you have access to an entire community of Formidable Experts and Professionals who have your back when the going gets tough. You got this!
Join the community