How to make your own POS Point of Sale System for Free Using AppSheet
HTML-код
- Опубликовано: 27 июл 2024
- Create your own POS Point of Sale System easily and free using Google Sheets and Appsheet. It can be use in mobile or desktop
To use in mobile Android or iOS download the application at app store or Google Play
How to Drop Down Autofill Columns in AppSheet:
• How To Auto Fill Data ...
How To Create A Dynamic and Responsive Dashboard in AppSheet
• Appsheet Dashboard View
Create TAX Invoice Printable App
• How To Create a TAX In...
Create an Icon View Shortcut Using Behavior
• How To Create an Icon ...
How to Create an Automatic Serial Number in Appsheet
• How To Create an Autom...
#appsheet #pointofsale #googlesheets Наука
Fantastic Tutorials u helped me in create my first app for my supermarket
This is Amazing !
As you were modifying the Order Form so that the Change Field only displays after an amount has been entered into the Payment Field, I think the subtraction formula you entered for the Change Field was transposed. You entered Total minus (-) Payment. It should be Payment minus (-) Total = Change. With the data you used, your formula results is -$4 ($6 - $10). Correctly formulated the result is $4 ($10 - $6). At 25:04, your screenshot of the Order Form shows Change as -$4. That said, this is very informative. [Feedback: since you have a slow internet connection, you'd improve your content if you edited out all of the delays. This 37+ minute vid would probably reduce to 25 minutes.]
Nice tutorials idol
This the amazing tutorial never see in RUclips. But I have few questions:
- How to create and connect income and Expenses tables into Appsheet
- Can u make for us a tutorial teaching how to create Pay Rall system
what about split transaction sir? half by cahs half by credut card?
Very nice tutorial....is there anyway to display table view in kitchen display and auto refresh every 30 seconds?
Thank you for a very informative video. How will I go about if I would like to open tabs/tables and add multiple sales to that tab?
I made a video for multiple items . You can check the recent Video.
Can you show how to select multiple items for the same receipt and show full order total on Order Form? Thank you for this great tutorial!
See part 2
Can it print the receipt and also sticker?
Good day! Can you make tutorial on how to make RESPONSIVE PRODUCT CARDS on webpage using Google Sheets & Apps Script?
How do I add an image directly from my spreadsheet?
Very Informative. Can You Help me? How do you make Multiple Orders with 1 OR?
You mean similar on this?
ruclips.net/video/wkpjIc932Y4/видео.html
Amazing tutorial just followed step by step and twitch some parts. but I have a question. Any(Select(Menu[Unit Price], [_Thisrow].[Item Name]=[Item Name])) hides the field. What could be the problem?
I also can't get passed that step.. even after starting over 3 times
I tried this LOOKUP([_THISROW].[Item Name], "Menu", "Item Name", "Unit Price") into Initial Value instead of App Formula and it worked for me. I used ChatGpt to help debug it for me.
Not working for me.. some items keep hiding by themselves and price doesnt populate... I fix an error and get another .. but that error was not selected before... I've started from scratch 3 times... same issues.
How secure is this?
Link?
Sir, I followed all the steps but I cannot make an order twice with the same date example 06/28/2022? It says There is already a row with the key '06/28/2022'
Check the table . Maybe you placed date as key column.
@@JoeTayactac same problem.. i cannot make an order twice with the same date.. can you help me how to fix it.. thanks
Do not use Date Column as Row key. Use something unique or Receipt Number if you have
sir can help me on this .... if([size1]="small",[Qty1],"0")+if([size2]="small",[Qty2],"0")
Ifs([size1]="small",[Qty1],[size2]="small",[Qty2])
thanks for the reply.. what i want to.achieve is to add the two values
What if insufficient payment input? what is the formula?
You can place a valid if formula in Amount Paid column.
If
([Payment Method]"Cash",
[Amount Paid]=[Total Amount],
[Amount Paid]>=[Total Amount])
The app doesn’t work if you order two different products same day. Say already a transaction on this day and will not save sale
Update I figured it out. The key needs to be changed to the receipt number instead of date. Otherwise you won’t be able to do but one order a day
Thank you great teaching. I knew nothing and I was able to figure it out from what I learned from your video
Check your key column
I'm trying to save the second order, but it gives me an error that "There's already a row with the the key". How to add multiple rows?
Hi,
The error is due to key column. Make sure key column is unique
Hello Sir, I'm Order more, I Can't Save.
Check your key coloumn
Is appsheet free?
It has paid plans.
It's free as long you keep it in prototype mode. And as wel ifl you don't need to generate pdf
@@JoeTayactac Can i use it full in prototype mode ?
Can i print it ?
Thanks.
You can use and print. You need to use Google sheet for printing using link. And keep it in proto type as long as you want