Discussions

Expand all | Collapse all

Lock record from edits after a certain condition is met

  • 1.  Lock record from edits after a certain condition is met

    Top
    Contributor
    Posted 02-18-2019 04:36
    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




  • 2.  RE: Lock record from edits after a certain condition is met

     
    Posted 02-18-2019 05:26
    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


  • 3.  RE: Lock record from edits after a certain condition is met

    Top
    Contributor
    Posted 02-18-2019 05:53
    This works well. Thank you!

    Regards,
    Samuel