I am trying to convert grid of information with different prices for different writers into a workable Airtable solution that I can use every week for payment to them.
Here is an example of the grid in the Excel file we’re currently using:
So, say that Writer A writes a feature and Writer B writes two CD reviews. I need to be able to select the writers and the type of story and have the price come in automatically.
Let me know if there are more questions that need to be answered, Thanks!
ADDENDUM: OK, so the above grid exists in its own table. Then I have another table that I use to tally every week’s stories and payments. How should this first table be set up so the second table can reference the writer and the type of story to then receive the correct price?