Adding x multiple rows of data based on Qty

AppSheet AppSheet Q&A
, ,
1

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?

2

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-table/m-p/328381

2 Likes
3

Thanks, I will check it out.

1 Like
4

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.

2 Likes
5

But be sure to ask when you need help!!

1 Like