Dec 01, 2018 03:27 PM
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’.
For example:
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 :frowning:
Thanks!
Dec 03, 2018 10:55 AM
If you want to track the role of the person, what you describe is OK to me. 3 tables:
You could check the Projects that a Person has worked in in the People table, you should have a Linked Records field to Roles, or you could Group/Filter the Roles table by the Person name.
PD: I haven’t used the template you are using.
Dec 03, 2018 02:55 PM
Hi Elias, thanks so much for sharing this - I will take a look and play around with what I have and follow your suggested connections. It may make sense for me to start a fresh one, but this is really helpful either way.
Thanks!