Quick Base Discussions

Expand all | Collapse all

Address Field Behaviour with Properties with Names rather than numbers.

  • 1.  Address Field Behaviour with Properties with Names rather than numbers.

    Posted 03-21-2017 18:19
    Hi,

    I'm struggling to get the QB Address field to work with properties where there is a house name, rather than an house number. 

    Has anyone found a work around for this?

    Ideally I'd like to have the house name / house number in a separate field to the street/road name, but I don't think that is possible when using the standard QB Address fields.

    David


  • 2.  RE: Address Field Behaviour with Properties with Names rather than numbers.

    Top
    Contributor
    Posted 03-21-2017 18:38
    Any reason why "House Name" is not its own text field?


  • 3.  RE: Address Field Behaviour with Properties with Names rather than numbers.

    Posted 03-24-2017 18:50
    I'm struggling with the same issue. For example, I want my reports to show "Airport" rather than an unrecognizable long street address which is unfamiliar to the database users. Is this possible?


  • 4.  RE: Address Field Behaviour with Properties with Names rather than numbers.

    Posted 03-24-2017 20:15
    Agreed. We often use locations that you would be able to type in the name of the location (like "Hilton Gardens Inn, Anyplace, USA") and an application like Google Maps would at least list suggestions if the search criteria are not specific enough. With the "Location" field lookup feature being driven by Google maps, I'm surprised the lookup function is not more dynamic but it cannot find anything but addresses.
    For now I've added an extra text field for users to manually enter any place names like this though so we can show the name when appropriate and the address when appropriate.


  • 5.  RE: Address Field Behaviour with Properties with Names rather than numbers.

    Posted 03-24-2017 22:19
    I ended up creating a separate Locations table with "Names" and "Addresses", which works well for repeated locations.

    My details table has a related names field which will look up the address, resulting in functional name and address fields in my reports.

    2 downsides: A) the initial use of an address still requires a google search (ie "Hilton Gardens Inn, Atlanta) to find the correct address. B) I haven't figured out how to use one-off addresses without adding them permanently (and dirtying) the locations list. I trust there's a solution for this latter issue.