While organizing an event I have this simple table:
People register on a certain date, and pay a certain amount
The same people pay what they are due a week or 2 later.
Now, here’s my thing: I want to know per day how much money is due. So if 2 people register on day 1, at the end of day 1 $30 is due
On day 2 $45 is added,
On day 2 a total amount of #30+$45=$75 is due.
On day 7 people start paying.
What system could I use to visualize per day how much money is due? In a spreadsheet you can make use of sumif / sumifs but that is not possible in AirTable.