Help

Multiple Rollup System

Topic Labels: Base design
644 1
cancel
Showing results for 
Search instead for 
Did you mean: 
lingu
4 - Data Explorer
4 - Data Explorer

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.
LessonPlan.png
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.
2023-08-12_23-16_1.png

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

 

1 Reply 1
corb1
6 - Interface Innovator
6 - Interface Innovator

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