AppSheet POS System and Print Receipt Full Tutorial

[@robertsonrivera9775]

1:13 create sheet containing the items 10:25 create sales table 12:45 setup the sales table 18:13 setup invoice number in the invoice sheet 20:24 setup invoice number in the sales sheet 21:54 create slice view 27:00 link sheets within app; create add to cart 35:50 create payments table

[@jonisarowar8424]

please make a complete video about the inventory. Include sell, purchase, stock, profit, loss

[@valofee]

23:00 Status Sales _isblank status 1:07:06 Triger to add Status Value 1:06:15 Clear Cart History 1:21:39 Preview the PDF

[@c4rvalho582]

For anyone having trouble with Select() Function, note that after the equals signal [_thisrow] and [Invoice_No] are separated by a ''.'' not a comma.

[@marcofrencia7760]

I have been working on the app for a long time and it is impossible for me to calculate the stocks in the Items table

[@zawminsett]

Thanks sir 🙏 I learn from Myanmar. It teach me a lot.

[@skiopsroblox2]

Can you do a complete video of a resturant or cafe touch screen POS

[@fainst]

Hi ! thanks for this tutorial, but at 47:59 I don't have the payments form... I think you never showed when you created it in the video ? Please help :) thanks

[@JoeTayactac]

Hi, Payments form is auto generated by Appsheet

[@fainst]

@@JoeTayactac thanks for your answer. I don’t know how but it didn’t do it automatically for me. But I’ve recreated it

[@fainst]

@@JoeTayactac 1:14:50 the related sales , same thing... I don't see when you explain it, it appears like that ??

[@marcofrencia7760]

Professor, good afternoon from Argentina, I would like to ask you, how could we add the stocks to the items? Could we save the input units in another table, and then in virtual columns in the "items table" (since the stock is a data inherent to each product) formulate the sums of the difference between the units bought and the units sold? Could you tell us if there is any other way to do it in this app that you propose in this video?

[@marcofrencia7760]

Porque dice usted en el minuto 0:43 que la app es single user? Que condiciona que la app sea de ese tipo?

[@pauramirez5860]

Why there's no popping up for "Order Qty" even if I followed your action 1? 29:25

[@fainst]

That would be awesome to include VAT to this POS :)

[@gstore.fruits]

thanks alot @Joe Tayactac, but i want to set qty to zero become set qty to blank. its possible? how.

[@marcofrencia7760]

How can purchases from suppliers be included in the menu? To later calculate the current stock based on sales?

[@argyafathurendra1863]

have u find the solution ??? or any link video that i can watch ?? im struggling too

[@marcofrencia7760]

Not yet, but found a fórmula to cout movements

[@argyafathurendra1863]

can u share the formula to me ?

[@marcofrencia7760]

switch(true(), [transType] = "buy" ,[qty], or( [transType] = "sell" ,[qty],) ,[qty]*-1 ,0)@@argyafathurendra1863

[@justfateh9747]

Thank you from algeria 🇩🇿

[@Danc2live]

hi if i want to make a multi price item how life a box and smaller box

[@JoeTayactac]

Hi, sorry i did not get what you mean

[@Danc2live]

@@JoeTayactac what i meant if there is a way to make 2 values to one item a big one and a small one

[@peridot2263]

just add a smaller size in the menu with the desired price

[@casperdelport3427]

10:12 How do I change the default value to 1?

[@lephuocloi]

I also have the same question. Can you show me?

[@gorebantchiu6469]

Sir, thanks for your teaching!

[@RobertoOchoa-t6u]

Hi! How did you achieve to have the referenced table into the form?

[@vijayarajan1750]

Thank you from Kochi, India. Can you help me to create a Cloud based POS?

[@franklinsvideos]

can appsheet directly send the print command to the default printer connected, on save or click of a print button?

[@atrevisi]

Hi, thanks your videos please how i can process a payment with this app if its posible

[@hasansiam2838]

29:51 input() is in beta showing?

[@chanakahasantha6957]

Thank you so much I learned more this from this

[@GusVegaFantasma]

Hi! great tutorial, any chance we can get this app as template?

[@ALL_About_Data_PowerBI]

just found that google docs moved out page sizer addon, is there any other alternetives?

[@argyafathurendra1863]

im struggling when im using a real data table already have stock qty ... can someone help,by sugest what should i do ?

[@jigarsagar4450]

How can I add upload images for a single product in a (slice filtered) deck view option?

[@goodcoder4953]

Great Lesson How Can I install Page Sizer Extension please give me its link

[@YanuAriyantoSKom]

Sir, in the scenario, namely a restaurant, a customer A comes and orders and says open card, then the customer sits down (card is still open) Then customer B comes, orders and sits down, the card is also open Then customer A adds to the card that was still open, then the customer will go home and pay and customer A's card is closed Likewise customer B, returns to the cashier and closes the card Then it is concluded whether customer A can save the item card but it is still open, then the application inputs customer B's item card to be saved So get a card with the open method if you are still going to add and close if you are going to pay....

[@newhuman9805]

can help me, related Sales not connect in payments

[@สุเทพแซ่อึ้ง-ธ8ษ]

It's seem like my automation is not work. Is it available for plan free?

[@franklinsvideos]

58:56 - creating receipt

[@zawminsett]

I appreciate it I suggest one action that really need. After we add to cart and then go payment form. Between adding the cart and payment form, I really need cancel button. After added to cart, I can't delete or undo without going payment form. How to create it. Provide with video sir

[@fainst]

in views, go to cart, then behavior, then event actions select "delete"

[@EVARRAPI]

This Awesome.. i got it... the only thing it didn'ts show is the ICON FOR PAYment

[@zakirkhayali-xm3gr]

I followed all the same you sir but the Cart Slicer did not save the items in the Cart Section???

[@娜位媽咪]

My problem was that when I try to add more quantities with apples and then it didn’t automatically add up for apple, it showed one more list of apple order, is there any way to solve this issue, thank you,

[@jesusbrea8807]

How to change the length of the PDF based on length of the invoice? To save paper when printing. The length of the pdf will be the same for a short or long invoice

[@SCYGLOBALTRADE]

i notice that with 0 (zero) QTY also can accept. can it condition it minimun qty must 1?

[@JoeTayactac]

Yes You can set minumum value inside the column option

[@KURAMABUKHGALTERIYA]

Hello Joe Tayactac, I'm experiencing an issue with creating PDF files when a new order is added to my "Order" table. I have set up an automated process where a PDF file is generated, which includes data from the "Order Details" table. However, I'm encountering an issue where the PDF is created before the synchronization of the newly added data in the "Order Details" table is completed. As a result, the generated PDF file does not include the most recent data from "Order Details". I understand that operations in AppSheet, including data updates and workflow actions, are asynchronous and do not necessarily complete in a specific order. But is there a way I can ensure the synchronization completes before the PDF is generated? I'm considering a delay function for the PDF generation action, but I'm unsure whether this is the best approach, as it might introduce unnecessary delays for the users. I'd appreciate any ideas or solutions that can help me address this challenge. Thanks

[@JoeTayactac]

Hi You need to create on form save data change action and set your pdf Automation on Update only

[@vanthangpham793]

The INPUT() feature is in BETA.

[@alialredaissa809]

is it possible to choose the items by scaning the barcode ?

[@claytonjsm]

I would like to know too. Did you get any response?

[@alialredaissa809]

@@claytonjsm yeah just turn on the scannable options on the barcode column

[@czechoslovakianwolfdog]

How can we get the PDF to print automatically?

[@krislukm]

dude thanks a lot. terima kasih banyak

[@YanuAriyantoSKom]

If the selected item is already in the cart and we intend to change the quantity, is that possible, sir?

[@TranTheMy-t7f]

Add customer to POS?

[@benzin0007]

bother it worked well thanks a lot but I failed in 1 thing - the PDF generated link is not displaying after submitting the payment form. the pdf generated and saved in the g drive. Is this because i am using free version?

[@JoeTayactac]

No even your free should display

[@benzin0007]

@@JoeTayactac thank you brother let me cross check again

[@benzin0007]

@@JoeTayactac thank you it worked

[@najarofficial96]

@@benzin0007 hello . Can you please share the app with me and allow me to clone it ?

[@lawrencedaan3214]

@@benzin0007 how did you do it? after saving the payment, the pdf link won't open :< help

[@aishaaaa6735]

The status did not update to paid after confirm payment…i follow all the steps and rewatch many times but still do not automatically update to paid… if you can give advice i would appreciate it very much

[@workspaceEziwashlaundry]

How do i download the above appsheet?

[@adityanaufalghifari9112]

Hey, can i get template receipt from u sir?

[@thanvaatnc.3939]

ty, im done my POS cus this

[@JoeTayactac]

Congrats

[@najarofficial96]

Hey. Can you please share the app with me and allow me to clone it ?

[@learningstudent5283]

Can you help me why doing all the steps still my STATUS is not showing paid ? PLZ

[@sunnychickymilk]

Mayve error syntax in pdf file

[@c4rvalho582]

@@sunnychickymilk Same error happened here, end the solution was exactly that, what happens is that the first action the bot does is to generate the pdf, and if the pdf is with a wrong syntax it does not generate, and the following actions also don't happen

[@QUDRA]

How to solve this?

[@prosrath8980]

Why on my Appsheet interface there's no UX and Behavior section?

[@JoeTayactac]

Hi, try to switch to old view

[@rizanmohamed1094]

Good job sir. Can we send the invoice pdf to whatsapp directly

[@RubickDota-tk8oo]

how to make it open billed

[@junwathanaklit854]

REF column in video i,m not look

[@pemudaharapanbangsyam-uv6lv]

why the action for update status to Paid not working

[@QUDRA]

Me to

[@QUDRA]

How to solve this?

[@junwathanaklit854]

where?

[@TramitesNanos]

Very helpful!! 👌👌👌

[@MrPrincePatrick]

patulong lodz, paano pag isahin nyu same item name sa cart, at mag add nalang ung qty nya?

[@kirayagami9229]

Thank you so much sir.

[@UserAnonimo-c2l]

Price???

[@JoeTayactac]

Price for?

[@UserAnonimo-c2l]

​@@JoeTayactac sistem point sell

[@gracetocao7821]

paano po for multiple users ? sent email po Sir!

[@TREVISOFT1]

Amazing thanks a lot

[@Danc2live]

1:00:0

[@mouhmed767]

Very slow app. Customers will get tired of waiting and hate the store😅

[@NaftuliSinger]

Don't use Appsheet for POS system lol.

[@ResulfLee]

google play: Appsheetprint This app print no sync appsheet