Jump to content

Flag a difference of opinion where ID is the same


OnTheOutside
 Share

This topic is 5727 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Greetings,

I can't seem to find a good way to do this, lack of experience, I'm sure. I have a database of Applicants, I have some Reviewers in another table, I have a bridge table Applicant_intvscore_Reviewer so that I can assign 2 reviewers to each applicant.

When the reviewers disagree on whether to accept or deny the applicant, I assign a third reviewer as a tie-breaker.

What I need is to KNOW when there is a disagreement so that I can assign the applicant to another Reviewer for a tie-breaker.

I tried making a dup_check (applicantNum & ReviewerOpinion), search for that and then show omitted, but I get where one Reviewer has made a decision and the other hasn't made a decision yet, in addition to disagreements.

It'd be best to just show a line for each applicant that says "disagree" and then I can GTRR to that applicant's record to assign another reviewer.

Thanks for any thoughts...

Link to comment
Share on other sites

There is a field called "ReviewerOpinion" and it is a radio option. Choices are "Interview", "Reject" or "Undecided".

The reviewer has some other fields to put in a score, but the only thing I'm concerned with is if I get 1 "Interview" and 1 %anything else%. This would be a "disagree".

Link to comment
Share on other sites

Hi,

I'm not exactly sure I understood the fields involved, but just try the following: create a calculation in the join table, which holds a number according to the reviewer's opinion, then in the "reviewee" table create a sum (jointable::numField) and parse this.

e.g. hire would be 1, no hire a 2, which means that all records with a result of exactly 3 would be tied (adjust this method for other choices). Of course this field would be unstored, so for a larger number of records to be analyzed use a script or a "replace field" which automatically flags a new, indexed field according to the value in the sum field.

Another approach would be to tie the submitting of the reviewers opinion to a script (and not just choosing from a popup) and let the parent record being updated automatically to the current status.

Hope this helped.

Cheers

eos

Link to comment
Share on other sites

This topic is 5727 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.