Copy to clipboard issue
So I'm using the following formula as a Copy Content button: var text CB= URLEncode([SFY PO Number] & " - " & [HO Last Name] & " - " & [HO Street Address] & " - " & [Client Company Name]); var te...
Forum Discussion
RJ,
Have you tried to URLEncode each field, or at least the fields that may contain an apostrophe, individually. I ran into a similar issue and when I encoded the field causing the issue by itself, it fixed the issue.
------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------
Have you tried to URLEncode each field, or at least the fields that may contain an apostrophe, individually. I ran into a similar issue and when I encoded the field causing the issue by itself, it fixed the issue.
------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------
How do I do this without breaking the whole thing?
------------------------------
RJ Ilg
------------------------------
------------------------------
RJ Ilg
------------------------------
- RJ,
Actually, looking at the code. You should just be able to replace your single quotes around $CB with \" like so
"navigator.clipboard.writeText(\"" & $CB & "\").then(function(){" &
------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------That works! Thanks!
Full functioning rich text formula:
var text CB= URLEncode([SFY PO Number] & " - " & [HO Last Name] & " - " & [HO Street Address] & " - " & [Client Company Name]);
var text Alert= URLEncode("Current Job Info" & " was Copied to the Clipboard");
"<a class='Vibrant Success' style=\"border:0px solid green; background-color:green; text-align: center;-box-shadow: 0px 10px 13px -7px #000000, 9px 7px 12px 6px #000000; \nbox-shadow: 0px 10px 13px -7px #000000, 9px 7px 12px 6px #000000;\"href=" &
"javascript:{" &
"navigator.clipboard.writeText(\"" & $CB & "\").then(function(){" &
"},function(){" &
"});" &
//"alert('" & $Alert & "');" &
"$.jGrowl('" & $Alert & "');" &
"};" &
">Copy to the Clipboard</a>"
------------------------------
RJ Ilg
------------------------------- This may be a dumb question. With javascript going away how would you adjust this formula to keep working. We have used this in our app to copy a username and password field. My worry is if I start messing around with the code I will not be able to get it back.
------------------------------
Joe Rachel
------------------------------
- MarkShnier__You
Qrew Legend
Apostrophes are often a problem and URLENCoding will not fix them, as I see you are already URLEncoding.
Try replacing your first line with these two lines.
var text CBRaw= URLEncode([SFY PO Number] & " - " & [HO Last Name] & " - " & [HO Street Address] & " - " & [Client Company Name]);
var text CB = SearchAndReplace($CBRaw,"'","");
That should simply strip out the single quote and convert
Henry's to Henrys
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
