How To Make an Inventory Management in Appsheet
Vložit
- čas přidán 22. 06. 2022
- 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 - Věda a technologie
VERSION 2 OF INVENTORY MANAGEMENT Part 1: czcams.com/video/IKqm5OzyLZQ/video.html
VERSION 2 OF INVENTORY MANAGEMENT Part 2: czcams.com/video/c7pFBnMIX8Y/video.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")))
Unable to find column 'reference'
Please Help
@@gipre2892 check your column names in your data base and appsheet
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
@@s2_p_2524 sure 101% possible. Just create a new table in google sheet and upload in appsheet.
@@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 .🤔
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.
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
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.
You can watch the version 2 of this here czcams.com/video/IKqm5OzyLZQ/video.html easy to follow
Not all heroes wear capes. You sir are a hero to mankind, saving us bare mortals from despair.
you are the best maaan you dont know how much you have contributed to the world economy. keepup with the good work🙂👍
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
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.
Hi! Thanks for this video. Is there a wey to calculate the inventory value? First in first out?
Excellent job. Istill waiting for part 3of IOS restaurant
@Joe Tayactac at 3:20, How did you delete whole empty column???? May I know??
Great training, very clear explanation. :)
Excellent Joe
Thank you! Awesome video!
thank you for very informative system that you made. if gives me an idea to use it.
Great video Joe . Thanks for detailed explaination . Will try it out 🙂👍🏼
Make sure to check the pin comment for updated formula
@@JoeTayactac Yup , I did check the updated formula . Thanks 🙂
@@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 ?
@@s2_p_2524 interesting, did you find out
Hi Joe, thanks for the tutorial; it is really helpfull. How about an inventory management with warehouses? Do you have any tutorial on this?
Hi Joe thanks for the video . How about request and approval for item to be issued from the store.
I mean adding approvers
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.
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
Thank you so sooo much ...
Awesome, thanks for the great explanation
Your welcome
You can use DEREFERENCE instead of SELECT to make things simple
Thank you very much
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?
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.
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
In behaviour for event action mine is saying Row Selected instead of Form Saved. Thanks to help me about this.
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
Checkout version 2 here czcams.com/video/IKqm5OzyLZQ/video.html
Thanks dude
Awesome. Liked it. How to add a new item into the stock inventory? Should we add it in the google sheet directly?
Yeap
keep it up!
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
Hi do you mean similar to this?
czcams.com/video/5GUXBcQEnMY/video.html
Everytime I edit one of the released stocks it will subtract more out of the stock inventory, how do I fix this?
Hi please check pin comment for updated formula
@@JoeTayactac Yeah, I have tried that, but it still doesn't work right, maybe I'm doing something else wrong?
Did you find a solution now
Is it possible to combine both the inventory system and a POS system ?
Sure its possible
Can i add new Products on this table?
Yes
Nice job. Can you give the project web address?
Can I review your project?
❤❤❤❤❤❤❤
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?
Hi,
You can read more about appsheet slice, use editable if in column settings or security filter
Nice one Pls I have a question
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
Is your app you make it multiple items? Or same as this sample video?
@@JoeTayactac Same set up as the video, but multiple transactions releasing and adding stock for one item
@@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
I have the same problem!
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 .
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
Try to add =Any
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 ...
You need to install the appsheet app from AppStore
@@JoeTayactac Thanks you sir
If you edit add and released quantity ots not giving right result
Please check pin comment for updated formula
Hello sir I have a question, it is possible to add a price in item?
Obcourse you can do. You can checkout my latest inventory video
@@JoeTayactacoh God, thank you
@@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
Hello Sir,, ok naman sya.. pero pag nakailang transaction ka na sa isang item nagiiba na ng computation.. paano kaya ang gagawin ko sir
Use webhook instead of action.please check version 2 sa description
Напишу коммент
can you explain further how the formula works in execute an action on a set of rows in behavior. thanks
Usually use if you wanted to update or trigger an action against another table.
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.
propar not work
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.
is AppSheet is free???
Hi,
Free as long as you kept the app as prototype and max user is 10
Could you make a time and action plan app..
Hi Im not sure whst kind of app is that. Can you explaun further
hello how can I add new item? thank you
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.
Problem with while releseing stocks
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
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
Check this version Part 1
czcams.com/video/IKqm5OzyLZQ/video.html
Part 2
czcams.com/video/c7pFBnMIX8Y/video.html