KimG
5 years agoQrew Cadet
Copy to clipboard button for company name/address with formatting
My challenge
Create a button that will copy several fields of data (Company Name, Company address) to the clipboard that can be pasted into a document with nice formatting. I started with the code previously listed in another thread on how to make a copy button.
The key issues beyond just a copy button that I want to address are:
My Solution
var text CB= If([Company - Address-Map: Country]="United States", URLEncode([Company Name]&"\\n"&[Company - Address-Map: Street 1]&" "&[Company - Address-Map: Street 2]&"\\n"&[Location]&" "&[Company - Address-Map: Postal Code]),
URLEncode([Company Name]&"\\n"&[Company - Address-Map: Street 1]&" "&[Company - Address-Map: Street 2]&"\\n"&[Company - Address-Map: City]&", "&[Company - Address-Map: State/Region]&" "&[Company - Address-Map: Postal Code]&"\\n"&[Company - Address-Map: Country]));
var text Alert= URLEncode("Company name and address" & " were copied to the clipboard");
"<a class='Vibrant Success' style=\"border:0px solid blue; background-color:#00275a; text-align: center;\"href=" &
"javascript:{" &
"navigator.clipboard.writeText('" & $CB & "').then(function(){" &
"},function(){" &
"});" &
"$.jGrowl('" & $Alert & "',{theme:'jGrowl-green'});" &
"};" &
">Copy Address to Clipboard</a>"
Notes:
1. Location field
My "Location" field I use in several places where a full address takes up unnecessary space. It's a formula-text field made from the default "Address-City" field and a "State Abbreviation" field (if in the US) or "Address-City" and "Country" if outside the US.
My Location field is formula-text and looks like this:
If([Address-Map: Country]="United States", [Address-Map: City]&", "&[State Abbreviation],
[Address-Map: City]&", "&[Address-Map: Country])
2. State Abbreviation
My "State abbreviation" field is taken from other threads suggestions and is a formula-text with the following:
If (
[Address-Map: State/Region]="Alabama", "AL",
[Address-Map: State/Region]="Alaska", "AK",
[Address-Map: State/Region]="Arizona", "AZ",
[Address-Map: State/Region]="Arkansas", "AR",
[Address-Map: State/Region]="California", "CA",
[Address-Map: State/Region]="Colorado", "CO",
[Address-Map: State/Region]="Connecticut", "CT",
[Address-Map: State/Region]="Delaware", "DE",
[Address-Map: State/Region]="Florida", "FL",
[Address-Map: State/Region]="Georgia", "GA",
[Address-Map: State/Region]="Hawaii", "HI",
[Address-Map: State/Region]="Idaho", "ID",
[Address-Map: State/Region]="Illinois", "IL",
[Address-Map: State/Region]="Indiana", "IN",
[Address-Map: State/Region]="Iowa", "IA",
[Address-Map: State/Region]="Kansas", "KS",
[Address-Map: State/Region]="Kentucky", "KY",
[Address-Map: State/Region]="Louisiana", "LA",
[Address-Map: State/Region]="Maine", "ME",
[Address-Map: State/Region]="Maryland", "MD",
[Address-Map: State/Region]="Massachusetts", "MA",
[Address-Map: State/Region]="Michigan", "MI",
[Address-Map: State/Region]="Minnesota", "MN",
[Address-Map: State/Region]="Mississippi", "MS",
[Address-Map: State/Region]="Missouri", "MO",
[Address-Map: State/Region]="Montana", "MT",
[Address-Map: State/Region]="Nebraska", "NE",
[Address-Map: State/Region]="Nevada", "NV",
[Address-Map: State/Region]="New Hampshire", "NH",
[Address-Map: State/Region]="New Jersey", "NJ",
[Address-Map: State/Region]="New Mexico", "NM",
[Address-Map: State/Region]="New York", "NY",
[Address-Map: State/Region]="North Carolina", "NC",
[Address-Map: State/Region]="North Dakota", "ND",
[Address-Map: State/Region]="Ohio", "OH",
[Address-Map: State/Region]="Oklahoma", "OK",
[Address-Map: State/Region]="Oregon", "OR",
[Address-Map: State/Region]="Pennsylvania", "PA",
[Address-Map: State/Region]="District of Columbia", "DC",
[Address-Map: State/Region]="Rhode Island", "RI",
[Address-Map: State/Region]="South Carolina", "SC",
[Address-Map: State/Region]="South Dakota", "SD",
[Address-Map: State/Region]="Tennessee", "TN",
[Address-Map: State/Region]="Texas", "TX",
[Address-Map: State/Region]="Utah", "UT",
[Address-Map: State/Region]="Vermont", "VT",
[Address-Map: State/Region]="Virginia", "VA",
[Address-Map: State/Region]="Washington", "WA",
[Address-Map: State/Region]="West Virginia", "WV",
[Address-Map: State/Region]="Wisconsin", "WI",
[Address-Map: State/Region]="Wyoming", "WY",
[Address-Map: State/Region]="Puerto Rico", "PR"
)
------------------------------
Kim Gardner
------------------------------
Create a button that will copy several fields of data (Company Name, Company address) to the clipboard that can be pasted into a document with nice formatting. I started with the code previously listed in another thread on how to make a copy button.
The key issues beyond just a copy button that I want to address are:
- adding spacing, commas and line breaks between fields copied
- only listing the country field when the address is not in the US
- use state abbreviations instead of states spelled out as happens when using the default fields in the Address-Map field.
My Solution
var text CB= If([Company - Address-Map: Country]="United States", URLEncode([Company Name]&"\\n"&[Company - Address-Map: Street 1]&" "&[Company - Address-Map: Street 2]&"\\n"&[Location]&" "&[Company - Address-Map: Postal Code]),
URLEncode([Company Name]&"\\n"&[Company - Address-Map: Street 1]&" "&[Company - Address-Map: Street 2]&"\\n"&[Company - Address-Map: City]&", "&[Company - Address-Map: State/Region]&" "&[Company - Address-Map: Postal Code]&"\\n"&[Company - Address-Map: Country]));
var text Alert= URLEncode("Company name and address" & " were copied to the clipboard");
"<a class='Vibrant Success' style=\"border:0px solid blue; background-color:#00275a; text-align: center;\"href=" &
"javascript:{" &
"navigator.clipboard.writeText('" & $CB & "').then(function(){" &
"},function(){" &
"});" &
"$.jGrowl('" & $Alert & "',{theme:'jGrowl-green'});" &
"};" &
">Copy Address to Clipboard</a>"
Notes:
1. Location field
My "Location" field I use in several places where a full address takes up unnecessary space. It's a formula-text field made from the default "Address-City" field and a "State Abbreviation" field (if in the US) or "Address-City" and "Country" if outside the US.
My Location field is formula-text and looks like this:
If([Address-Map: Country]="United States", [Address-Map: City]&", "&[State Abbreviation],
[Address-Map: City]&", "&[Address-Map: Country])
2. State Abbreviation
My "State abbreviation" field is taken from other threads suggestions and is a formula-text with the following:
If (
[Address-Map: State/Region]="Alabama", "AL",
[Address-Map: State/Region]="Alaska", "AK",
[Address-Map: State/Region]="Arizona", "AZ",
[Address-Map: State/Region]="Arkansas", "AR",
[Address-Map: State/Region]="California", "CA",
[Address-Map: State/Region]="Colorado", "CO",
[Address-Map: State/Region]="Connecticut", "CT",
[Address-Map: State/Region]="Delaware", "DE",
[Address-Map: State/Region]="Florida", "FL",
[Address-Map: State/Region]="Georgia", "GA",
[Address-Map: State/Region]="Hawaii", "HI",
[Address-Map: State/Region]="Idaho", "ID",
[Address-Map: State/Region]="Illinois", "IL",
[Address-Map: State/Region]="Indiana", "IN",
[Address-Map: State/Region]="Iowa", "IA",
[Address-Map: State/Region]="Kansas", "KS",
[Address-Map: State/Region]="Kentucky", "KY",
[Address-Map: State/Region]="Louisiana", "LA",
[Address-Map: State/Region]="Maine", "ME",
[Address-Map: State/Region]="Maryland", "MD",
[Address-Map: State/Region]="Massachusetts", "MA",
[Address-Map: State/Region]="Michigan", "MI",
[Address-Map: State/Region]="Minnesota", "MN",
[Address-Map: State/Region]="Mississippi", "MS",
[Address-Map: State/Region]="Missouri", "MO",
[Address-Map: State/Region]="Montana", "MT",
[Address-Map: State/Region]="Nebraska", "NE",
[Address-Map: State/Region]="Nevada", "NV",
[Address-Map: State/Region]="New Hampshire", "NH",
[Address-Map: State/Region]="New Jersey", "NJ",
[Address-Map: State/Region]="New Mexico", "NM",
[Address-Map: State/Region]="New York", "NY",
[Address-Map: State/Region]="North Carolina", "NC",
[Address-Map: State/Region]="North Dakota", "ND",
[Address-Map: State/Region]="Ohio", "OH",
[Address-Map: State/Region]="Oklahoma", "OK",
[Address-Map: State/Region]="Oregon", "OR",
[Address-Map: State/Region]="Pennsylvania", "PA",
[Address-Map: State/Region]="District of Columbia", "DC",
[Address-Map: State/Region]="Rhode Island", "RI",
[Address-Map: State/Region]="South Carolina", "SC",
[Address-Map: State/Region]="South Dakota", "SD",
[Address-Map: State/Region]="Tennessee", "TN",
[Address-Map: State/Region]="Texas", "TX",
[Address-Map: State/Region]="Utah", "UT",
[Address-Map: State/Region]="Vermont", "VT",
[Address-Map: State/Region]="Virginia", "VA",
[Address-Map: State/Region]="Washington", "WA",
[Address-Map: State/Region]="West Virginia", "WV",
[Address-Map: State/Region]="Wisconsin", "WI",
[Address-Map: State/Region]="Wyoming", "WY",
[Address-Map: State/Region]="Puerto Rico", "PR"
)
------------------------------
Kim Gardner
------------------------------