Copy a range of text to clipboard

Hiya, I want to auto-generate a piece of text then let users copy it to their clipboard. My current solution is with the Copy to Clipboard button, but this requires a formula in the button setup. So if my users want to update the auto-generated piece of text, they’ll have to do so 1. in the text generation stage AND 2. in the button itself.

Eg in my example doc ^, the text in the doc and the text that gets copied through the button are different.

Desired outcome:
Define a range of text to copy, so if my users want to edit the template text, they only have to do this once.

Is there a way of doing this? Thanks!

You might have some luck using the format() function:

1 Like