Inventory Management adding multiple items to a form and updating my automation bots

[bfloyd14]

Hi,

I am new to AppSheet and I am building an inventory management app.  My company wants to be able to track inventory based upon added inventory from a delivery, requested inventory from technicians and transfer inventory between locations.  I have the inventory updating dynamically when submitting a form for a single item and quantity but they want to be able to add multiple items and quantities to a form and then the inventory updates. 

This is where I am struggling to be figure out an expression for my automation bot that will take multiple items and quantities from a form and what is the best way to set up my form for multiple items & quantities.  

Bot expression for adding inventory:

ANY(Select(
Inventory[Available Inventory],
AND(
[Item ID]=[_THISROW].[Item ID],
[Location ID]=[_THISROW].[Location ID]
)
)
)
+ [Quantity]

Requesting

ANY(Select(
Inventory[Available Inventory],
AND(
[Item ID]=[_THISROW].[Item ID],
[Location ID]=[_THISROW].[Location ID]
)
)
)
- [Quantity]

TransferIN

ANY(
SELECT(
Inventory[Available Inventory],
AND(
[Item ID]=[_THISROW].[Item ID],
[Location ID]=[_THISROW].[Location ID]
)
)
) + [Quantity]

TransferOut

ANY(
SELECT(
Inventory[Available Inventory],
AND(
[Item ID]=[_THISROW].[Item ID],
[Location ID]=[_THISROW].[Location ID]
)
)
) - [Quantity]

Thank you and let me know if you need more information

[TeeSee1]

Try searching this community's posting using the work inventory or inventory management. You will most likely find something useful like this

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Managing-multiple-items-inventory-in-one-sale/m...

[bfloyd14]

Thank you!