Pizza Delivery Tutorial

From nuBuilderForte
Revision as of 19:40, 4 January 2021 by Apmuthu (talk | contribs) (→‎customer)
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 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