Nelly Posted May 14, 2004 Posted May 14, 2004 Hi guys, Having seen a recent post about using the Open URL function, I thought it would be cool to use this facility in my database to look up the destinations of our deliveries via www.multimap.com. I have used the following syntax but it doesn't work and I get the equivelant of a 404 error on MultiMap's website. Can anyone see what I am doing wrong? ]http://www.multimap.com/search?&q=[zip_code] Cheers,
Nelly Posted May 21, 2004 Author Posted May 21, 2004 I had no replies to this posting but have now solved the problem for those of you that are interested. I created a calculation field combining the following URL and the postcode/zip field: "http://www.multimap.com/p/browse.cgi?pc=" & Substitute ( postcode ; " " ; "" ) The Substitute will take out any spaces in the postcode (but in the US you of course have numbers with no spaces so not a problem for you guys). I then specified an OpenURL script with the GoTo address as the calculation field and Voila! This little baby will now, upon clicking a button, go to www.MultiMap.com and show me exactly where my client, supplier, delivery address is, how fantastic!!!
Nelly Posted May 24, 2004 Author Posted May 24, 2004 Question - just out of interest, I am seeing if i can work out how to call up Australia. I worked out to replace pc with au, but i can't get it to go directly to a postcode. e.g an example of what "should" be our string for a postcode of 4000 is <a href="http://www.multimap.com/p/browse.cgi?au=4000" target="_blank">http://www.multimap.com/p/browse.cgi?au=4000</a> I can only get a map of australia. Any ideas? Is 4000 a valid post code? It didn't return anything. However, I typed 400 (random as I have never been to Australia) in and it returned the address of Mulgrave Street, Brisbane. But this was when I entered the post code from their website, not when I sent the URl from FMP7. Initially I couldn't get it to work either, took me a while to figure the UK coding. I would initially think you need to change the TLD to www.multimap.com.au and not .com. Doesn't quite work yet but something like: "http://www.multimap.com.au/p/browse.cgi?pc=" & [Post/zip code field]
Recommended Posts
This topic is 7491 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now