I'd like to lock a record after its marked "inactive" to all users except for Admin. Is it doable?

I'd like to lock a record after its marked "inactive" to all users except for Admin. Is it doable?

I already have a "custom rule" where the Project Manager is equal to the current user - can i add another rule to that role?

I also have some summary reports under that record - is there a way to also lock those once the project is marked inactive?

see attachment

Image https://d2r1vs3d9006ap.cloudfront.net/import_topic_images/38419/original.PNG

Image https://d2r1vs3d9006ap.cloudfront.net/import_topic_images/38419/original.PNG

Daniela

0 Points

Posted 3 years ago

3 years ago

QuickBaseCoach App Dev./Training, Champion

59,768 Points

You can add to you rule that the
Inactive Oroject is unchecked.

Ie they are allowed to edit if they are the Project Manager and also if the inactive project is unchecked.

If that table of Client Contacts is a child of the Project, then just lookup that checkbox field to the child contacts and use it in a Custom Rule as well.

Comment

2 years ago

jeanne

374 Points

I need to lock a record from being updated by anyone other than the admin once it has a complete date. I am new QB and unsure how / where this rule would be written. thanks for any help you can provide

Comment

2 years ago

QuickBaseCoach App Dev./Training, Champion

59,768 Points

I suggest a setting in Role Permissions for the restricted Roles as a custom Rule. Set that Ro,e to be able to modify records where that the date complete is blank.