I am building an expense tracking app… The transaction database contains all, you guessed it, the transactions (both credit and debit). The key thing to note is this database contains transactions for all users. I do not want to allow users to add a debit transaction that would take the balance to negative. As there is no form validation and no way to group the database records by customer ID, I am kind of in a limbo. I am 90%. there to publish the app and this is becoming a showstopper.
Any advise on how to handle this?
Note: Hope Adalo puts the Series A $8MM funding into good use to enable most sought after features.