Forum Discussion

GerryDaney's avatar
GerryDaney
Qrew Cadet
9 years ago

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

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.
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    9 years ago
    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's avatar
    GerryDaney
    Qrew Cadet
    9 years ago
    ok, thanks for the quick reply - let me give that a try.  Best!
  • GerryDaney's avatar
    GerryDaney
    Qrew Cadet
    9 years ago
    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])
    • MCFNeil's avatar
      MCFNeil
      Qrew Captain
      9 years ago
      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.