integrated Google Maps Formula.
Good Morning All,
I have a formula in pleace in which im trying to add an option for to select if i display a pin location on google maps by either, name of the business, the street address, the city or postcode. at the moment it only takes the first part of the fimula and displays the pin based on the street address bit will not showe anything if 'client name', 'city' or 'postcode' option is selected. Please can anyone offer a solution, Thank you.
4 replies
-
-
Terry,
Would you please post what the final src string is supposed to look like.
""equates to nothing when you are building a string so I don't know why that is in there. Also, in this formula I would use aswitchstatement instead of nestedif-then-else, but that's my personal preference. Finally, I would use theswitchorif-then-elseto build the googlequery string only. You can then write yourdo as serverjust once after the string is built. -
Hi Sean,
as you can tell i am new to Ninox, farly impressed with the system at the moment apart from a few restrcitions. I juts want to be able to instruct google to display the location pin in maps on either the street name, compnay name or postcode, this is to be done via the dropdown menu. Thank you terry.
-
Hi Terry,
It's possible to do what you want in Ninox, but I don't know if it's going to work in Google Maps. I tried your code from just the "Street Address" condition and didn't use "do as server". While it did bring up Google Maps, it didn't bring up the address or plot a pin. You can set up individual formula fields to see if each of the conditions work on their own (not using if-then). Another test is to return "googlequery" without the
html()function so you can see what the returned string looks like.For what it's worth, I would get a new key from Google and stop using the one you posted ;)
Sean
Content aside
-
1
Likes
- 4 yrs agoLast active
- 4Replies
- 2143Views