To make this more simpler to manage, while you are dumping AWS data into quickbase, create a user field (lets say, client user) in your quickbase table. While pushing the data via API, push the client email address into the QB user field (client user) along with other information.
On your QB table, create a formula fields to control the permissions for users. I usually control the permissions using formula fields and then use this field in roles to give custom permissions to user role.
Example:
View allowed-Client User (Formula Text) = If [Client User] = User(), "Yes", "No")
Edit allowed-Client User (Formula Text) = If [Client User] = User(), "Yes", "No")
With formula fields you can achieve and control complex permission.
Now go to user roles and set custom permissions on
view => use View Allowed-Client User ='Yes'
Edit => use View Allowed-Client User ='Yes'
------------------------------
Babi Panjikar
------------------------------
Original Message:
Sent: 10-30-2019 14:53
From: Buddy Webster
Subject: User Dashboard Only Access
Is there a way to give a single user access so that when they login they only see information and projects that are associated with them, without them being the record owner? For example, we have an API dumping AWS information into Quick Base and we want to give a single user access to view that data only pertains to them. Our current thought is to create a single user, create a role for the user, and create a dashboard for that single user. In other words, their could be 25 users, 25 roles, and 25 dashboards.