Pizza Delivery Tutorial
Jump to navigation
Jump to search
Create the Database
This is usually done in any MySQL client like phpMyAdmin (nudb) before installing NuBuilder4 and may already have been done if a login was attempted before.
CREATE DATABASE IF NOT EXISTS nubuilder4 CHARACTER SET utf8 COLLATE utf8_unicode_ci;
Install system tables
- nuBuilder4 Web Login with default user / pass: globeadmin / nu
- On first login, the system tables get populated from nubuilder4.sql.
Install Tutorial tables and data
- Navigate to Home => Builders => Database => Import => Pizza.sql.zip
- Close phpMyAdmin tab and return to Builders tab in nuBuilder4
Create Fast Forms for each tutorial table
customer
- Navigate to Home => Builders => Fast Form
Parameter | Value |
---|---|
Form Type | Browse and Edit |
Table Name | customer |
Add Objects | Input:Text, TextArea, Input:Text, TextArea |
Edit Labels | Customer, Address, Phone, Notes |
Use Arrow keys to set Field Name | cus_name, cus_address, cus_phone, cus_notes |
Browse Column | Tick first 3 only |
- Click the Build Fast Form button at the top left corner
- Screenshot
- Navigate to Home => Setup => Forms
- Click on the record having Table customer with Code FF0
- Replace field Code with CUS and Description with Customer and click Save button.
- Navigate to Home => User Home => Customer => Add
- Click the Form Settings (three vertical dots) button and select Arrange Objects and arrange the form's layout (Video 3:28 mins).