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...
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])