Lock all relationship fields by clicking a "lock" button?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Mark Shinier...I would like to talk to you about this "vision"
Photo of Lynne8817

Lynne8817

  • 600 Points 500 badge 2x thumb

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 69,572 Points 50k badge 2x thumb
is there a specific question that you can post here?  Otherwise, I can be reached via the information in my profile.
Photo of Lynne8817

Lynne8817

  • 600 Points 500 badge 2x thumb
I would like to be able to "lock" and entire record.  I have "jobs" in a table that has hundreds of fields &  many relationships.  Once the job has been "completed", I would like for the record to lock so that any changes made to relationships and/or fields going forward will not be altered in the completed job record.  thx
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,572 Points 50k badge 2x thumb
No problem.

Just set up a Custom Rule Role Permissions to only allow Edit when job status is not Completed

Do a lookup of that Job Status field to all children and grandchildren tables, the set up similar Custom Rules on all child tables too