Pizza Delivery Tutorial

From nuBuilderForte
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

product

invoice

item subform