Best way to keep track of payments in a synced view
Hey there, I'm stuck at this point and really hope some expert could help me out.
As a language center, we collect payments from the students in phases. We have a "master" table including students' information, I then sync the view to another base for payment tracking. I really want to keep using that "synced view" for accounting purpose, because then I don't have to type in the whole list of names again. In another way, I want to keep the information consistent and save time from creating and updating many lists for different departments in the company.
However, for the accounting base, I can't add rows below each student's name (as it is a synced view!) to track their different payments (divided into 4). I had to track those veritically (adding columns instead of rows) and this causes some inconveniences. I want to filter the Data by status, for example "Due soon" or "Overdue" and see the sum of the amount of money we expect to collect in the future, but the current format won't allow that (it couldn't filter only the DUE payments because there are 4 payment stages with different status).
Can I keep the synced view and still be able to do the filtering based on payment status? Below is how the table looks like and I need to be able to see the "red" status only and their summary number.
