The database holds a collection of all the beverages that are offered. However, it is easy to replace the beverages with any other items you want to sell. The Ingredients table offers more information about the beverages. The Cups table allows you to offer the items in different sizes and automatically calculate the additional charges that comes with such a request.

The tables Orders and Order details contain the actual orders from the customers. Customer details are not stored in the template. Both the Orders and Order details table contain multiple views that allow the staff members to immediately detect which orders are already finished and which items need preparation.

The Quantities table is purely used by the application. It offers the customer the possibility to select the number of items he wants to order for a certain product.

All tables have specific fields or views that offer insights in the sales process. You can detect which beverages are the most popular, which ingredients are demanded most and how many beverages the average customer orders.

The application template is designed with big buttons so that it is touch friendly. It can be used on any type of device. From the smartphone of the customer to a big kiosk inside your business, the application will adapt to the size of the screen. The flow is designed so that the user can make his order step by step and make adjustments to the order at any time in the process.

Database: Order Kiosk

Beverages

Fields

• Name (Text)

• Description (Text)

• Basic price (Number)

• Image (File)

• Favorite from (Date)

• Favorite until (Date)

• Is flavor of the month (Formula)

• Ingredients (Link to table)

• Order details (Link to table)

• Amount of orders (Rollup)

• Flavor icon (Formula)

Views

• All beverages (grid)

• Flavor of the month (grid)

• Gallery: all beverages (gallery)

• Calendar: flavor of the month schedule (calendar)

Ingredients

Fields

• Name (Text)

• Description (Text)

• Category (Single select)

• Beverages (Link to table)

• Number of beverages (Rollup)

• Number of times ordered (Formula)

Views

• All ingredients (grid)

• Ingredients used in multiple beverages (grid)

• Ingredients used in only one beverage (grid)

• Ingredients by category (kanban)

Cups

Fields

• Name (Text)

• Extra charge (Number)

• Order details (Link to table)

• Amount of orders (Rollup)

• Display name (Formula)

Views

• All cup sizes (grid)

Orders

Fields

• Order ID (Uuid)

• Date (Created on)

• Is completed (Rollup)

• Order details (Link to table)

• Total price (Rollup)

• Amount of beverages (Rollup)

• Pickup number (Autonumber)

• Date (format) (Formula)

• Day (Formula)

Views

• All orders (grid)

• All orders grouped by day (grid)

• Completed orders (grid)

• Open orders (grid)

• Orders with a single beverage (grid)

• Orders with multiple beverages (grid)

Order details

Fields

• Name (Formula)

• Order (Link to table)

• Beverage (Link to table)

• Size (Link to table)

• Subtotal price (Formula)

• Quantity (Link to table)

• Size name (Rollup)

• Basic price (Rollup)

• Order number (Formula)

• Is ready (Boolean)

Views

• All order details (grid)

• All order details grouped by order (grid)

• All order details grouped by order and size (grid)

Quantities

Fields

• Name (Number)

• Order details (Link to table)

Views

• All quantities (grid)

Application: Order Kiosk

Welcome

Data sources

Actions (event)

• create_row (click)

• open_page (click)

Menu

Data sources

• Beverages

• Order

Cup selection

Data sources

• Beverage

• Order

• Cup sizes

Quantity selection

Data sources

• Beverage

• Order

• Cup size

• Quantities

Order detail confirmation

Data sources

• Beverage

• Order

• Cup size

• Quantity

Actions (event)

• create_row (click)

• notification (click)

• open_page (click)

Ingredients

Data sources

• Beverage

• Order

• Ingredients

Order details

Data sources

• Order

• Order details

Actions (event)

• delete_row (37d84aef-9ab4-49bc-8aef-657ebd035572_click)

• refresh_data_source (37d84aef-9ab4-49bc-8aef-657ebd035572_click)

Checkout

Data sources

• Order

• Order details