How To Make an Inventory Management in Appsheet

Create Your Own Inventory Management from Scratch using AppSheet
INVENTORY MANAGEMENT VERSION 2 Part 1
• AppSheet Inventory Man...
Inventory Management Version 2 Part 2:
• AppSheet Inventory Man...
Version 3:
• Introduction AppSheet ...
More Tutorials Below
Appsheet Edit a Table Using Another Table
• How To Modify a Data T...
Create your own payroll payslip in Appsheet
• How To Create a Payrol...
Create your own TAX Invoice App Printable Using Appsheet and Google sheet
• How To Create a TAX In...
Create Your Own POS Restaurant System
• How to make your own P...
How to Autofill Columns in AppSheet
• How To Auto Fill Data ...
Create a Dynamic Dashboard
• Appsheet Dashboard View
#appsheet #GoogleSheet

[@JoeTayactac]

VERSION 2 OF INVENTORY MANAGEMENT Part 1: kzbin.info/www/bejne/f3zUnmiFr95_kLM VERSION 2 OF INVENTORY MANAGEMENT Part 2: kzbin.info/www/bejne/mWjTd3Wkgq6Lbrs Updated formula. For repeating items bug OF THIS VERSION TimeStamp 22:39 Action 1 Set Values of some columns of this row: Available Stocks= Any(Select( Release Stocks[New Available Stocks],[Reference]=Maxrow("Release Stocks","_Rownumber"))) Time Stamp 33:08 Set Values columns of this row Available Stocks = Any(Select(Add Stocks[New Available Stocks],[Reference]= Maxrow("Add Stocks","_rownumber")))

[@gipre2892]

Unable to find column 'reference' Please Help

[@vtjoe9181]

@@gipre2892 check your column names in your data base and appsheet

[@s2_p_2524]

Hi Joe , just a quick question please , can we add another sheet which says PRODUCT LIST and have CUSTOMIZED DROP DOWN based on model of phone ( as per your latest video on 9sep please ) or any other way to do it ? Thanks

[@JoeTayactac]

@@s2_p_2524 sure 101% possible. Just create a new table in google sheet and upload in appsheet.

[@s2_p_2524]

@@JoeTayactac thanks buddy 🙂👍🏼. So basically back end Google sheet can be updated using Mobile app and Manually in sheet right ? Not necessarily just through app .🤔

[@dzeips]

God damn this is much better than 99% of other tutorials that do not explain or show shit. Plus your accent sounds cool and makes this more interesting. Freaking 10 point to you for that man. Thanks, this is very beginner friendly.

[@romaine3063]

Not all heroes wear capes. You sir are a hero to mankind, saving us bare mortals from despair.

[@nataliusmarani6281]

This is the best appsheet tutorial I have seen, thank you Joe, I appreciated so much for the effort you put to produce this teaching video

[@DelannaLeonard]

Definitely better than most tutorials I've seen but still a little too fast and not in depth enough for a complete beginner like myself. It's still good to watch, you do still learn a lot from the video.

[@JoeTayactac]

You can watch the version 2 of this here kzbin.info/www/bejne/f3zUnmiFr95_kLM easy to follow

[@sarangfaldu8328]

you are the best maaan you dont know how much you have contributed to the world economy. keepup with the good work🙂👍

[@harikrishnanaa5472]

I like the way he begin the video without any eating much time .... Cool❤

[@tumushimeronnie4501]

This was very helpful. Thank you so much for this knowledge

[@user-co4sd6ob1y]

Great training, very clear explanation. :)

[@dincerdogan804]

Thank you, this is so useful video for app sheet learner

[@josepadilla5589]

Excellent Joe

[@user-fi2tj4ob6f]

Excellent job. Istill waiting for part 3of IOS restaurant

[@jennifercook4998]

Thank you! Awesome video!

[@augustorachitoff3473]

Hi! Thanks for this video. Is there a wey to calculate the inventory value? First in first out?

[@rexverzeblazo4518]

thank you for very informative system that you made. if gives me an idea to use it.

[@mrq8608]

Awesome, thanks for the great explanation

[@JoeTayactac]

Your welcome

[@s2_p_2524]

Great video Joe . Thanks for detailed explaination . Will try it out 🙂👍🏼

[@JoeTayactac]

Make sure to check the pin comment for updated formula

[@s2_p_2524]

@@JoeTayactac Yup , I did check the updated formula . Thanks 🙂

[@s2_p_2524]

@@JoeTayactac just a quick question please JOE … can we get an alert or notification in app or through mail or message when inventory item hits below set number please ?

[@arifsayyed9967]

​@@s2_p_2524 interesting, did you find out

[@hashi_saga99]

Thank you so sooo much ...

[@mustafaisildak]

Hi. If you extend it from the bottom right corner after selecting 1000 and 1001, it will continue as 1003.

[@deribekaske2114]

Thank you so much for sharing such valuable information. I tried to adopt the way you did to create an Inventory management in AppSheet. However, the change made in Release Stocks and Add Stocks did not appear in the Stock Inventory. What could be the reason? If you want to see the AppSheet, I can share you.

[@artilleryx9540]

Thanks dude

[@leohkhung]

Thank you very much

[@Hahe87]

Hi Joe, thanks for the tutorial; it is really helpfull. How about an inventory management with warehouses? Do you have any tutorial on this?

[@ElectronPCFix]

Hi Joe thanks for the video . How about request and approval for item to be issued from the store.

[@ElectronPCFix]

I mean adding approvers

[@AmalSri_Motivator]

keep it up!

[@user-qj9sr2qm9i]

@Joe Tayactac at 3:20, How did you delete whole empty column???? May I know??

[@user-qi2yc5rz1r]

Helo Sir, this is a very helpful Information you provide, my senior give me the task to make leave application for teacher, can you guide me as you can have time. thank You

[@therryedouard9255]

In behaviour for event action mine is saying Row Selected instead of Form Saved. Thanks to help me about this.

[@yutthakansuklar6715]

Hi I have a Erro " There is already a row with the key "xxx If I try to release the same product . Please help me fix this problam

[@temitopebejide4806]

Nice one Pls I have a question

[@dannydamian-xy7eq]

You can use DEREFERENCE instead of SELECT to make things simple

[@shahanasks]

Awesome. Liked it. How to add a new item into the stock inventory? Should we add it in the google sheet directly?

[@jmonipa9222]

Yeap

[@ahaltas]

Nice job. Can you give the project web address? Can I review your project?

[@daranoun3000]

Hi Sir. For Quantity Column, if we release stocks two times(a time 5 items and one more time 10 items) it calculate wrong quantity in Stocks Inventory. Thnaks

[@JoeTayactac]

Checkout version 2 here kzbin.info/www/bejne/f3zUnmiFr95_kLM

[@kimatpatel9660]

Hi Is it possible to do a consolidated daily ,weekly or monthly report for my inventory app, i.e I have many items in stock control app and each item has many stock in and out entries so would like know how to combine various entries as one with sum up quantity and total in order to make report compact and concise

[@JoeTayactac]

Hi do you mean similar to this? kzbin.info/www/bejne/a3i4iXWZhqqhg7s

[@pascualhernandez3460]

Hi, when I try to add a new qty with a repeted Item Code, it does not let me add it. What is the reason?

[@JoeTayactac]

Check your key column. Use only item code as key column in items table. In adding stocks use key column something like reference I'd or number. You can apply a unique I'd expression in this column and use this column as your table key column.

[@melissajl2285]

Is it possible to combine both the inventory system and a POS system ?

[@JoeTayactac]

Sure its possible

[@HomeGardensgp]

Can i add new Products on this table?

[@JoeTayactac]

Yes

[@martinvanzon8904]

Everytime I edit one of the released stocks it will subtract more out of the stock inventory, how do I fix this?

[@JoeTayactac]

Hi please check pin comment for updated formula

[@martinvanzon8904]

@@JoeTayactac Yeah, I have tried that, but it still doesn't work right, maybe I'm doing something else wrong?

[@lighttornyi3931]

Did you find a solution now

[@rasikagunarathna846]

❤❤❤❤❤❤❤

[@kylehubbard3197]

when releasing and adding stocks for the same item, the calculation is way off for me. I had 58 to start for an item, released 8, added 8 and added 42, and it's showing 66 available on stocks inventory but in the new available stocks it shows 108. Any idea why or how adding numerous lines for one item is calculating inaccurately

[@JoeTayactac]

Is your app you make it multiple items? Or same as this sample video?

[@kylehubbard3197]

@@JoeTayactac Same set up as the video, but multiple transactions releasing and adding stock for one item

[@JoeTayactac]

@@kylehubbard3197 I have a recent upload for multiple items . If you like check it out. You can email me the behavior screen shot expression and the virtual columns to my email. Check my YT page email is there

[@brs.b_n9639]

I have the same problem!

[@deepakmaharana7601]

There is a bug in this video. Though very nicely explained, I also followed the learnings for my inventory app development. Problem is with the formula in the new action (video timestamp - 33 : 10 The formula used was Any(select(Add Stocks [New Available Stocks], [_thisrow].[Item code] = [Item Code])) This formula always finds the very first New Available Stocks in the list of records of a particular item & update it as the stocks of that item in main inventory page each time. So better replace it with the following formula Any(select(Add Stocks [New Available Stocks], [Reference] =MAXROW("Add Stocks","_RowNumber"))) This will fetch data from the lastly added row. i.e. row with maximum row number & updates stock correctly. Hope this will resolve the issue. However this video is really really helpful. Many cheers to that .

[@AppSheetVijay]

Hi Sir, i am try to this but there is an error to calculate. can you please help me also I want to user decimal instead off number.

[@fernanobra7267]

can you explain further how the formula works in execute an action on a set of rows in behavior. thanks

[@JoeTayactac]

Usually use if you wanted to update or trigger an action against another table.

[@aastralnature996]

Hi sir, This is inform to you,I am created a app using your instruction fro this video. But I am share app link,then it open aas browser only. How to run in mobile as a app. Pls.Help me ...

[@JoeTayactac]

You need to install the appsheet app from AppStore

[@aastralnature996]

@@JoeTayactac Thanks you sir

[@rajadey1552]

Sir, I have created a simple data entry form. But when someone opens the app, he can see all the data and they also can delete. Can you tell me any way to stop it sir?

[@JoeTayactac]

Hi, You can read more about appsheet slice, use editable if in column settings or security filter

[@ashokiv6091]

The expression is valid but its result type 'Yes/No' is not one of the expected types: Number - Getting this error while making a update formula

[@JoeTayactac]

Try to add =Any

[@brunhenk]

Hi Joe! How Update data in the Google Sheet Data? My App don't save in the Sheet if I don't edit the product. Exemple. Is I buy 10 Cellphones. In the Stock available safe 10 because of the virtal collum. But, in the Sheet Data, the Stock it is with 0. Do you undertand me? I'm waiting... Thank you very much.

[@lokeshpandey8567]

If you edit add and released quantity ots not giving right result

[@JoeTayactac]

Please check pin comment for updated formula

[@chinthakafernando679]

Hi sir! I make this app as you explain in video. It doesn’t work adding stock and release stock functions. Can you help me to resolve this please? Thank you.

[@marklaroco8547]

Hello sir I have a question, it is possible to add a price in item?

[@JoeTayactac]

Obcourse you can do. You can checkout my latest inventory video

[@marklaroco8547]

@@JoeTayactacoh God, thank you

[@marklaroco8547]

@@JoeTayactac BTW can you send me the link of the tutorial? cause Id check your channel and a lot of video, idunno what part of it, thanks

[@tanmaylonkar7552]

Can this be converted into a Mobile app using Appsheet? How to do so, if possible?

[@justinsanchez1929]

hello how can I add new item? thank you

[@prajktarajurkar9380]

Could you make a time and action plan app..

[@JoeTayactac]

Hi Im not sure whst kind of app is that. Can you explaun further

[@GaynardVelasco]

Hello Sir,, ok naman sya.. pero pag nakailang transaction ka na sa isang item nagiiba na ng computation.. paano kaya ang gagawin ko sir

[@JoeTayactac]

Use webhook instead of action.please check version 2 sa description

[@narimantagiev]

Напишу коммент

[@user-dy9dj3nw6d]

propar not work

[@shiazasif8058]

Can you make video on below Where GST Number will be entered by user Once its entered Gowdown Name will appear which is linked to GST Number And a Drop down will appear where user will select multiple Reatilers linked to Gowdown Once Multiple Reatilers are selected Clicked Next All Reatailers will appear in a page Table Format Which will have Columns Inovice Date, Invoice Number, Invoice Value, Claim Amount(Invoice value - 50%) Where user will fill and Submit multiple entries Above data will be in google sheets

[@focuswallah]

Problem with while releseing stocks

[@user-xr2ni3ed5d]

is AppSheet is free???

[@JoeTayactac]

Hi, Free as long as you kept the app as prototype and max user is 10

[@hog2.827]

hi Joe, i have tried it but i have a small doubt. In my app (Primary views->release Stock->Behaviour->Event Action->) for me it is always "Row selected" but for yu it is "For Saved " How? And after i release a stock it is not reflecting in Stock inventory can yu please help me with it @Joe Tayactac

[@JoeTayactac]

Check this version Part 1 kzbin.info/www/bejne/f3zUnmiFr95_kLM Part 2 kzbin.info/www/bejne/mWjTd3Wkgq6Lbrs