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.
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.
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.
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]
Please login or Register to submit your answer
How do you want to filter? Please be specific about your use case.
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.