VERSION 2 OF INVENTORY MANAGEMENT Part 1: ua-cam.com/video/IKqm5OzyLZQ/v-deo.html VERSION 2 OF INVENTORY MANAGEMENT Part 2: ua-cam.com/video/c7pFBnMIX8Y/v-deo.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")))
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 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.
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.
Thanks. It worked well, but at the end, when i double click the number under available stocks in stocks inventory, value gets changing. Is there any step to avoid this problem??
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, which are the video u can recommend to me. I would like to have the AppSheet with, total quantity at all the location, multiple location, multiple rack, able to add and release at the same time
@@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 ?
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
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
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, 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 ...
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
@@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
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?
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 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.
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.
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
VERSION 2 OF INVENTORY MANAGEMENT Part 1: ua-cam.com/video/IKqm5OzyLZQ/v-deo.html
VERSION 2 OF INVENTORY MANAGEMENT Part 2: ua-cam.com/video/c7pFBnMIX8Y/v-deo.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 .🤔
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.
you are the best maaan you dont know how much you have contributed to the world economy. keepup with the good work🙂👍
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 ua-cam.com/video/IKqm5OzyLZQ/v-deo.html easy to follow
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
Hi. If you extend it from the bottom right corner after selecting 1000 and 1001, it will continue as 1003.
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
@Joe Tayactac at 3:20, How did you delete whole empty column???? May I know??
Thanks. It worked well, but at the end, when i double click the number under available stocks in stocks inventory, value gets changing. Is there any step to avoid this problem??
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.
two years later and still saving mankind
This was very helpful. Thank you so much for this knowledge
Hi, which are the video u can recommend to me. I would like to have the AppSheet with, total quantity at all the location, multiple location, multiple rack, able to add and release at the same time
Excellent job. Istill waiting for part 3of IOS restaurant
thank you for very informative system that you made. if gives me an idea to use it.
You can use DEREFERENCE instead of SELECT to make things simple
Hi! Thanks for this video. Is there a wey to calculate the inventory value? First in first out?
Thank you! Awesome video!
Great training, very clear explanation. :)
Excellent Joe
Thank you very much
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
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
Can i add new Products on this table?
Yes
Awesome. Liked it. How to add a new item into the stock inventory? Should we add it in the google sheet directly?
Yeap
In behaviour for event action mine is saying Row Selected instead of Form Saved. Thanks to help me about this.
Awesome, thanks for the great explanation
Your welcome
Nice one Pls I have a question
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 ua-cam.com/video/IKqm5OzyLZQ/v-deo.html
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?
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.
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
Thanks dude
Thank you so sooo much ...
Is it possible to combine both the inventory system and a POS system ?
Sure its possible
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
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
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
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 .
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 job. Can you give the project web address?
Can I review your project?
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?
ua-cam.com/video/5GUXBcQEnMY/v-deo.html
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.
If you edit add and released quantity ots not giving right result
Please check pin comment for updated formula
❤❤❤❤❤❤❤
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.
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 this be converted into a Mobile app using Appsheet? How to do so, if possible?
Could you make a time and action plan app..
Hi Im not sure whst kind of app is that. Can you explaun further
propar not work
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.
hello how can I add new item? thank you
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.
is AppSheet is free???
Hi,
Free as long as you kept the app as prototype and max user is 10
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
Напишу коммент
Problem with while releseing stocks
Billing
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
ua-cam.com/video/IKqm5OzyLZQ/v-deo.html
Part 2
ua-cam.com/video/c7pFBnMIX8Y/v-deo.html