I’m new to airtable, and have used a ‘video production’ template to use for my small production company.
I have various projects ‘project title’, and various contacts are listed as ‘crew’ on the projects. I work with the same people on various projects, so when a new project is created and I add the relevant crew as part of the team, additional columns are created listing the ‘project title’.
Project Title #1 - Producer is Person A, Editor is Person B.
Project Title #2 - Producer is Person C, Editor is Person D
Project Title #3 - Producer is Person A, Editor is Person D.
When I look at the Person record, it should show me all project titles they’ve worked on in one column, but it creates additional columns with each new project.
How do i fix this? I’m going around in circles