Discussions

Expand all | Collapse all

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

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

     
    Posted 10-26-2018 19:21
    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? 


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

    Posted 10-26-2018 19:35
    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.


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

     
    Posted 10-26-2018 19:46
    Thanks 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 ... 


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

    Posted 10-26-2018 19:50
    In that case it would be the scorings table, not the reviewers table.


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

     
    Posted 10-26-2018 19:56
    OK, thanks.