New to Airtable of course, trying to understand how to structure a base to track my exercise class payments by student.
In a spreadsheet, the data looks like this:
I understand this will be at least two linked tables: a student table and a class table.
The intended usage is that on any given date & time I will be giving one of two or more different classes, and after each class, I will want to enter payments from each student who attended, the amount each paid & payment method used.
How is this structured? How many tables are actually necessary? How many Junction Tables? Would a form be necessary for entering the student payments after each class?
This seems like such a simple use, but I can’t find any equivalent tables to use as an example to set up my own.
Any help is appreciated, thank you.