Inventory Management App in Appsheet | Part 2 | Execute Action on a set of rows | Referenced Action

[@GwynethSurnit-nf5rk]

Now learning baby❤ your so intelligent😉👌💯

[@justinsilver2418]

I love your video 😍 definitely clear and practical

[@dmtauto-m9m]

Thanks a lot I tried to duplicate both actions and bot with change of plus to minus but it was not working as I thought I have to select deletes only but after this video It is working fine thanks once again. and Keep it Up!

[@ruangbelajarkuclub]

Hi..nice video, thanks for sharing. I hope u can make other video Bulk Action and multiple product updating inventory. Tq

[@mohammedhamdy7807]

Thanks

[@appsheetwithadithya]

Welcome :)

[@ncd9437]

Hi Adithya, thank you for all your videos been a great help! Question though, is there a reason as to why you have a Quantity column in your Inventory Table? When you can use a Virtual Column instead, which automatically updates the quantity without having to create an action?

[@appsheetwithadithya]

Virtual column can't be seen spreadsheets

[@jackylow86]

Nice. How about if the same inventory got different batches/different expired date? How to make it First In First Out? So that at the end, the warehouse will have the latest batch of inventory that keep in the store. In need to take in consideration purchase(In) and sales (Out) all the time.

[@appsheetwithadithya]

In reference rows select the key column of the inventory table based on the date to deduct from old dated items

[@jackylow86]

@@appsheetwithadithya hope can have a video to teach on this. Appreciate and looking forward. Excited and can’t wait for your next coming video.

[@eltabros]

Hi Adithya, I need your help on my table. Base on the action you had are only for one item and quantity in one form/table. i got a form/table with 10 items and each item got a quantity too....how to execute the action? or what formula do i need? your help is much appreciate!

[@harshvardhanjain2107]

Hi Adithya, I am learning the appsheet through you. I had a question - how to auto fill the product code when there are multiple products and every product has different sizes and other variables. For eg in your video we see one product name Laptop and it has a product I'd, but what is laptop is the product name and it has 5 different versions and then each version has a different product code, how would you pull this?

[@ThuyLe-ct9be]

Hello Adithya. I have a question, hope you to reply. I have 2 data. 1. Inventory ( has a ID Inventory col, and a quantity) 2. Purchase ( has a ID Purchase col vs a ID Inventory col that ref ID Inventory from 1st data vs purschase quantity col, vs authorization col) I want: Quantity col in 1st data only updated when the authorization in 2nd data = TRUE, if not the quantity col in 1st data is unchanged. Please help me. Thank you

[@appsheetwithadithya]

@ 05:30 In the behaviour try to give the condition and check the last row of the 2nd data of Auth = TRUE so that this action works only if authorization = true