In Part I, we demonstrated how to add course and input discount on the user interface. The next step is to create a/ the “INSERT” button to transfer all the added transactions to database and feed the information to the receipt, b/ the “CLEAR” button for our client to reset and clear all the input he makes on the user interface and c/ the “Export_PDF” button to generate receipt automatically for customers. Here are the steps.

Completed in Part I

1. Developed a framework to build a POS platform on Google Sheets
2. Understood the data structure and setup for data input
3. Created “ADD” button to allow client to add multiple courses on the user interface

In this blog, we focus on

1. Create “INSERT” button to add the transactions to the database and receipt page
2. Create “CLEAR” button to reset and clear all the input client makes
3. Create “EXPORT_PDF” button to generate a receipt in PDF format automatically
4. Create “CLEAR_PDF” button to clear all the content in the receipt

Let’s recap the user interface page and spreadsheet structure.

“UI_Payment” - Prototype - User Interface

Spreadsheet structure

Design + Code

Create “INSERT” button