No video
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
Пікірлер: 105
VERSION 2 OF INVENTORY MANAGEMENT Part 1: kzread.info/dash/bejne/e3-lz5eIqtyyirQ.html VERSION 2 OF INVENTORY MANAGEMENT Part 2: kzread.info/dash/bejne/lWukqKSnfay-aLw.html 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 .🤔
Not all heroes wear capes. You sir are a hero to mankind, saving us bare mortals from despair.
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.
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 kzread.info/dash/bejne/e3-lz5eIqtyyirQ.html easy to follow
you are the best maaan you dont know how much you have contributed to the world economy. keepup with the good work🙂👍
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
I like the way he begin the video without any eating much time .... Cool❤
Thank you, this is so useful video for app sheet learner
thank you for very informative system that you made. if gives me an idea to use it.
This was very helpful. Thank you so much for this knowledge
Hi. If you extend it from the bottom right corner after selecting 1000 and 1001, it will continue as 1003.
Thank you! Awesome video!
Great training, very clear explanation. :)
Excellent job. Istill waiting for part 3of IOS restaurant
Thank you very much
Excellent Joe
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.
Nice one Pls I have a question
Thank you so sooo much ...
Thanks dude
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
Awesome, thanks for the great explanation
@JoeTayactac
2 жыл бұрын
Your welcome
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
You can use DEREFERENCE instead of SELECT to make things simple
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
keep it up!
❤❤❤❤❤❤❤
Awesome. Liked it. How to add a new item into the stock inventory? Should we add it in the google sheet directly?
@jmonipa9222
Жыл бұрын
Yeap
In behaviour for event action mine is saying Row Selected instead of Form Saved. Thanks to help me about this.
Hi! Thanks for this video. Is there a wey to calculate the inventory value? First in first out?
Can i add new Products on this table?
@JoeTayactac
Жыл бұрын
Yes
@Joe Tayactac at 3:20, How did you delete whole empty column???? May I know??
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
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
2 жыл бұрын
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.
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 kzread.info/dash/bejne/e3-lz5eIqtyyirQ.html
Nice job. Can you give the project web address? Can I review your project?
Is it possible to combine both the inventory system and a POS system ?
@JoeTayactac
2 жыл бұрын
Sure its possible
Hello sir I have a question, it is possible to add a price in item?
@JoeTayactac
4 ай бұрын
Obcourse you can do. You can checkout my latest inventory video
@marklaroco8547
4 ай бұрын
@@JoeTayactacoh God, thank you
@marklaroco8547
4 ай бұрын
@@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
Everytime I edit one of the released stocks it will subtract more out of the stock inventory, how do I fix this?
@JoeTayactac
2 жыл бұрын
Hi please check pin comment for updated formula
@martinvanzon8904
2 жыл бұрын
@@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
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
2 жыл бұрын
Try to add =Any
If you edit add and released quantity ots not giving right result
@JoeTayactac
Жыл бұрын
Please check pin comment for updated formula
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
2 жыл бұрын
Is your app you make it multiple items? Or same as this sample video?
@kylehubbard3197
2 жыл бұрын
@@JoeTayactac Same set up as the video, but multiple transactions releasing and adding stock for one item
@JoeTayactac
2 жыл бұрын
@@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
2 жыл бұрын
I have the same problem!
@deepakmaharana7601
2 жыл бұрын
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 .
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
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.
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? kzread.info/dash/bejne/Z3uJuqScgajUfbw.html
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
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.
Напишу коммент
Can this be converted into a Mobile app using Appsheet? How to do so, if possible?
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.
Could you make a time and action plan app..
@JoeTayactac
Жыл бұрын
Hi Im not sure whst kind of app is that. Can you explaun further
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.
hello how can I add new item? thank you
Problem with while releseing stocks
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
propar not work
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
is AppSheet is free???
@JoeTayactac
Жыл бұрын
Hi, Free as long as you kept the app as prototype and max user is 10
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 kzread.info/dash/bejne/e3-lz5eIqtyyirQ.html Part 2 kzread.info/dash/bejne/lWukqKSnfay-aLw.html