Create a Point of Sale (POS) Web App using Google Sheets and Apps Script

[@makingsaas]

Hi everyone, I have posted a video showing how to get the code from Github and run it. This is in case you had issues with the tutorial and wanted to see how the code works or identify any bugs. Here is a link to the demonstration: kzbin.info/www/bejne/eZu5q3mbgLOqZ9U

[@thai-power-comments]

thank you very much from Thailand

[@robloxspace944]

thank you very much do you have any idea on how can i set and send to thermal printer?

[@netboy1102]

@@robloxspace944 use app script to create file (pdf or txt) in Google drive then use Rclone to sync the file to your local machine then use foldermill to print it out.

[@netboy1102]

Can you please help me to add the incremental faction to the items that are added to the list. I prefer to see that they are sorted and not one item per line.

[@Anweshdash5]

please share the google sheet again it has been deleted

[@stevensonnwokenkwo3281]

Well, you never know when you'd run into a great video; this is one of such moments. Fabulously explained. Thanks for the effort.

[@murat.ondasyn]

The first time I saw what you wrote in js was new to me, I did not understand anything technically at all, but I rewrote your code and set up the application to work. Thanks to you and your video, I started learning js. and a year later, about a miracle, now I am reviewing the video of what is happening and everything is very clear to me. thanks for your hard work and motivation.

[@doncurrency]

can you help me with the display. cos my menu does not display and i have really tried

[@excelforyouofficeforme3847]

Same problem with me. @@doncurrency

[@Anweshdash5]

its because we dont have the google sheet@@excelforyouofficeforme3847

[@netboy1102]

after 2 years, I come back to thank you, I created a nice online order app from your tutorial. And now I become a good programmer because of you.❤ By review this video, I can still learn more stuff. Amazing..

[@Anweshdash5]

hello can you please help me get the google sheet its reading and writing from.

[@netboy1102]

@@Anweshdash5 I still have the copy, but you need to give me ur email

[@veetisaree]

It is working very good. Just Add input of mobile with order so that we can take online order.

[@jerryhsu7679]

Thank you. This is really a feasible and great POS architecture, if you add a Bluetooth printer that supports ePOS-Print SDK for JavaScript.

[@burbyleo]

This is amazing! Thank you for such a nice tutorial.

[@adminweb9772]

you are super! smooth voice, calm and briliant. thank for tutorial

[@makingsaas]

Thank you!

[@paretoanalysis7099]

Great content for Entrepreneurs! Thanks for sharing, and please keep going :)

[@haydiab]

3 hours, okay I'm waching. Thanks in advance

[@isaacnyachae9423]

Man you are heaven sent. Exactly what i needed. Thank you you you

[@dellddeveloper1919]

Hi, at 2:02:21 you showed that you were unable to display the item details in the receipt upon clicking any button in the menu. then you showed that the solution for it at 2:04:10 was to add the tbody id="receipt-details" in index.html. However, I have the exact same issue but I still could not make it work altho the tbody id is already there. I copied and pasted your entire code from Github and I noticed that that's actually not exactly as what you've shown here, so I tried to add-in those codes based on your ytube video here but I still didn't get my issue resolved. Could u be kind enough to correct me, please? Also I noticed in your code you use symbol ` instead of '. Does that affect the code, please? Please advise. Thank you.

[@makingsaas]

Hello, It's difficult for me to know exactly where you are running into problems from your description. Do you have your code in a Github repo you could share? As far as the symbol `. Please see this: developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Template_literals

[@dellddeveloper1919]

@@makingsaas Hi, thank u so very much for responding to me. I finally found the culprit of my earlier issue after testing on your full gsheet copy. Your initial code u posted in GH is not able to display the menu photos and price (definitely no clickable item) when no transaction history in Sales tab. Seems like it needs at least 1 trx first before your js is triggered. But that shouldn't be the case, right? Because there supposed to be no sales history before one could start clicking the menu. But I'm sure this is just a small bug for u to resolve but just letting u know as some people have same issues as I did.

[@makingsaas]

Thanks for catching that and letting anybody else know about it! I think I was aware of this at the time but I didn’t want the video to be too long so I skipped on some features. You are right it would be good to be able to start from zero invoices.

[@rayhanmollik2877]

Same problem i am facing, please give a soluations.

[@gemmapimentel799]

Awesome tutorial. Loved it.

[@usamanaeem8737]

Something I was really looking for

[@geewcwong]

Hi, thank you for this awesome tutorial! im learning through customizing your code to suit my need :D I may be asking for too much, but would like to know is it possible to show the date time underneath the invoice number and the date time will be the same as to the google sheet payment record? (possibly to adjust the time zone to GMT+8?) And which function I can use to email the invoice part to the customer if they ask for a copy (as an image maybe easier..) ? Many thanks in advance.

[@netboy1102]

you need some more code for doing this, there are some tutorial about sending email based on data in your spreadsheet and customized templates.

[@alessandromusic7242]

closeSale() { const date = new Date(); // add this code para GMT +8 date.setHours(date.getHours() + 8); const orderData = this.exportOrder(date); const paymentData = this.exportPayment(date); const exportData = { order : orderData, payment: paymentData } Ui.hidePaypad(this); this.clearPayment(); this.clearOrder(); Ui.invoiceNumber(this); google.script.run.setData(JSON.stringify(exportData)); }

[@alexandratrading6422]

this is brilliant it would be helpful if product values were entered by barcode or manual search

[@hungorgtest9244]

That's exactely the tutorial that i need Thank's for your work

[@DuyNguyen-lo2mm]

Thank you for the educational video. Is there a way to implement barcode scan on prepacked food? Thank you.

[@corbettdestination5256]

That's insan, love it. Hoping to learn new things down the line

[@zohairdilawar116]

Thank you for the detailed step by step explanation, Please advise how to connect to Payment Gateway

[@Maciboo10]

im loving this video! i am trying to adapt this ti a retail POS... and use a barcode scanner.. i am having trouble with the codes... do you think we could link up and i could possibly pay you to help me with a codde?

[@TiphaineBuccino]

Really nice of you to mad that tutorial ! Do you think it would be possible to connect a balance to the system in order to register products that are priced from a weight (€/Kg) ?

[@makingsaas]

Yes this would be possible but it would depend on the functionality of the scale. It would require some software or custom scripting on the computer connected to the scale. For instance, if the scale can write to a CSV file on the computer, then a script would be required to get that data from the CSV file. There is also a Node package for setting up custom hardware i/o connections: serialport.io/

[@matorwmasen]

Waiting for the next project 😃

[@junezchan]

Your tutorial is genius and a gift to those who want to learn programming. However I am for ever stuck at 1:37:22. Even though I tried my hardest to follow you to a tee, I could not get the menu to load up 😢.

[@excelforyouofficeforme3847]

Same problem with me.

[@nikkisauerbrey9597]

I got the menu to show pictures but the buttons aren't functioning

[@excelforyouofficeforme3847]

You share, let us help customize@@nikkisauerbrey9597

[@netboy1102]

Try to find the app script function that loads the menu data, is there any problem with targeting the right range and sheet name?

[@Hiteshhothhh]

Appreciate your work. Can you tell how to add search filters to search big menu?

[@halukakalin1368]

Thanks for sharing. I’ve a question. Why not adding qty but new row when selecting same item more than once?

[@netboy1102]

This is only a Scratch open source, just copy and throw the script to chatgpt, let gpt to modify the core so the qty will be incremental updated when click on the same item

[@halukakalin1368]

@@netboy1102 thanks….

[@AAlharbi1441]

I am trying to show images from const menuData or Google Sheet that do not appear in Live Web or Google Apps! ? What's the correct ? Thanks

[@mov907]

Wow pretty impressive 👏👍

[@sachithekanayake2168]

When i deleted the fixed data, nothing was loading in mine (1:45:03). Could you please help me with that

[@teeranon.t]

Love this keep sharing like this more :)

[@alaaabdelnabi6088]

thanks for this professional tutorial, i hope u can do more

[@Westsatsop]

Thank you for the tutorial. It would be improved if you would set you screen resolution lower so that those of us on portable devices could see what you're typing.

[@willykurniawan2575]

Thanks for your sharing, I was try and great. but now we get the problem for print out. Can you give the code. Thanks and appreciated

[@murat.ondasyn]

HELLO. Are there any restrictions for GOOGLE APPS SCRIPT as to how many times a script can be called by a website? THANK YOU

[@mikldoly]

У мене получилось! Дуже дякую за такий корисний додаток з поясненням!

[@murat.ondasyn]

Добрый человек. помоги мне, ты единственный русскоговорящий комментатор данного видео. за мной не заржавеет )))) плиз

[@mikldoly]

@@murat.ondasyn Я не супер спеціаліст, самоучка, але чим можу поможу)

[@murat.ondasyn]

@@mikldoly спасибо. Разобрался. Автору респект

[@vivekasharma3011]

Great ever video...Thanks a lot..please suggest code for print html and save as well . Please help

[@temyraverdana6421]

Thank you, it's an amazing work. Thanks

[@syamsifikri8894]

Thank You! How to open drawer and print recipe?

[@safasfahdadh9685]

ye how to print?

[@mohamedmostafa-ow3gv]

Hi I need to add something on this project , I need to print invoice after close deal . You can add this option . Thanks 🙏

[@binary_cloud]

thank you , could you please give us more details how to print ?

[@makingsaas]

One way to print would be to have a sheet that contains an empty template of your receipt format. This template could be populated when an order is created and exported as a PDF (using getBlob). This PDF could be emailed using an apps script, or downloaded to your computer. The actual printing of the downloaded PDF would depend on your hardware, but you could write a script in Python etc on your computer to print these when they are downloaded.

[@theseanmodd]

This is insane thank you so much!!!!!!

[@helloparty6416]

Hi dear pleas Help the food icons are not Showing after deploy and when i run the script it Give this error in function include(filename) { return HtmlService.createHtmlOutputFromFile(filename).getContent(); } error Showing -- Bad Value !! can you please Advice what is my mistake ? ND THANK YOU SOOOO MUCH YOU ARE VERY GOOOOD Can you please help me or shear your Google Spreadsheet to this Email : [e-mail] thank you soo much

[@emanu9855]

Hello! Thank you for the POS it has helped me a lot, but I still have a question about the timestamp. I have been trying to change it to my GMT -3 but changing the spreadsheet, script and pc time zone haven't worked. How do I change that?

[@alessandromusic7242]

closeSale() { const date = new Date(); // add this code para GMT -3 date.setHours(date.getHours() - 3); const orderData = this.exportOrder(date); const paymentData = this.exportPayment(date); const exportData = { order : orderData, payment: paymentData } Ui.hidePaypad(this); this.clearPayment(); this.clearOrder(); Ui.invoiceNumber(this); google.script.run.setData(JSON.stringify(exportData)); }

[@mcautherbruce3798]

Hello, Thank you for your effort of detail demonstration. I also try to use google sheet as small database. But since the database will be set data by multiple user, does google script app can deal with the synchronization problem properly?

[@makingsaas]

This app will only reload data on refresh, so if the data is changed the app won't receive the data until refresh. One way to deal with this is to have a separate sheet for each POS terminal so they don't interfere with each other. Items could be fed to all the separate sheets from a master sheet. If you require real time updates I would suggest using the Sheets API instead.

[@EcoDev-Solutions]

Está excelente el proyecto. Lamentablemente no tiene el tema de la toma del inventario, ni valida si la cantidad es superior a la disponible, ni aumenta la cantidad en caso de que ya esté cargado en la lista. Por lo demás, está excelente el proyecto.

[@juliol.7081]

Great video, thank you 👍

[@doncurrency]

can you help me display the menu on the right ? mine does not work

[@michaelsglas]

IS IT POSSIBLE TO ADD THE NAME OF THE CUSTOMER TO THE RECEIPT?

[@ofhpixel8545]

How do we print out the receipt?

[@ivanporcalla]

Nice! Does this work for multiple tabs?

[@josuetorbiso8078]

How about simple but effective POS with inventory management for computer retailers with features In and out item, purchase order, sales, return sales

[@KayoBureau]

thank you for the video, but there is no option to print. How do i print the other? is there a way around it?

[@netboy1102]

Webhook to local python server

[@mohammedkamal6382]

Great work. Keep going Can open an account for each table if we use it for a restaurant?

[@makingsaas]

Thanks for the question. To add the ability to give tables tabs, you could do the following: 1. Add the following columns to the Sales sheet: table_id and open_closed (t/f) 2. Create an overlay similar to the payout overlay with a graphical map of the tables in your restaurant. 3. Make any tables with open tabs clickable so you can bring up the tab and either add to it, save it or pay it. So your toolbar would need two more buttons: Open Tabs Overlay (Table Map) and Save Tab (To save an order as a tab) With this level of functionality it would probably be better to split the Sales sheet into two sheets: Sales Headers and Sales Lines. This would move it more towards a flexible database structure. Hope this helps.

[@mohammedkamal6382]

Thank you so much for your reply. I will try it and I will share the result with you

[@gemmapimentel799]

@@mohammedkamal6382 where you able to figure out? Hope you can share to us ;)

[@Nova-m8d]

Very cool project

[@bendunnett9401]

This Is a great starting point project, thanks. Has anyone been able to add a barcode scanning facility for prepacked items?

[@oxpey4473]

When you click on the same product its not add another to quantity.

[@GloballyKenyan]

Hello ... I like th app and its working well for me. How do I replace the Menu with a plain form of ITEM : PRICE on one line.... with an OTHER button to add next line ....

[@netboy1102]

Some css styling needed,

[@MohamedOsamaAmr]

any idea how can i make the item have like 2 sizes when choosing it?

[@snoopdog4168]

really you are good man thank you

[@makingsaas]

thank you!

[@helloparty6416]

Hi dear pleas Help the food icons are not Showing after deploy and when i run the script it Give this error in function include(filename) { return HtmlService.createHtmlOutputFromFile(filename).getContent(); } error Showing -- Bad Value !! can you please Advice what is my mistake ? ND THANK YOU SOOOO MUCH YOU ARE VERY GOOOOD Can you please help me or shear your Google Spreadsheet to this Email : [e-mail] thank you soo much

[@khalilmahrache9812]

hi I have a problem. the link you have in the github to copy the sheet is not working. and when I try to copy it from github I copied everything and I added some items with the links but the products are not showing in the web page does anyone have the same problem and has anyone fixed this problem. thank you for this tutorial

[@murat.ondasyn]

Hello my dear friend. thank you for a great job. help me. I copied everything and put it on google sheets. but at startup the web application does not work, as if javacscript.html is not connected. there is a question how and where to put json. maybe because of this nothing works for me (((((((

[@makingsaas]

Are you able to upload your code to GitHub and share the link here?

[@murat.ondasyn]

@@makingsaasI can upload it to Githab, but this is the same code that I took from you. I don't see the point, but I know that there is a mistake in the Java script, you said earlier that there is a specially made mistake. I'm not familiar with the java script, but I watched the video 5-6 times until I figured out where the errors was. now I will repeat all 3 hours and write for you. I hope then everything will be ok. Thanks for responding to my comments.

[@makingsaas]

@@murat.ondasyn Try to delete the 'Mock Data' section of the script-js.html file. I added this section later and it may affect the code.

[@drexeldelarosa16]

how do i change the currency and the picture of the item is not recognized

[@dellddeveloper1919]

Hi, I noticed that in code line 236 in your js file, u set a constant 1 for the quantity "orderInstance.addOrderLine(1, parseInt(button.getAttribute("data-sku")));" as a beginner, I'm still struggling on how to change that to be variable so that it could be incremental over multiple clicks on the same item. I've tried to adopt the code from stackoverflow for similar question but none working so far. Hopefully u won't mind to share ur code on this too.

[@netboy1102]

Facing the same problem, maybe we buy him a coffee to get some more hints

[@dellddeveloper1919]

@@netboy1102 i love the idea to see him in person.. but am just too far away from him. Am from Malaysia. 😁 The cost for me to fly all the way to USA is even more expensive than to pay some local expert programmer to just sort out for me... Which is neither I could afford. 😀 Which is why i want to learn to do it myself. 😀

[@netboy1102]

@@dellddeveloper1919 Yeah, the same here, I know a little basic JavaScript and Google sheets knowledge, by learning from his code my skills are improved a lot

[@jlamt3000]

To increase qty of previously entered menu item: insert prevLine... statements at top of script-java.html and make changes to functions shown below. Also fixed the bug where you require to enter an extra cent to close sale kzbin.info/www/bejne/fJC6kHyord14d68 facebook.com/goef.lamb/videos/610193230051721 // Export order and the payment to google sheet var prevLineQTY = 0; var prevLineSKU = 999999; //************************************************************************************** addOrderLine(quantity, sku) { let currentLine = {}; for (let i = 0; i < this._menu.length; i++) { if (sku === this._menu[i].sku) { currentLine.sku = this._menu[i].sku; currentLine.description = this._menu[i].description; currentLine.price = " "; if (sku === prevLineSKU) { currentLine.quantity = prevLineQTY + 1; this._order.pop(); } else currentLine.quantity = 1; currentLine.subtotal = Utilities.roundToTwo(currentLine.quantity * this._menu[i].price); currentLine.tax = Utilities.roundToTwo(this._menu[i].taxRate * currentLine.subtotal); } } prevLineQTY = currentLine.quantity; prevLineSKU = currentLine.sku; this._order.push(currentLine); Ui.receiptDetails(this); } deleteOrderLine(index) { this._order.splice(index, 1); prevLineQTY = 0; prevLineSKU = 0; Ui.receiptDetails(this); } clearOrder() { this._order = []; prevLineQTY = 0; prevLineSKU = 0; Ui.receiptDetails(this); } getSummary() { const summary = { subtotal: 0, tax: 0, grandtotal: 0 } this.order.forEach(orderLine => { summary.subtotal += orderLine.subtotal; summary.tax += orderLine.tax; }) summary.grandtotal = summary.subtotal + summary.tax; return summary; } paypad(input) { if (!isNaN(parseInt(input))) { Utilities.numberPaypad(parseInt(input), this); } else if (input === "back") { Utilities.backPaypad(this); } else if (input === "clear") { Utilities.clearPaypad(this); } else { this.closeSale(); } } changePayment(input) { const orderGrandTotal = this.getSummary().grandtotal; if (input.invoiceNumber != null) this.payment.invoiceNumber = inputInvoiceNumber; if (input.amountPaid != null) this.payment.amountPaid = parseFloat(input.amountPaid); if (input.type != null) this.payment.type = input.type; if (this.payment.amountPaid >= orderGrandTotal) { this.payment.changeTip = this.payment.amountPaid - orderGrandTotal; Ui.closeButton(false); } else { this.payment.changeTip = 0; Ui.closeButton(true); } Ui.paymentSummary(this); }

[@alessandromusic7242]

addOrderLine(quantity, data) { let currentLine = {}; let lineData = JSON.parse(data) currentLine.sku = lineData.sku; currentLine.description = lineData.description; currentLine.quantity = quantity; currentLine.price = Utilities.roundToTwo(parseFloat(lineData.price)); currentLine.subtotal = currentLine.quantity * currentLine.price; currentLine.tax = Utilities.roundToTwo(lineData.taxRate * currentLine.subtotal); // add this code to increment every time you click on the same product. const index = this.order.findIndex(line => line.sku === lineData.sku); if (index > -1) { // The order contains a line with SKU 102. this.order[index].quantity++; } else { // The order does not contain a line with SKU 102. this.order.push(currentLine); //Ui.receiptDetails(this); } // comment above //this.order.push(currentLine); Ui.receiptDetails(this); }

[@KuyaRicOfPRU]

Good day! Can you make tutorial on how to make RESPONSIVE PRODUCT CARDS on webpage using Google Sheets & Apps Script?

[@cristcaballero]

Great job but some basic things are missing such as printing the invoice, customer identification, modifying the units sold, can you do it, tell me the price?

[@netboy1102]

@@cristcaballero I can do it for you but how to contact?

[@joseleal6535]

Good evening, you did a great job, i managed to get your app to work with visual studio and on google apps script as long as the script was not associated with the Gsheet. I do not have sufficient skills to debug, I re-entered the script several times but to no avail. Here is the error message that appears when I inspect the page: Uncaught TypeError: Cannot read property 'items' of null I thank you in advance for your help and renew my congratulations !

[@makingsaas]

Thanks for your comment. Check the pinned comment to a video explaining how to copy the GitHub repo for debugging.

[@joseleal6535]

Hello, thank so much for you for taking the time to answer me. I had used the video and the GitHub files. I think there is still an error in the script at this level : function sheetData() { google.script.run.withSuccessHandler(function(dataArray){ items = Object.values(dataArray.items); sales = dataArray.sales; order.menu = items; order.previousSales = sales; Ui.menu(order); Ui.invoiceNumber(order); }).getData(); } sheetData(); Because in the console of the page there is "Uncaught TypeError: Cannot read property 'items' of null" So perhaps "dataArray " is not defined or "function(dataArray)" there is an entry error in ??? Thanks in advance for your help as I don't have enough knowledge to correct the script. Best Regards

[@makingsaas]

@@joseleal6535 Does your spreadsheet have three tabs named: 'Items', 'Sales', and 'Payments' and is the 'Items' sheet populated with some data exactly as shown? You can pause the video at the start and enter some or all of the data.

[@MsDarkPhenix]

​@@makingsaas Hello Friend! Got the same problem as above and my sheet is well populated. Can you help me out ?

[@Wizardofoz1981]

What an amazing work. I still don't get the Javascript part...how do you load your data on your application without inserting the spreadsheet ID? Plese help me understand this.

[@makingsaas]

The script is bound to the spreadsheet because it was created from the sheet using Tools>Script Editor. It is also possible to create 'unbound' scripts independently which would require the Spreadsheet ID.

[@Wizardofoz1981]

@@makingsaas thank you for the explanation 👍🙏

[@jayevolutionx7169]

how did you get the images , did you search one by one?

[@badhurudeenwinapp2832]

How to Print ?

[@tamiaadm46]

terima kasih banyak. thank you very much we are very easy get the code

[@pichit.raetai]

Amazing thank you so much

[@banavan2459]

the website link not working. please update

[@MAX-ox3xh]

Thank you for this great tutorial for us who's trying our best to learn new things. Thank you so much. This may be too much but I hope you include even the sheet and some images you used. It will help a lot if everything will run together with all your file. Then, that's when the time we will understand how everything works immediately, that gives us hope to work hard and learn. Thank you

[@makingsaas]

On the github repo, I put a link to copy the sheet.

[@excelforyouofficeforme3847]

@@makingsaas Link is not working Sorry, the requested file has been deleted.

[@kimail-w1h]

Is there a way to contact making saas?

[@veetisaree]

this error in setData function SyntaxError: Unexpected token u in JSON at position 0 setData @ Code.gs:20

[@makingsaas]

I have posted a video showing how to get the code from Github and get the web app functioning. This may help you debug your code: kzbin.info/www/bejne/eZu5q3mbgLOqZ9U

[@armandomartinezr.8271]

Hi Mark, i got a question, can added a sheet of inventory, if i got a stock and want to know my product left. It is possible ?

[@doncurrency]

i believe your menu images does not display

[@doncurrency]

my menu items and the display does not work and its making me stress up

[@armandomartinezr.8271]

@@doncurrency Can i help you, tell me your situation

[@doncurrency]

the pos system does not load the menu item. that space is blank i have watched the video about a week now over and over and i still cant find the solution. please help@@armandomartinezr.8271

[@netboy1102]

it is possible if you are still interested,

[@ertugrulguven4965]

Hello teacher. How can I open the Open editor? Best regards.

[@netboy1102]

you need o firstly copy the sheet together you will get the app script also copied. Then you have to give some permission to it, because you have to run it on your own account

[@MM-uh6zf]

Do you, do freelancing work, I would be interesting talking with you.

[@toniartos6631]

Awesome sir

[@jaychristcayetano]

how can i change the $ currency in the menu? thanks

[@MrTurios]

My Pictures don´t load ... Have you any Ideas ?

[@makingsaas]

Where are you hosting your images?

[@jonasnghidengwa7186]

Hi sir .... I have Issues with accessing the source code

[@longpham3755]

Thank you so much!

[@nurasian7355]

Best, Please share code, Thank you.

[@makingsaas]

Link to code can be found in this post: projectsforentrepreneurs.com/2021/01/23/point-of-sale-pos-web-app-using-google-sheets-and-apps-script/

[@nurasian7355]

@@makingsaas thank you.

[@KuyaRicOfPRU]

Thank you for this.. I got mine up and running like it should.. Three issues though 1. How can you increment the quantity of the product? 2. The "Close Sale" is not showing if exact amount (Grand Total) is inputted in the Amount Paid. 3. It would be great if we can print it A follow-up tutorial video would be very much appreciated.

[@navinwebnet]

CLOSE SALE COME AFTER YOU ENTER MORE AMOUNT

[@jlamt3000]

Bug was fixed by simply replacing = with >= on the 4th if statement. Look for the following in the javascript: changePayment(input) { const orderGrandTotal = this.getSummary().grandtotal; if (input.invoiceNumber != null) this.payment.invoiceNumber = inputInvoiceNumber; if (input.amountPaid != null) this.payment.amountPaid = parseFloat(input.amountPaid); if (input.type != null) this.payment.type = input.type; if (this.payment.amountPaid >= orderGrandTotal) { this.payment.changeTip = this.payment.amountPaid - orderGrandTotal; Ui.closeButton(false); } else { this.payment.changeTip = 0; Ui.closeButton(true); } Ui.paymentSummary(this); }

[@MsDarkPhenix]

Hello ! I have seen both of your video and still cannot show any items when lunching the app. This is the error I get: VM61:380 Uncaught TypeError: Cannot read property 'items' of null at :380:37 Will you help me please to solve this ?

[@makingsaas]

Try putting some data into the spreadsheet first.

[@JohnJohn-ip2xs]

Hi! Can I get the google sheets of the MOCK DATA that sync to google sheets ??

[@makingsaas]

I added some mock data in the JS file on Github.

[@geezplay6883]

Hi, I would like to know why the sheets doesn't work ?

[@netboy1102]

Need user verification

[@hiddenuserforsubmissions1601]

3 hours but it's catchy

[@shadymohamed1439]

Unfortunately, it is not possible to know who the person who ordered the order is Please tell us how to add the username

[@netboy1102]

this is only basic structure of a pos, the more functions can be add if go deep in

[@vandrew22]

Can you run this on your smartphone?

[@netboy1102]

its not really mobile responsive. but we can make it by replacing some elements, to fit on mobile screen

[@Hiteshhothhh]

Please anyone help me to add Search filters options too. 🙏

[@ernestansah6609]

Hello Sir .. i need your help in creating a pos for Book book shop... please.

[@netboy1102]

I can help, how do we contact then?

[@KHUMSAB2024]

hi can i have the code again?

[@BenavidesMariana]

wao, just what we need

[@BenavidesMariana]

do you sell your service?

[@makingsaas]

@@BenavidesMariana Yes please contact here thanks: projectsforentrepreneurs.com/contact/

[@MannyBernabe]

🔥🔥🔥

[@stephenbryancolasito3633]

is it possible to print the receipt?

[@makingsaas]

One possible way be to create another sheet in the Spreadsheet with a receipt template. A script could be added to populate the template with the current invoice data and download/print it as a PDF. You could also send it as an email using the apps script/gmail.

[@mustaphati]

@@makingsaas but how we can do it ?

[@doncurrency]

this is to any one who can help me get the menu displayed on the screen to help me cos

[@USAMaxOlya]

Hi, Very Nice POS system. Need to do a few customizations, let me know if interested!

[@ramanmaliks]

I watched for 3 hours and download from ur projects and tried to run, only pos screen is comming rest is black screen while clicking hovering cash or cheque icon numbers popup is not coming. Another thing while i download project appscriptt json and licencw file is there have i to create these file on web also. Pleae help me. Regards

[@makingsaas]

After your page loads check the page inspector in your browser and see any errors in the console. That may give you a clue what is going wrong.

[@ramanmaliks]

@@makingsaas Thanks for the reply and I checked console it shows " Uncaught SyntaxError: Unexpected identifier userCodeAppPanel:212". Please reply

[@makingsaas]

@@ramanmaliks If possible, get your project up on github and share the link. You can use the Chrome extension called Github Extension.

[@gsm8052]

@@makingsaas Hi, I am having same issues - was a solution found?

[@makingsaas]

The original commenter did not post their code so I don’t know what the issue is/was. You can post your GitHub link here if you like.

[@minhajisminhaj]

I appreciate your work,you did very well. I desire to integrate a printer with this web app soo could it be possible..??

[@helloparty6416]

Hi dear pleas Help the food icons are not Showing after deploy and when i run the script it Give this error in function include(filename) { return HtmlService.createHtmlOutputFromFile(filename).getContent(); } error Showing -- Bad Value !! can you please Advice what is my mistake ? ND THANK YOU SOOOO MUCH YOU ARE VERY GOOOOD Can you please help me or shear your Google Spreadsheet to this Email : [e-mail] thank you soo much

[@daadhadiwinata4940]

can you add a little script to print out thanks.

[@johnster6595]

Did you found how to print?

[@netboy1102]

Firstly use app script to generate a pdf, and use mailApp to send to your cloud printer's email address to make it happen. But it you meant for pos receipt printer, properly you would need a python server at your shop or home, get the data sctructure in json format to your python server through a webhook. That is the plan. Depending on your use case