Inventory System in Google SHEETS - Pt 11 - Pop up alerts low stock

In this video we will learn how to create a pop-up alert that shows us inventory items with no stock or low stock.

For this we will need to use a bit of Google Apps Script code

➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions

➤You can also subscribe to the channel where you´ll find a new Sheets video every week.

Here are some of the places where you can follow and support me:

Any suggestion, question or insights, feel free to comment below

[CrazyAvocado-smvm]

i have got here! these lessons is exactly what i was looking for!

[TimSherman]

Great video! I just added this to the sheet!

[TRCCtv]

i would like to have this workbook but your website is not working.

[TimSherman]

Also, is there a way to do a page break in the script code? Let’s say multiple items out. For it to look cleaner? Thanks

[TilakConrad]

Greetings - I've been ollowing your channel and your superb tutorials - your style of teaching is great.

Two suggestions if I may - that you might want to consider for future tutorials on extending this.

I think there should be a sparate sheet or column where each product has a specified re-order (low stock) level - I say this becuse in most organisations there will be products that have differing "low stock" levels - then these script should this "low stock" level and compare it to the "actual stock" and then make the alert as appropriate.|

The second suggetion is that the low and out of stock positions be emailed to a specified email address.

Anyway congratulations and all the very best

[dnaml]

do we have to click on run button? it is not auto alert?

[bhavneshparikh]

Add multiple godown Zone bin rack wise stock