Allow Users to Copy Text from Field they do not have permission to edit

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Not sure this is possible, but I have a group of users that have limited permissions. Mostly they need to grab multiple lines of text from a single field in a Grid Edit Report and use it on the internet. Because they do not have permission to edit this field they cannot select the lines of text.

I tried creating a formula field which is just a copy of the original but giving them permission to edit, but you cannot edit a formula field! 

Any other brilliant ideas besides opening up edit permissions?

Thank you!!!

Photo of Leanne

Leanne

  • 262 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 59,576 Points 50k badge 2x thumb
is the issue that the CTRL A to select the cell, does not work and sweeping the cell with the mouse is not efficient for them?
Photo of Leanne

Leanne

  • 262 Points 250 badge 2x thumb
So they can copy the entire box, but then they would have to paste somewhere else to get the info line by line. Not super efficient. Also, you cannot sweep the cell with a mouse when you do not have edit privileges or when a formula field.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 59,576 Points 50k badge 2x thumb
is this only in grid edit?  Why not mouse sweep in regular view, not edit? If you turn off the ability on that particular report to view the record, then the mouse sweep will not accidentally view the record.
Photo of Scott

Scott

  • 314 Points 250 badge 2x thumb
You could always create a formula - text field which combines all of the fields line by line into one box.  Then the user could sweep the cell (highlight all the text) and copy/paste it into whatever they need to.

Of course if the data they need to copy (the fields) change each time, then this method wouldn't work and they would have to go line by line as said above.  

In normal view, not grid edit, you could always forward users to a .js quickbase with page you have setup which will run a javascript that'd copy fields to their clipboard and redirect them back to whatever page they were on.  See http://stackoverflow.com/questions/400212/how-do-i-copy-to-the-clipboard-in-javascript for help in regard to saving to the clipboard via javascript.  

The rest is up to you I guess.