Skip to main content
Question

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

  • March 10, 2017
  • 0 replies
  • 147 views
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.
      This topic has been closed for replies.

      • MCFNeil
      • Registered
      • March 10, 2017
      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])
      • GerryDaney
      • Author
      • Registered
      • March 10, 2017
      ok, thanks for the quick reply - let me give that a try.  Best!
      • GerryDaney
      • Author
      • Registered
      • March 10, 2017
      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])
      Terms & ConditionsAccessibility statement