My wife is starting a tutoring business. Some clients pay by the session, some by the month or quarter. I’m trying to create a Coda doc to help calculate a biweekly payout. For example if someone pays $1200 for three months of sessions, then I want to pay out $200 biweekly over the three months. But then multiply that for 50 clients. Any thoughts on how to go about this?
(Not actual tutoring numbers, but I like to start with even numbers while I’m working things out like this.)
hi @Wesley_D ,
you may need two tables, the first one with the course and the payment status with a button that populates the second table that keeps track of the payments per client. One client can have 6 rows (12 weeks) and a button in that second table set the status on received or open (or any status)
I’d like to advice to set up a simple demo doc, share it here and someone will be able to help you out in greater details.
Cheers, Christiaan
How about 5 tables? 
I hope you can follow my train of thought here! My main goal is to have it calculate the biweekly paycheck, after entering payments and tutoring sessions. The tricky part is that each session has a different pay rate, so that makes it a little more complicated to figure out the paychecks.
hi @Wesley_D ,
what I had in mind you see in this formula:
with this example (and the many examples in the community it should work)
good luck with the rest,
Cheers, Christiaan
