I built this base for a nonprofit that processes corporate donations to distribute to nonprofits for a small administrative fee.
ā
It's flexible enough to track any and all types of inventories while displaying counts of both general item types and more specific donations. In addition, this base will keep track of how much contacts owe (admin fees) and what contacts have donated or received over time.
ā
It was a quick project so it could definitely be improved on but it's a solid base for other inventory needs.
ā
The base automatically creates unique and "random" contact and transaction IDs, maintains in-stock quantities, and interactions can be completed through forms which I will likely compile into a free Google website so the nonprofit I built it for doesn't *have* to interface with the database itself if they don't want to.