Forum Discussion

AnnuG's avatar
AnnuG
Qrew Trainee
7 years ago

1 Application is score by 10 reviewers (users) in Scoring Table. (1 Application table has many Scores)

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 shoul...
Forms
Tables and fields
SuryaExpert's avatar
SuryaExpert
Qrew Assistant Captain
7 years ago
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.