Appsheet POS System and Print Receipt Full Tutorial Copy this template? Lets discuss! Need Support with Your Project? Mail To: cristiana.jill@gmail.com #appsheet
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
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?
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
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
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....
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
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,
Greetings, my friend! Please tell me how to make my auto parts store in AppSheet. There should be four tabs in the reflection (Spare parts catalog, sales, editing, Clients). I want to link all these tabs together, for example, when you enter data in the "Sale" tab which spare part you are selling, so that the number available is automatically reduced from the "Spart Parts Catalog" tab. That is, to automate the application as much as possible. Tell me how to do it, maybe you've already done it, or there's a video.
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
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?
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
@@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
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
please make a complete video about the inventory. Include sell, purchase, stock, profit, loss
For anyone having trouble with Select() Function, note that after the equals signal [_thisrow] and [Invoice_No] are separated by a ''.'' not a comma.
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
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
Thanks sir 🙏
I learn from Myanmar. It teach me a lot.
Can you do a complete video of a resturant or cafe touch screen POS
Thank you from algeria 🇩🇿
That would be awesome to include VAT to this POS :)
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?
Sir, thanks for your teaching!
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
Hi,
Payments form is auto generated by Appsheet
@@JoeTayactac thanks for your answer. I don’t know how but it didn’t do it automatically for me. But I’ve recreated it
@@JoeTayactac 1:14:50 the related sales , same thing... I don't see when you explain it, it appears like that ??
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
Why there's no popping up for "Order Qty" even if I followed your action 1? 29:25
Porque dice usted en el minuto 0:43 que la app es single user? Que condiciona que la app sea de ese tipo?
Thank you so much I learned more this from this
thanks alot @Joe Tayactac, but i want to set qty to zero become set qty to blank. its possible? how.
29:51 input() is in beta showing?
hi if i want to make a multi price item how life a box and smaller box
Hi, sorry i did not get what you mean
@@JoeTayactac what i meant if there is a way to make 2 values to one item a big one and a small one
just add a smaller size in the menu with the desired price
can appsheet directly send the print command to the default printer connected, on save or click of a print button?
Hi! How did you achieve to have the referenced table into the form?
I followed all the same you sir but the Cart Slicer did not save the items in the Cart Section???
just found that google docs moved out page sizer addon, is there any other alternetives?
Hi! great tutorial, any chance we can get this app as template?
Thank you from Kochi, India. Can you help me to create a Cloud based POS?
How can purchases from suppliers be included in the menu? To later calculate the current stock based on sales?
have u find the solution ??? or any link video that i can watch ?? im struggling too
Not yet, but found a fórmula to cout movements
can u share the formula to me ?
switch(true(),
[transType] = "buy" ,[qty],
or( [transType] = "sell" ,[qty],) ,[qty]*-1 ,0)@@argyafathurendra1863
Hi, thanks your videos please how i can process a payment with this app if its posible
If the selected item is already in the cart and we intend to change the quantity, is that possible, sir?
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
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....
im struggling when im using a real data table already have stock qty ... can someone help,by sugest what should i do ?
can help me, related Sales not connect in payments
It's seem like my automation is not work. Is it available for plan free?
How do i download the above appsheet?
How can we get the PDF to print automatically?
Great Lesson
How Can I install Page Sizer Extension please give me its link
This Awesome.. i got it... the only thing it didn'ts show is the ICON FOR PAYment
10:12 How do I change the default value to 1?
I also have the same question. Can you show me?
How can I add upload images for a single product in a (slice filtered) deck view option?
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
in views, go to cart, then behavior, then event actions select "delete"
The INPUT() feature is in BETA.
Very helpful!! 👌👌👌
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,
how to make it open billed
58:56 - creating receipt
where?
Greetings, my friend! Please tell me how to make my auto parts store in AppSheet. There should be four tabs in the reflection (Spare parts catalog, sales, editing, Clients). I want to link all these tabs together, for example, when you enter data in the "Sale" tab which spare part you are selling, so that the number available is automatically reduced from the "Spart Parts Catalog" tab. That is, to automate the application as much as possible. Tell me how to do it, maybe you've already done it, or there's a video.
ty, im done my POS cus this
Congrats
Hey. Can you please share the app with me and allow me to clone it ?
dude thanks a lot. terima kasih banyak
Good job sir. Can we send the invoice pdf to whatsapp directly
Add customer to POS?
Hey, can i get template receipt from u sir?
is it possible to choose the items by scaning the barcode ?
I would like to know too. Did you get any response?
@@claytonjsm yeah just turn on the scannable options on the barcode column
Thank you so much sir.
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
i notice that with 0 (zero) QTY also can accept. can it condition it minimun qty must 1?
Yes You can set minumum value inside the column option
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?
No even your free should display
@@JoeTayactac thank you brother let me cross check again
@@JoeTayactac thank you it worked
@@benzin0007 hello . Can you please share the app with me and allow me to clone it ?
@@benzin0007 how did you do it? after saving the payment, the pdf link won't open :< help
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
Hi
You need to create on form save data change action and set your pdf Automation on Update only
REF column in video i,m not look
patulong lodz, paano pag isahin nyu same item name sa cart, at mag add nalang ung qty nya?
Amazing thanks a lot
why the action for update status to Paid not working
Me to
How to solve this?
Can you help me why doing all the steps still my STATUS is not showing paid ? PLZ
Mayve error syntax in pdf file
@@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
How to solve this?
Why on my Appsheet interface there's no UX and Behavior section?
Hi, try to switch to old view
paano po for multiple users ? sent email po Sir!
Price???
Price for?
@@JoeTayactac sistem point sell
1:00:0
Very slow app. Customers will get tired of waiting and hate the store😅
Great job. But poor teaching. No control over the subject matter.
Don't use Appsheet for POS system lol.
google play: Appsheetprint
This app print no sync appsheet