I have seen a couple ways to remove a participant from one list when using it in a single column (table)
But what I really need to do is compare my list of available participants to an entire range of sites. Example below.
So the dropdown under each of the sites should reflect who is still in UNASSIGNED, which is HIDDEN_REFERENCE_LIST minus anyone already assigned to a site (or ABSENT, basically another site)
I'm going to have to do this, ultimately, for at least AM and PM shifts, and probably down the road, per activity hour per site, but I think knowing how to compare UNASSIGNED to multiple columns' data
and remove the used items will get me there.
For instance,
tablepic.png
Bookmarks