Referencing grid of different prices for different freelancers

Topic Labels: Base design
588 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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:

Screen Shot 2022-01-26 at 9.46.49 AM

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?

1 Reply 1
5 - Automation Enthusiast
5 - Automation Enthusiast

Would Dynamic Variables do the trick for me? Or is there another solution?