Click Button and Copy Query Data?

Queries and Resources
1

I have a query and I want to include a button that when clicked will copy the data in that query to the user’s clipboard. How do I go about doing that? Thanks!

2

Hey @joew! The Button component in Retool lets you choose “Copy to clipboard” as one of the actions from the “On click” dropdown. In the “Value to copy” field, you can reference {{ query.data }}.

4

hi @justin hi can I copy a json do clipboard?
image

5

If that is an array you may need to add a dot after data and see if [0] comes up and add that if it’s a singular object
{{getSelectedRemittanceOpenDetails.data[0]}}
Or try
{{getSelectedRemittanceOpenDetails.data[0].toString()
Or try
{{getSelectedRemittanceOpenDetails,data.toString()

1 Like
6

Hey @igoraguiar! Echoing @ScottR's comment, are you interested in copying a single value or the entire data object? If the latter, this "Copy to clipboard" action expects the value to be a string.

You could copy the stringified version of your data if that helps at all!

{{ JSON.stringify(query.data) }}

686×648 34.1 KB

2 Likes
7

Thanks guys. It worked perfectly with the JSON.stringify

8

Very glad to hear it :blush::clap:

9

A problem I ran into was being able to copy to google sheets. The following makes the data easier to copy and paste into your google sheets or excel:

{{ Papa.unparse(formatDataAsArray(GetActors.data ), { delimiter: '\t' }) }}