Address field to include location hyperlink when "save as spreadsheet" exports the records

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
Within the form I have used an address field that generates a link to Google Maps as expected. I want this URL to carry into a CSV file when I do a "save as spreadsheet".
Is this possible - thanks for any advice.
Photo of GerryD

GerryD

  • 174 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
You'll want to make a formula url field that structures the address to the equivalent as the google maps url.

Something similar to:

https://www.google.com/maps/dir/"&; URLEncode([Store - Address: Street 1] &"+"& [Store - Address: City] &"+"& [Store - Address: State/Region] &"+"& [Store - Address: Postal Code])
Photo of GerryD

GerryD

  • 174 Points 100 badge 2x thumb
ok, thanks for the quick reply - let me give that a try.  Best!
Photo of GerryD

GerryD

  • 174 Points 100 badge 2x thumb
Getting a syntax error - 
>>>>>>>>>>>>>>>>>>

The argument list of the function https must begin with a left parenthesis.


https  ://www.google.com/maps/dir/"&; URLEncode([Store - Address: Street 1] &"+"& [Store - Address: City] &"+"& [Store - Address: State/Region] &"+"& [Store - Address: 
Postal Code])
Photo of Matthew Neil

Matthew Neil

  • 31,418 Points 20k badge 2x thumb
Sorry, yeah any formulas just need to begin with a " and close with "

You'll need to swap out the fields [Store - Address: Street 1], etc. for your own fields too.