Map view option for database tables
¿ªÔÆÌåÓýHi, ? I found the example database table in beta for local food establishments and like the way it links to Google Maps. ?I¡¯ve exported that and created an identical table in my test group (on a free plan at present) but do not see the option to switch between map and list views.? I¡¯ve found messages on beta which suggest that this functionality has been around for a while so I¡¯m wondering why I don¡¯t see it. I have some questions therefore: ? 1 ¨C is this functionality still just in beta (and if so when is likely to be generally available)? 2 - is this functionality restricted to subscription plans? 3 ¨C the column names in the beta table for address values are all prefixed with ¡®Address:¡¯.? Is this a requirement to determine address fields that link to a Google search? 4 ¨C Are the US address fields names (such as City, State & Zip) mandatory or could they be UK equivalents (Town, County & Postcode)? ? ? Thanks, Andy ? |
|
On Sun, Jan 6, 2019 at 06:18 PM, Andy W wrote:
I found the example database table in beta for local food establishments and like the way it links to Google Maps. ?I¡¯ve exported that and created an identical table in my test group (on a free plan at present) but do not see the option to switch between map and list views.?I'm pretty sure that feature is unavailable to groups on the Basic plan. See?? Regards, Bruce? -- The system Help is your friend.??/static/help |
|
From: [email protected] [mailto:[email protected]] On Behalf Of Bruce Bowman
toggle quoted message
Show quoted text
Sent: 06 January 2019 23:44 On Sun, Jan 6, 2019 at 06:18 PM, Andy W wrote:
I found the example database table in beta for local food establishments and like the way it links to Google Maps. ?I¡¯ve exported that and created an identical table in my test group (on a free plan at present) but do not see the option to switch between map and list views.? I'm pretty sure that feature is unavailable to groups on the Basic plan. See? Regards, Bruce? Thanks Bruce, That covers the answers to my first two questions and leaves the last two outstanding: 3 ¨C The column names in the beta table for address values are all prefixed with ¡®Address:¡¯. Is this a requirement to determine address fields that link to a Google search? 4 ¨C Are the US address fields names (such as City, State & Zip) mandatory or could they be UK equivalents (Town, County & Postcode)? Regards, Andy |
|
On Mon, Jan 7, 2019 at 07:05 AM, Andy W wrote:
3 ¨C The column names in the beta table for address values are all prefixed with ¡®Address:¡¯. Is this a requirement to determine address fields that link to a Google search?I believe the Address: prefix is to make it easier to import a csv file, but I haven't played with it much. I just did a quick test using 47 Dolphin Road Shoreham-By-Sea West Sussex BN43 6PB for data, using the boxes for Address Line 1, City, State / Province / Region, and Postal / ZIP Code (in that order), along with specifying United Kingdom for the Country.? When I clicked on the Map link, it took me to the same Google map as when I entered the information directly into Google Maps.? Looks to me like you'd be fine, but may need to do a little 'training' for what goes in each box. Duane -- Help: /static/help GMF's Wiki: /g/GroupManagersForum/wiki Search button at the top of Messages list A few site FAQs: /static/pricing#frequently-asked-questions |
|
On Wed, Jan 16, 2019 at 08:00 AM, Andy W wrote:
I still don't see the map view option after upgrading to a premium plan.?The entire address has to be in one column?of type "address" (not text or paragraph or something like that). If you have it broken down into separate columns for address/city/state/zip it will not work.? Now click the blue Map View button at top. If you see the box in which the map should be displayed but it appears to be empty, try zooming out several times, or switch to satellite view. Default seems to be maximum zoom in roadmap view and you will sometimes end up with an empty box if there are no nearby roads. Hope this helps, Bruce? -- The system Help is your friend.??/static/help |
|
Bruce,
The entire address has to be in one column?of type "address" (not text or paragraph or something like that). If you have it broken down into separate columns for address/city/state/zip it will not work.Thanks - I have a working version now. I had the address fields in separate columns because that's how it was sepcified when I exported the other table. This means that you cannot just export table contents and load them back in elsewhere without doing some manipulation on any address fields first. Andy |
|
Hi Bob,
thanks for the update. I'll work through your steps so I can fully understand your process.? I started by exporting the beta table to a CSV. What happens there is that the single address field on the database gets split out into its sub-fields (address line 1, 2, City, Zip etc.) with a column for each. I think your proposed improvements list looks good and if implemented would add some really useful features.? I would probably like to see a summary of a Google seach for a location at one side of the map. This frequently shows pictures and for places like cafes & restaurants (which is what my table will contain) opening hours and also a link for directions. Regards Andy |
Andy Wedge
Bruce Bowman
Duane