Skip to main content

Multiple Rollup System

  • August 12, 2023
  • 1 reply
  • 17 views
L
Forum|alt.badge.img+1

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? 

 

1 reply

C
Forum|alt.badge.img+5
  • corb1
  • Inspiring
  • August 15, 2023

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
Terms & ConditionsAccessibility statement