Lock values once form is marked complete

  • 0
  • 1
  • Question
  • Updated 12 months ago
  • Answered
I have a form that I would like to lock all values once the form is marked finalized.  If formulas or values in linked tables change I do not want the values to change if the form is marked finalized.

What is the best way to do this?  Do the values need to be copied to another table when the form is marked finalized?
Photo of QBuser


  • 370 Points 250 badge 2x thumb

Posted 12 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
I suggest that you explore the use of what is called snapshot fields to freeze the value of any lookup fields. That will take care of the values form other tables issue.

The set a Role Permission for some roles not to allow editing once the record is marked as Final.