I am using Airtables to hold a table of my customers and their credit limits etc and keep a tally of invoices sent and their payment status.
I was wondering…
Next to where the customers credit limit is, I would like a column that shows their current credit usage.
IE.
IF invoices table,column.invoicespaid = no then sum amount where invoices table,column.cutmoner name = thistable.accountname
Is this possible?
Hopefully you understand my attempt at an example formula