How do I disable edits after users create records

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • In Progress
Hi everyone,


I would like to lock the "edit" button after users add a completed record. This would disable the ability to change users first record. Is this possible?


Any help would be greatly appreciated.


Thanks!
Photo of daniel

daniel

  • 190 Points 100 badge 2x thumb

Posted 10 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
No problem.
Just set the access properties for their role in that table to be able to view, and add records, but "modify none".
Photo of daniel

daniel

  • 190 Points 100 badge 2x thumb
Thank you.

How do i set it so that users are able to "edit" only certain fields. Meaning, users are able to enter data in all fields but have the ability to only edit some.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
You mean that for a new record they can enter data into [Field A], but then after the record is saved they can no longer edit [Field A], even though they can edit the record?
Photo of daniel

daniel

  • 190 Points 100 badge 2x thumb
Yes. They should be able to enter data into [Field A], but unable to edit [Field A] after saving. But also, on the same table, they enter data into [Field B], and still have the ability to edit [Field B].
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
You can do this with Dynamic form Rules.

Make a  formula numeric field called [Record ID# mirror] with the formula of

[Record ID#]

It will be used on form rules and for reasons unknown it does not let you base a Form Rule on the [Record ID#] field.

Make a form Rule

When [Record ID# mirror] is equal to (blank) 
Action
Make editable [Field A]

Now, if the user goes into Grid Edit they will not be subject to that restriction.  So to block that you need to make a dummy form with no fields on it, and then in Forms Usage set that field to be used for Grid Edit for that Role.
Photo of daniel

daniel

  • 190 Points 100 badge 2x thumb
Maybe i am doing something wrong.

Should i permission properties for this user able to view, and add records, but "modify none"?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
They will need to be able to modify all records assuming that you want them to be able to modify all records, but just certain fields.