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 f...
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.