Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Using Linked Records for Project Assignments

183 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

0 Replies 0