Hi all, how are you?.
I’m making an inventorty based on a youtube video and it is like follows: I have three columns called quantity, sold and inventory; the column “quantity” is where the inventory is primary loaded, the column “sold” is the column with the number of items sold and the column “inventory” is the one with the difference between quantity and sold columns. This last column is the one that I am showing as actual inventory, the problem comes when I want to update inventory.
The "sold column and the “inventory” column values are being calculated with sheet formulas but in the view where I can see the inventory I have the edit action which allows me to edit the original “quantity column”, not the inventory column, if I edit yhe inventory from this view I’m not editing the actual inventory count but the original whose obviosly is not the same, so, what approuch do I need to use to updete correctly or add new inventory?
Thanks in advance for the help.
If any column has an app formula or spreadsheet formula, it is not editable.
Your exact need is not clear , however once the inventory is counted by difference between quantity and sold, you may not need to edit the inventory column because it is auto computed.
You may want to mention the need for manually editing the inventory column and then community could suggest a solution if available.
1 Like
Hi @Suvrutt_Gurjar , look, I have a view where I want to add inventory, so I’m thinking of add items in the original “quantity” column and consider that column content (by row) as the record of the sum of all the items ever included in the inventory and the “sold” column (by row) as the sum of all the items ever sold, which lets me with the column “inventory” as the always updated inventory column but I don’t know if that is the correct way to do it.
Is more a conceptual problem that a technical one.
Got it. I was mainly responding to the issue you mentioned.
Inventory in general can be an extensive topic depending on how you wish to track it.
So we may not be able to discuss any specific approach you may want to use without knowing your all app goals and design and the YouTube video you are following.
Maybe someone else in the community could guide you better.
1 Like
I already solved the problem, since I needed to have a table where every new addition to the inventory was registered, I used that table and a set of actions to sum the additions to the original quantity of the specific product.
Since I will have the total sold of each product, then the difference between the total quantity of products and the total sold products will have my available inventory allways updated.
2 Likes