Forum Discussion
- QuickBaseCoachDQrew CaptainNo problem.
Just set the access properties for their role in that table to be able to view, and add records, but "modify none". - danieldanielQrew CadetThank 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. - QuickBaseCoachDQrew CaptainYou 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?
- danieldanielQrew CadetYes. 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].
- QuickBaseCoachDQrew CaptainYou 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. - danieldanielQrew CadetMaybe i am doing something wrong.
Should i permission properties for this user able to view, and add records, but "modify none"? - QuickBaseCoachDQrew CaptainThey 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.