Is there a way to password protect a certain record in a table? I would like to require a password to view the form for that certain record.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Photo of Greg

Greg

  • 0 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,168 Points 50k badge 2x thumb
Rather then trying to contrive a password protection scheme, why not just make a Role with a custom rule.

Call the Role  people who are allowed to see record ID 1234.

And then assign only authorized users into that role in addition to their own.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,168 Points 50k badge 2x thumb
One more thing, and obviously each of the regular rolls will need a custom rule that says the users are not allowed to view record 1234
Photo of Greg

Greg

  • 0 Points
Thank you, I added a checkbox to certain records and created a new role for users who are allowed to view the records.  This is working well but the records needed an actual checkbox and not a formula checkbox to be hidden.
Photo of Nathan

Nathan

  • 60 Points
You could make a field with the password([passwordKey]), then make a input field ([password]) and create a edit or view(this would still be a edit record) button (depending on what way you want the access to work) then you can tell the system if [password] does not equal [passwordKey] then hide headers. You would also need a rule that say upon save change [password] to null. A little janky but it could work.