Skip to main content
Question

Lock record from edits after a certain condition is met

  • February 18, 2019
  • 0 replies
  • 137 views
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


This topic has been closed for replies.

  • RobIV
  • Quickbase Alumni
  • February 18, 2019
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
  • ArchiveUser
  • Author
  • Quickbase Alumni
  • February 18, 2019
This works well. Thank you!

Regards,
Samuel
Terms & ConditionsAccessibility statement