Adding x multiple rows of data based on Qty

[anthropaulogy]

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?

[WillowMobileSys · Accepted solution]

Refer to the post below for explicit details on how to create this feature.

NOTE: there is text at the bottom of the post that looks like regular text but they are actually expandable to get more details.  This is a side-effect of the recent migration from old to new forum.

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Add-any-number-of-rows-from-any-row-within-a-tab...

[anthropaulogy]

Thanks, I will check it out. 

[anthropaulogy]

Thanks for the heads up on this, it showed me it can be possible.  Now I just have to figure out how to implement it in my system, but that is for me to figure out.

[WillowMobileSys]

But be sure to ask when you need help!!