Cardbox > Forums > Macros and Programming > "postcode macro across multiple records"
postcode macro across multiple records
Posted By | Post |
---|---|
greenkeeper | 28-Oct-2015 11:23 i have created a macro to open up google maps and search for the postcode which is great, how would i then apply this macro across multiple records? so that all post code searches would plot on to google maps. |
bert | 28-Oct-2015 12:55 Did you find how to show more than one marker on Google? |
greenkeeper | 28-Oct-2015 13:44 there is a way that would involve adapting the java script but that might be a little messy is there any other map providers that you would recommended for this ? |
bert | 28-Oct-2015 14:47 Well, I Googled... and found that it is possible to show more markers on a map - just using the address bar in your browser (url). I do not know where the limit is (yet). How many postcodes you want to show? Gathering postcodes in your Cardbox database is of course no problem. |
greenkeeper | 28-Oct-2015 15:03 it would be 30 -35 max, what line of code would i need to include in the macro to make this possible at the moment i use this to show a single address x = fields("p_code") |
bert | 28-Oct-2015 18:16 Collection the postcodes is actual a little basic and written in the Cardbox macros manual... However: 'Collect the postcodes in my selection start at record 1 Variable postcodes offers you a list of all Postcodes. |
bert | 28-Oct-2015 18:39 'two things forgotten |
bert | 28-Oct-2015 22:10 For building and URL perhaps this brings you some wisdom: Within 2048 characters you can enter a lot of postcodes. |
greenkeeper | 29-Oct-2015 09:29 so would these lines of code just go under the others? |
bert | 29-Oct-2015 10:17 First: try whole code and see what is happening. Change it to your needs. '-------------------------- |
greenkeeper | 29-Oct-2015 10:45 na i can't get that to work at all... above works for one but any other combination of the other two codes doesn't bring up anything other then an error mesage unternated string constant |
bert | 29-Oct-2015 11:21 apostrophe too much... |
greenkeeper | 29-Oct-2015 11:38 so that opens up the message box with postcodes as expected now i am stuck as to then launching these on to map system, looking at it, it should be where fields would be Msgbox |
bert | 29-Oct-2015 13:06 You asked: "postcode macro across multiple records" Instead the msgbox line you need of course a line for launching your browser. |
greenkeeper | 29-Oct-2015 13:19 TRUE |