How To Create Your Own Multiple Item POS System With Inventory Management Using AppSheet

[@JoeTayactac]

Hey Guy's heres a correction for formula. there is a bug when adding repeating items Time Stamp 1:01:58 Action Set values of some columns of this row For Sale Stocks Available Stocks= Any(Select(Sale[New Available Stocks Item 1],[Receipt No.]=Maxrow("Sale","_RowNumber"))) Available Stocks= Any(Select(Sale[New Available Stocks Item 2],[Receipt No.]=Maxrow("Sale","_RowNumber"))) Available Stocks= Any(Select(Sale[New Available Stocks Item 3],[Receipt No.]=Maxrow("Sale","_RowNumber"))) Time Stamp 1:43:53 Action Set Values some columns of this row For Adding Stocks Available Stocks= Any(Select[New Available Stocks Item 1 AS],[Reference ID]=Maxrow("Add Stocks","_RowNumber"))) Available Stocks= Any(Select[New Available Stocks Item 2 AS],[Reference ID]=Maxrow("Add Stocks","_RowNumber"))) Available Stocks= Any(Select[New Available Stocks Item 3 AS],[Reference ID]=Maxrow("Add Stocks","_RowNumber")))

[@arvinfrondarina6518]

Hello, can we add more criteria in the condition? instead of selecting the Max row?

[@rohjisun2850]

It still doesn't work for me, it made it worse

[@medicareneweraclinics]

Mr. Tayactac, I followed your tutorial up to 1:05:13. Easy to follow and understand. When I got to creating New Action for the Sale Table, on my appsheet I do not have the option for Referenced Table! How do I move ahead?

[@JoeTayactac]

On your sale table execute an action to a set of rows . Sale table should be up. Then below is the inventory. The reference action is from the action you created from Inventory table (set value column in set of rows)

[@medicareneweraclinics]

@@JoeTayactac Thanks, seems resolved. Expressions didn't show any Error. I used the Formula REF_ROWS("Sale", "Item Code 1") in the Inventory Table. Seems to work so far, unless something strange happens. By the way, your explanations are clear and straight-forward.

[@sudhakumaran3042]

Hello Joe, your videos are very useful for me to create my own app. You are explaining in very easy and effective way to make us understand. I am trying to update my app for latest version. I am struggling to get a last row value of a reference table to get updated with previous value if there is no value entered, can you guide me to overcome this issue.

[@walternhabanga]

1:07:01 I couldn't fix this error, on the creation of sale Item 1 to 3

[@munkhkhishigulziibayar6530]

Hello, it is really helpful and thank you for your time and dedication. I have a question about if you can add barcode scanner option on this POS inventory app.

[@oguzhankitan9193]

39:11 Hello I want to change the Payment Method. For example; The customer has a $100 bill. You will pay half on Card and half in cash. Could you help?

[@JoeTayactac]

Hi, You can add an extra column for split payment. Then create 1 column for total amount

[@ankurmathur82]

Hi Joe, Very hepful guidance on creating Inventory connected POS app. Quick question, What is the format of image URLs for the item images to show up ?

[@JoeTayactac]

If the image is coming from Google Drive you can watch this I explained in this video kzbin.info/www/bejne/fZvXiJqLhdmoZsk

[@WaleedRasheed-b4e]

Hello mate ! I created app but facing not changes in inventory can you assist me to reset this please

[@airman-xx9vg]

is there a way you can make it a multiuser? where the cashier can remotely log in using Gmail account and use that email as their ID instead of "Cashier 1" and "Cashier 2". thank.

[@manjulsama8023]

hello sir, this question out off video but , when i delete sale transaction the stocks still have value transacin stock, what will must i do

[@leahbernadettebarawed2856]

My inventory stocks aren't changing. I hope you can assist me. :)

[@clintongyasi5552]

the inventory figures in appsheet are not the same as what i have googlesheet when i add the bot feature anyway you can assist me

[@JoeTayactac]

This is just an idea you can apply same with adjustment as per your google sheet or data base. Email me

[@pn-nu7pd]

Hello, I came across a more simple solution. Make a parent-child function; parent being the order, child being the product/s. Hope this makes sense, I'm pretty new at this.

[@JoeTayactac]

Hi you mean same as this? kzbin.info/www/bejne/mpq1en9raLKempY

[@somsakbureethong2412]

Hi Joe, When I try to add a new sale row(sale service) from Appsheet, it's keep showing this error "There already row within the key: '06/23/2023'. would you be able to help assist me on this error?

[@JoeTayactac]

Check your table key column should not be date

[@SongjogDesign]

Where is the 2nd part of this project?

[@WaleedRasheed-b4e]

Hello mate ! I created app but facing not changes in inventory can you assist me to reset this please