I am very new to AppSheet and I don’t know much about coding. I am trying to build an inventory management app for our factory.
3 of my relevant tables for this are “Inventory”, “Receiving Inbound”, “Shipping Outbound”. When I receive an item it is recorded and timestamped in “Receiving Inbound”. When I sell a product it is recorded and timestamped in “Shipping Outbound”. In my “Inventory” table I have a column for “Total Available”.
The problem I am having is that the transactions in “Receiving Inbound” and “Shipping Outbound” are not updating the the “Total Available” column in the “Inventory” table.
Thank you for your time!
LinkedIn
Twitter
