Discussions

 View Only
  • 1.  Address field to include location hyperlink when ""save as spreadsheet"" exports the records

    Posted 03-10-2017 15:30
    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.


  • 2.  RE: Address field to include location hyperlink when ""save as spreadsheet"" exports the records

    Posted 03-10-2017 15:55
    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])


  • 3.  RE: Address field to include location hyperlink when ""save as spreadsheet"" exports the records

    Posted 03-10-2017 15:57
    ok, thanks for the quick reply - let me give that a try.  Best!


  • 4.  RE: Address field to include location hyperlink when ""save as spreadsheet"" exports the records

    Posted 03-10-2017 16:02
    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])


  • 5.  RE: Address field to include location hyperlink when ""save as spreadsheet"" exports the records

    Posted 03-10-2017 17:41
    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.