Google Maps - Show in Map / Show Route

AT
Member Posts: 20
I figured out how to show customers adresses in google maps without typing the adress manually in the browser. Just add a button with this code in the on push trigger to the customer card:
It is not a big thing, but sometimes a big help.
HYPERLINK('http://www.google.de/maps?f=q&hl=en&q=' +Address+' '+"Post Code"+' '+City);For the route to the customer use this:
HYPERLINK('http://www.google.de/maps?f=d&hl=en&saddr=[from street]+[from post code]+[from city]&daddr=' +Address+' '+"Post Code"+' '+City);In this example i coded the [from] adress in the button what is not the finest art. The option hl=en ist the langage of the user.
It is not a big thing, but sometimes a big help.
0
Comments
-
[Topic moved from Navision e-Commerce forum to Navision Tips & Tricks forum]Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0 -
Just a quick question on this ...
So i add a Commandbutton to the form right?
the only "push" option i see is PushAction with the choices of "Ok, Cancel, LookupOk, LookupCancel, Yes, No, Close, Stop, Formhelp, RunObject, RunSystem, Lookup Table"
where do i add that code you referred to?0 -
click on the button and then hit F9. This will open the onpush trigger. If your license does not allow development, you won't be able to do it .0
-
wierd ... we have a developer license (at least i thought we did). I can design reports and use code in them, but not on the form. I'll have to check with our other developer to double check.
thanks for the help!0 -
There are different granuales for forms and tables, and for reports that you can do development on.0
-
RogerSheets wrote:wierd ... we have a developer license (at least i thought we did). I can design reports and use code in them, but not on the form. I'll have to check with our other developer to double check.
thanks for the help!0 -
AT wrote:I figured out how to show customers adresses in google maps without typing the adress manually in the browser. Just add a button with this code in the on push trigger to the customer card:
HYPERLINK('http://www.google.de/maps?f=q&hl=en&q=' +Address+' '+"Post Code"+' '+City);
For the route to the customer use this:HYPERLINK('http://www.google.de/maps?f=d&hl=en&saddr=[from street]+[from post code]+[from city]&daddr=' +Address+' '+"Post Code"+' '+City);
In this example i coded the [from] adress in the button what is not the finest art. The option hl=en ist the langage of the user.
It is not a big thing, but sometimes a big help.
HI,
I am trying to do this.
I created another 3 fields in Contacts.
1. Routeadres text 30
2. Routepostcode code 20
3. Routestad text 30
Everyone can fill this in. This must be the homeadres.
So it must be like ?:
HYPERLINK('http://www.google.de/maps?f=d&hl=en&saddr=[routeadres]+[routepostcode]+[routestad]&daddr='
+Address+' '+"Post Code"+' '+City)
But this doesn't work. second half works but FROM adress doesn't work.
How Can I fix this ??
:-k0 -
what about using " " around the string, because the string includes spaces? Or instead spaces you can use "%20"0
-
Hi,
have a look at this code example:ContactStart.GET('KT000145'); ContactEnd.GET('KT000003'); HYPERLINK( 'http://www.google.de/maps?f=d&hl=en&saddr='+ ContactStart.Address+','+ ContactStart."Post Code"+','+ ContactStart.City+ '&daddr='+ ContactEnd.Address+','+ ContactEnd."Post Code"+','+ ContactEnd.City);
And just to have al little fun with google maps try this:[code]
http://www.google.de/maps?f=d&hl=en&saddr=München&daddr=New%20York
Especially No. 38 in the list on the left side is verry interesting.br
Josef Metz0 -
Hi,
I already solved it. \:D/
HYPERLINK('http://www.google.nl/maps?f=d&hl=en&saddr='+Routeadres+' '+Routepostcode+' '+Routestad+'&daddr='
+Address+' '+"Post Code"+' '+City);
I just forget some quotes. That's all !!
ooh yeahhhhhh ! =D>0 -
Here you can figure out which parameters are possible and what is their meaning."Money is likewise the greatest chance and the greatest scourge of mankind."0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions