Multiple Rollup System

[lingu]

Helo there, we have an online Online Language School, we use airtable as our database system.

I have Student, Teachers and LessonPlan tables. LessonPlan has Student and Teacher pairs.

We pay them for each lesson they taught monthly.  I would like to create a table called TeacherPayments to see Teacher-MonthYear pairs as below.


How can I create this table so that I can see "HowManyLessons" calculated automatically each month? 

[corb1]

I think you'd need to do something like:

• In your TeacherPayments table, created a formula-driven primary key that is comprised of Teacher+Month_Year, example "bsmith-8-2023"
• Create a linked field in LessonPlans that links to TeacherPayments. Fill it based on your other fields & calculations there. You may need to link future records based on a script automation that calculates from the other columns
• In TeacherPayments, create a rollup that sums the values in LessonPlans