Hello Community! I am having a little trouble configuring something in my base that I’m hoping you can help with. Essentially, my team runs clinics in the community (daily, different locations). We have the following set-up:
Table 1: Clinic Schedule
Table 2: Personnel (organized by staff type)
I’d like to figure out a way to assign staff to clinics in Table 1 using a linked field, but in a way that allows a process of elimination - meaning that if somebody has already been assigned to that particular date, they cannot be assigned to more than one clinic. The caveat here is that we obviously need to schedule those nurses for multiple days in a row. Is there a way to set up my base to support this? Thanks in advance!