Skip to main content
Question

Junction Table Help Needed: Separating Team Schedules into individual 'Shifts'

  • April 10, 2026
  • 1 reply
  • 18 views
L

Hello,

I am new to junction tables and have pretty much zero scripting experience, so bear with me.

I am trying to create a breakdown of call sheets for group shoots and create individual “shifts” in a junction table. The goal is to be able to adjust start and end times for those linked in the shoots and to be able to create a more comprehensive reporting interface to track hours and OT by multiple criteria.

I cannot show the actual base, but have created a basic example of the structure and result of Airtable’s junction table extension.

Client tab:

Franchise:
 

Franchises have assigned POCs for internal notifications. This could include executive roles/higher level visibility. Would not include anyone linked in “Shoots”

Assets:
 

Linked directly to Editors, Creative Directors, and Producers.

 

Shoots:
 

Only linked directly to Directors, Camera Techs, and Actors.

Settings for Junction Table Extension:
 


Result - Shifts (Junction Table)
 

 

As you can see, it is pulling in combinations for Producers, Editors, and Creative Directors when they are not directly linked within Shoots. Is there a way to restrict the junction table to parse only what is directly linked between Personnel and Shoots? I only want to consider the “shifts” of Directors, Camera Techs, and Actors.

Any help or advice is welcome, thank you!

1 reply

coderkid
Forum|alt.badge.img+5
  • coderkid
  • Inspiring
  • April 11, 2026

You are running into a classic Airtable junction table spaghetti!!!

Right now your setup looks like, Personnel <-> Shoots <-> Shifts (junction table)

But, Your Shoots table already links to multiple Personnel indirectly (Directors, Camera Techs, Actors, ... etc.) and Personnel table also has broader relationships (Producers, Editors, Creative Directors via Assets/Franchise)

I think you need to change your links... 1st, only link Personnel to Shoots directly (for people who actually work that shoot)

In your Shoots table, you should have fields like, Director (linked to Personnel), Camera Techs (linked to Personnel) and Actors (linked to Personnel)

In Shoots table, add a linked field (to Pesonnel) and call it "Assigned Personnel" (or something similar to this). This becomes your single source of truth for who is actually on a shoot.

Now, build the junction table, using only this field. So it will look like, Personnel <-> Shoots (Assigned Personnel only) <-> Shifts

 

Terms & ConditionsAccessibility statement