Field-level permissions when Current User is Record Owner
Hello,
I would like to restrict access to specific fields based on the current user. From a post from 2018 it sounds like this was not possible at that time, and I'm having difficult figuring out how to do it with the current environment - is this still not possible? Here's the old post: https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MID=33464&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer
In my case, suppose that I have a table called "Parts," which contains a field that is the "Part Price." I want my "Administrator" role to be able to see the prices for all Parts. However, I want the "Participant" role to be able to view/modify the prices only for parts where they are the Record Owner. I still want the "Participant" to be able to view/modify other fields in the Part record, just not this "Part Price" field. So I can't use the table-level View/Modify "when user is Record Owner" option, since this would hide the entire record.
I know that I can hide the "Part Price" using Dynamic Forms, but I still need to hide it from the "List All" and other reports. And if the "Participant" is able to create reports I assume they could just choose this field for their new report. I could make the field unselectable for reports, but I still want the "Admin" to have full control with this field.
Does anyone have any suggestions for this? Thank you for your help!
------------------------------
Graeme
------------------------------
I would like to restrict access to specific fields based on the current user. From a post from 2018 it sounds like this was not possible at that time, and I'm having difficult figuring out how to do it with the current environment - is this still not possible? Here's the old post: https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MID=33464&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer
In my case, suppose that I have a table called "Parts," which contains a field that is the "Part Price." I want my "Administrator" role to be able to see the prices for all Parts. However, I want the "Participant" role to be able to view/modify the prices only for parts where they are the Record Owner. I still want the "Participant" to be able to view/modify other fields in the Part record, just not this "Part Price" field. So I can't use the table-level View/Modify "when user is Record Owner" option, since this would hide the entire record.
I know that I can hide the "Part Price" using Dynamic Forms, but I still need to hide it from the "List All" and other reports. And if the "Participant" is able to create reports I assume they could just choose this field for their new report. I could make the field unselectable for reports, but I still want the "Admin" to have full control with this field.
Does anyone have any suggestions for this? Thank you for your help!
------------------------------
Graeme
------------------------------
