I have a collection with credit and debit amounts. The debit amounts need to be approved by someone. Here is what my Transaction collection looks like
ID, Amount, Type, Valid
1, 5000, Credit, True
2, 2000, Debit, True
3, 4000, Debit, False
4, 1000, Debit, True
I want to sum only the records where Valid is True.
However, my custom filter has an option to choose a column but does not allow me to specify what the value should be. Is this a bug in Adalo or my naivety?
Here is a screenshot