We should have an inventory system app developed for our customers.
So much of what you would need an inventory system to do, requires a lot of work arounds until Caspio creates more dynamic field options and cross tabulation capabilities.
My workaround was getting rid of many of my relational tables and creating one flat file table for most of the inventory transactions (which is very ugly looking with a lot of null fields)...I still use separate tables for locations, skus, vendors, etc.... but all my transactions from receiving to movements to fulfillment are all recorded in the same table.
I hope that I can eventually parse the information back into relational tables, but it was such a struggle to work with them that way with the way Caspio is designed, that I'll have to wait until Caspio creates more dynamic cross tabulation capabilities, on the client-side (and more robust client-site capabilities in general), before I go that route.
Ed Zriak commented
I am not a programer but I have built a number of inventory managment apps in MS Access during my career. Currently build a basic inventory management app using Caspio (although Caspio is somewhat limited with its standard reporting / query functions. I'd be happy to work with someone on developing business requirements for an app like this.
Dean Covey commented
I might be willing to work with someone on this as my certification project. Are we talking an inventory system of products that are bought and sold in the course of a business or are we talking about an inventory system to manage items that we own?