Inventory WebApp with Google Apps Script and Google Sheets

In this project we will create, from scratch, a webapp that allows to easily log inputs (or outputs) for an inventory system.
➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
practicalsheet...
You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more
➤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:
➤Patreon: practicalsheet...
➤Webpage: practicalsheet...
➤Newsletter: practicalsheet...
➤Telegram: practicalsheet...
➤Facebook: practicalsheet...
➤Twitter: practicalsheet...
Any suggestion, question or insights, feel free to comment below

[@dripemusic9883]

Can you make a tutorial on how to make a webapp apps script - search, get and displaying data from specific sheet

[@sony-wuxi]

Hi sir:I have a question: There are two sheets now, sheet1 and sheet2. How to save the pictures or hyperlinks in sheet1 to sheet2 with one click of gas (it cannot be expressed in text in sheet2, it needs to be presented in the same way as sheet1)，tks

[@johnwayne-w2f]

The paetrons website is not loading

[@practicalsheets]

Thanks for noticing. I hope it is fixed by now
Kind Regards

[@firmananimator6917]

and how about protect from other people. i mean just only a few people can fill it. So it's like logging in for a new employee then accessing purchasing goods

[@practicalsheets]

If you have workspace, you will have an option for only workspace users from your company.
If not you may restrict for certain users
I´m working on that video ;)
Regards!

[@flororencio2915]

0:43 0:45 0:47 0:48 0:49 0:50 0:53 0:54 0:54 0:55 0:55 0:55 0:55 0:55 0:55 0:56 0:56 0:56 0:56 0:56 0:57 0:57 0:57 0:57 0:57 0:57 ​@@practicalsheets

[@dinozavr_kanal]

like 👍

[@robertstoner6200]

instead of getting a list then looking for the index could you not do let product = productData.find(row => row[0] === purchase.ref) then reference the appliance and cost like product[1] and product[3] cutting down on code lines?

[@practicalsheets]

Excellent suggestion. I hadn't used find before
But for sure will now!
Thank you so much!
I use those 2 in combination a lot
Kind Regards

[@robertstoner6200]

@@practicalsheets I am glad you found it useful I tend to use find and filter a lot.