Forum Discussion
https://resources.quickbase.com/db/bq8meiyhh?a=dr&key=22
------------------------------
Nicodemus Schoenwald
------------------------------
- AnthonyGuillen12 years agoQrew Cadet
I was looking for this solution, so that I could quickly copy the value of a field into clipboard, to then paste into a procurement system during data entry. This solution from the Code Page Samples worked perfectly.
For others who, like me, may not be very skilled at these kinds of things, here's some additional steps. Took me a while to figure out, so maybe this will save someone some time:
The code linked by Nicodemus (https://resources.quickbase.com/db/bq8meiyhh?a=dr&key=22) utilizes javascript, which can still be used in QuickBase in "code pages."
- Go to your app's "Home" and click on settings icon.
- Go to Pages > + New Page > Code Page
- "Page Name" should be as the code page sample advises, "CopyText.html"
- Copy-Paste the sample code directly into the page, no modifications needed
- Save and make note of the "Page ID" of this new page
- Go to the table in the app where you want the Copy Button
- Create a new field of type Formula -URL
- Paste in the Formula URL from the sample code
- You only need to change two things in the formula: 1) The page ID to match your code page's ID, and 2) Replace [text] in URLEncode([Text]) with the actual field you want to copy
- Change Link text to something short like "Copy" or "To Clipboard"
- Change Open Target to In popup.
- Place the field wherever you want it, in a form or a report
When you first try to use the button, your browser may ask for permission to access the clipboard. Say yes, and that's it!
------------------------------
Anthony Guillen
------------------------------- SanketShah2 years agoQrew Member
Thank You @Anthony Guillen for the detailed explanation, this worked for me!
------------------------------
Sanket Shah
------------------------------
- LB3 months agoQrew Cadet
What if you need to copy more than one field to the clipboard? how do I add that to the formula?
- MarkShnier__You3 months agoQrew Legend
Huh? Inherently when you copy to clipboard it just copies one thing right? If you wanted to copy two fields you'd have to make a formula text field which would combine those two fields.
- LB3 months agoQrew Cadet
The instructions provided above say to create a Formula URL field, how do I identify within that formula to copy more than one item when the user to clicks the button to create a copy to their clipboard and paste to an external location such as a word doc...