How to make your own POS Point of Sale System for Free Using AppSheet

  Рет қаралды 26,437

Joe Tayactac

Joe Tayactac

2 жыл бұрын

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

Пікірлер: 40
@johngeary220
@johngeary220 Жыл бұрын
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.]
@afriyievictor
@afriyievictor Жыл бұрын
Fantastic Tutorials u helped me in create my first app for my supermarket
@waelzad4655
@waelzad4655 Жыл бұрын
This is Amazing !
@bmpro292
@bmpro292 2 жыл бұрын
This the amazing tutorial never see in KZfaq. 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
@samlodorfishing
@samlodorfishing 2 жыл бұрын
Nice tutorials idol
@ccC-jl3ib
@ccC-jl3ib 2 жыл бұрын
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!
@JoeTayactac
@JoeTayactac 2 жыл бұрын
See part 2
@itoph
@itoph Жыл бұрын
Very nice tutorial....is there anyway to display table view in kitchen display and auto refresh every 30 seconds?
@casperdelport3427
@casperdelport3427 2 жыл бұрын
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?
@JoeTayactac
@JoeTayactac 2 жыл бұрын
I made a video for multiple items . You can check the recent Video.
@ricjrsuazo3206
@ricjrsuazo3206 2 жыл бұрын
Good day! Can you make tutorial on how to make RESPONSIVE PRODUCT CARDS on webpage using Google Sheets & Apps Script?
@yusufisroil
@yusufisroil Жыл бұрын
what about split transaction sir? half by cahs half by credut card?
@makimakilatip6399
@makimakilatip6399 2 жыл бұрын
Very Informative. Can You Help me? How do you make Multiple Orders with 1 OR?
@JoeTayactac
@JoeTayactac Жыл бұрын
You mean similar on this? kzfaq.info/get/bejne/rdGgnayUnpmWiWg.html
@edgardvindel
@edgardvindel Жыл бұрын
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?
@Ninjatravels28
@Ninjatravels28 10 ай бұрын
I also can't get passed that step.. even after starting over 3 times
@TheReturn26
@TheReturn26 7 ай бұрын
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.
@terrytjandra
@terrytjandra 5 күн бұрын
Can it print the receipt and also sticker?
@jamesmills9837
@jamesmills9837 Жыл бұрын
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
@JoeTayactac
@JoeTayactac Жыл бұрын
Check your key column
@Ninjatravels28
@Ninjatravels28 10 ай бұрын
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.
@julsmikesusana3944
@julsmikesusana3944 2 жыл бұрын
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'
@JoeTayactac
@JoeTayactac 2 жыл бұрын
Check the table . Maybe you placed date as key column.
@jaychristcayetano
@jaychristcayetano 2 жыл бұрын
@@JoeTayactac same problem.. i cannot make an order twice with the same date.. can you help me how to fix it.. thanks
@JoeTayactac
@JoeTayactac 2 жыл бұрын
Do not use Date Column as Row key. Use something unique or Receipt Number if you have
@walternhabanga
@walternhabanga 7 ай бұрын
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?
@JoeTayactac
@JoeTayactac 7 ай бұрын
Hi, The error is due to key column. Make sure key column is unique
@gracetocao7821
@gracetocao7821 4 ай бұрын
How secure is this?
@emqbaba3890
@emqbaba3890 Жыл бұрын
sir can help me on this .... if([size1]="small",[Qty1],"0")+if([size2]="small",[Qty2],"0")
@JoeTayactac
@JoeTayactac Жыл бұрын
Ifs([size1]="small",[Qty1],[size2]="small",[Qty2])
@emqbaba3890
@emqbaba3890 Жыл бұрын
thanks for the reply.. what i want to.achieve is to add the two values
@akay435
@akay435 11 ай бұрын
Link?
@gipre2892
@gipre2892 Жыл бұрын
What if insufficient payment input? what is the formula?
@JoeTayactac
@JoeTayactac Жыл бұрын
You can place a valid if formula in Amount Paid column. If ([Payment Method]"Cash", [Amount Paid]=[Total Amount], [Amount Paid]>=[Total Amount])
@broit7468
@broit7468 Жыл бұрын
Hello Sir, I'm Order more, I Can't Save.
@JoeTayactac
@JoeTayactac Жыл бұрын
Check your key coloumn
@georgematsos4416
@georgematsos4416 2 жыл бұрын
Is appsheet free? It has paid plans.
@JoeTayactac
@JoeTayactac 2 жыл бұрын
It's free as long you keep it in prototype mode. And as wel ifl you don't need to generate pdf
@georgematsos4416
@georgematsos4416 2 жыл бұрын
@@JoeTayactac Can i use it full in prototype mode ? Can i print it ? Thanks.
@JoeTayactac
@JoeTayactac 2 жыл бұрын
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
AppSheet Inventory Point Of Sale Management for Any Business Part 1
1:27:16
AppSheet POS System and Print Receipt Full Tutorial
1:33:10
Joe Tayactac
Рет қаралды 43 М.
Super gymnastics 😍🫣
00:15
Lexa_Merin
Рет қаралды 108 МЛН
Жайдарман | Туған күн 2024 | Алматы
2:22:55
Jaidarman OFFICIAL / JCI
Рет қаралды 1,3 МЛН
Khó thế mà cũng làm được || How did the police do that? #shorts
01:00
Turn Your Spreadsheet into an App
6:58
Prolific Oaktree
Рет қаралды 60 М.
6 Best Free POS Systems for Small Business
13:20
Brennan Valeski
Рет қаралды 48 М.
Setup/Install Your Restaurant POS System
10:09
SmartOrder
Рет қаралды 221 М.
Create a Button that works in mobile in Google Sheets
13:38
Practical Sheets
Рет қаралды 29 М.
Урна с айфонами!
0:30
По ту сторону Гугла
Рет қаралды 7 МЛН
Cadiz smart lock official account unlocks the aesthetics of returning home
0:30
Samsung S24 Ultra professional shooting kit #shorts
0:12
Photographer Army
Рет қаралды 34 МЛН