Good morning Coda community.
I am a fledling Coda-er (Codar??) and I am working on building a fairly simple inventory management system using a couple of the pre-built templates.
Here is a simple example.
I have a list of finished goods that I can sell. When I click add sale it deducts the associated raw materials and increases sale quantity by one.
What I need help with is designing the doc so that each time I click the add sale button it adds the name of the item sold, the quantity and most importantly the transaction date to a transactions table.
Similarly, at the same time if another table could record the raw materials that were consumed, the quantities and the transaction date (same as the transaction date in the previous table) that would round it all out.
I am going to be researching further, but would greatly appreciate any help that you can provide