LinkedIn
Twitter
First of all, this workaround is not perfect.
I expect the following features to be implemented
https://www.googlecloudcommunity.com/gc/Feature-Ideas/Copy-to-Clipboard-Action/idc-p/828027
Usage image
Create the following code in GAS.
Code.gs
// Code.gs
function doGet(e) {
// Retrieve the 'text' parameter and pass it to HTML encoded
const text = e.parameter.text || ""; // Set to an empty string if the parameter is not present
const template = HtmlService.createTemplateFromFile('index');
template.text = text;
return template.evaluate();
}
function getTextToCopy(text) {
// Decode the newline characters and return
return decodeURIComponent(text).replace(/\\n/g, "\n");
}
Index.html
<!DOCTYPE html>
<html>
<head>
<base target="_top">
</head>
<body>
<p id="status">Click the text below to copy it to the clipboard.</p>
<pre id="copyText" style="cursor: pointer; background-color: #f0f0f0; padding: 10px; border-radius: 4px;"></pre>
<script>
window.onload = function() {
const text = "<?= text ?>"; // Get the encoded text passed from the server-side
if (text) {
google.script.run.withSuccessHandler(function(decodedText) {
// Display the retrieved text
const copyText = document.getElementById('copyText');
copyText.innerText = decodedText;
// Copy text to clipboard on click
copyText.onclick = function() {
navigator.clipboard.writeText(decodedText)
.then(() => {
document.getElementById('status').innerText = "Copied to clipboard!";
})
.catch(err => {
console.error('Failed to copy to clipboard: ', err);
document.getElementById('status').innerText = "Copy failed.";
});
};
}).getTextToCopy(text);
} else {
document.getElementById('status').innerText = "No text found to copy.";
}
};
</script>
</body>
</html>
Deploy as a web app.
Set the publication range according to the situation of each application.
Pass the text you want to copy to the public URL with the text parameter.
Specifically, create and use the following Action from AppSheet.
Target Expression
"[YOUR PUBLISHED Apps Script UrL]?text="&ENCODEURL([Longtext])
e.g.)
"https://script.google.com/a/macros/miyai.jp/s/XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX/exec?text="&ENCODEURL([Longtext])
