Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

need help -- assigning records to committees for review

Featured Replies

I have a table of job candidates, which will need to be assigned to committees for review.

There are 6 committees.

In general, the assignments can be completely arbitrary.

candidate 1--committee 1

candidate 2--committee 2

3 - 3

4 - 4

5 - 5

6 - 6

7 - 1

8 - 2

9 - 3

.

.

. etc.

That would be easy enough I guess.. but, here's the monkey wrench. My boss will need to predesignate some of the candidates in one way or another. He may say, designate candidate 23 to committee 4

or he may say, do NOT give candidate 24 to committee 5

So, I'd like a way to allow for these manual per-candidate rules to be allowed for, WHILE at the same time, in the end, having distributed an equal (or as close as possible to equal) # of candidates to each committee.

so far,

I have the following tables:

CANDIDATE

COMMITTEE

COMMITTEE_ASSIGNMENT

I'm thinking that it is easy enough to manually assign committee assignments for instances where my boss tells me:

designate candidate 23 to committee 4

or do NOT give candidate 24 to committee 5

BUT.. how do I make is so that the arbitrary assignments, which are scripted, should compare all the assignments to the 6 committees so that it keeps them all at an even level ?

I'm lost about how to approach this. Could anyone offer any advice ? thanks ;)

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.