Lock record from edits after a certain condition is met

  • 1
  • 1
  • Question
  • Updated 2 months ago
  • Answered
Hi all,

I'm currently trying to track the person who changed a particular status to 'Closed', without the added capability of QuickBase's audit logs atm.

Right now, this is my text formula and it's working fine.

If ([Status]="Closed",UserToName([Last Modified By]))

However, there is a possibility that this might be changed in the case whereby someone modifies it accidentally afterwards, etc. 'Closed' entries should only be available for viewing and not editable afterwards - unless allowed.

I wonder if there is any way i could 'lock' the record in place from any future edits so that the information recorded is as accurate as possible? Or that a particular group of user would be unable to edit henceforth unless an administrator changes the 'Status' to open, etc.

Thank you!

Regards,
Samuel


Photo of Samuel Goh

Samuel Goh

  • 382 Points 250 badge 2x thumb

Posted 2 months ago

  • 1
  • 1
Photo of Rob White IV

Rob White IV

  • 1,070 Points 1k badge 2x thumb
I would simply set a custom permission for editing records on that table for each role you want to check.

The custom permission would only allow editing privileges for that particular role if the status was not equal to closed.

Of course, allow admins to always be able to edit in case you ever need the override you mention.

Hope this helps!

~Rob
Photo of Samuel Goh

Samuel Goh

  • 382 Points 250 badge 2x thumb
This works well. Thank you!

Regards,
Samuel