I am building a music publishing catalog using Airtable. Music Publishing is very complex due to the many songwriters and ownership splits in the form of %'s for a song.
I am creating a “Compositions” table which track the details of of each song to identify each songwriter, what role they played, and what % of ownership each songwriter is entitled to.
How do I capture the following scenario in a table to attribute the correct % of ownership to the correct songwriter on each song on the table? Even more complex, a songwriter can play multiple roles of writing lyrics and music.
Song: Manifest Prosperity
Songwriter 1: John Doe
Songwriter 2: Jane Doe
Songwriter 3: John Doe 2
There should be a total of 200% - 100% for lyrics and 100% for music.
I am new to Airtable and eager to learn and build this catalog. Anyone interested is more than happy to join!