Hi all!
I am fairly new to the AppSheet community, so please bear with me.
Goal: when I purchase X QTY of a certain product, I want to create X rows with that same info on a separate table. The reason for choosing to have one row = one item, as opposed to just doing a sum of that particular product, is so that I can move that one product to different locations, have a specific cost attached to it, and to keep track of how much is used on that item.
I have 2 tables:
INVENTORYLOG [ProductID] [QTY] [Cost]
SUPPLIES [ProductID] [Cost] [AmtRemaining] ...
I need to add X rows to SUPPLIES based on [QTY] from INVENTORYLOG. Is there any way to do this with Automation?
LinkedIn
Twitter
