One application is score by 10 reviewers (users) in the Scoring Table. Need to show the Reviewer information on to the scoring table. But a reviewer can only see own information. Other reviewers should not know who are the others reviewers to that application. When I create 10 users fields in the Application Table and then do the lookup on to the Scoring Table, then all the reviewers know others reviewers. When I create one User-List than also lookup shows all the reviewers.
What is the best way to handle this?
Question
1 Application is score by 10 reviewers (users) in Scoring Table. (1 Application table has many Scores)
+1This topic has been closed for replies.
On the reviewers table, I would create one field for Reviewer (user type) (not 10.) Besides this you can have the other fields for scores, comments et all. Then set custom permissions on the reviewers table for all roles (other than the administrator) to say that only show records where "Reviewer" is the current user. And the same for Edit permissions.
+1Thanks for your quick response. I have 2 tables - 1 application have many scoring. I do not have a reviewer table. Manager of that application gives permission to 10 reviewers to review the application and add the scores to the scoring table. But on the scoring form, I wanted the information of the reviewer according to the user selected by the Manager on to the application. I was planning to create the reviewer table ...
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.