I would like to make an entire table read only except for a few fields for certain roles

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
Hi

I would like to make an entire form read only except 5 fields where a specific role can edit. 

Currently, for my permissions for this role, I have Modify all records and for the field selection I have it set to modify for the 5 fields previously mentioned. Why is it that the user can still go in and right click every field to add, remove, and edit?

Even when do not allow any modifications, users for this role are still able to right click and add, remove, and edit.

Any help would be greatly appreciated!!
Photo of daniel

daniel

  • 190 Points 100 badge 2x thumb

Posted 9 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,546 Points 50k badge 2x thumb
Are you saying that you regular users can mess with your actual form layout?
Photo of daniel

daniel

  • 190 Points 100 badge 2x thumb
Correct. How do i prevent that?
Photo of daniel

daniel

  • 190 Points 100 badge 2x thumb
Also, in the App Access settings, i have "edit app structure and permission" unchecked. Not sure if this would have anything to do with it.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,546 Points 50k badge 2x thumb
It not seem impossible that regular users in just 1 role which is a role which does not have the ability to edit the app structure and is set at at "Basic Access" or "Basic Access with sharing" would be able to edit form properties.

Also check the column in permissions to confirm that Role cannot edit field properties.
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 8,814 Points 5k badge 2x thumb
Hi Daniel,

Are you making use of an Everyone on the Internet User? Also do you have the checkbox for Edit field properties checked on that table for that role?
Photo of daniel

daniel

  • 190 Points 100 badge 2x thumb
Thank you for the reply.

Their App Level Permission is set to basic.

Currently, I have the "edit field" checked because I want this role to modify a specific fields. I also have custom access so that the user is able to edit those fields.

I believe i do not have "everyone on the internet user" set.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,546 Points 50k badge 2x thumb
You are mixing up allowing a user to edit data in fields with edit field properties.  You should uncheck that setting.

If you want to control the ability to edit fields at the field level them you need to go into each field individual and set the role access.

Typically I would do that via form rules and not field properties thought. I suggest that you use form rules.

Mark
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 8,814 Points 5k badge 2x thumb
Mark is correct, that checkbox to Edit Fields is to allow that role the ability to edit the field settings on the back end. It gives them access to adjust their own field permissions and change things about the field types, display settings, etc. 
Photo of daniel

daniel

  • 190 Points 100 badge 2x thumb
Thanks Mark. You are spot on in my situation.

How would I be able set up form rule for specific users? Say I would like "Role A" to only edit Field 1 and Field 2
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,546 Points 50k badge 2x thumb
You would need to make a form rule
When the user is in the role Role A

Make read only
.. and then you will need to list every field that you need to lock down in separate actions.

ie you cannot make just certain fields editable, you need to make all the other fields non editable.