Pizza Delivery Tutorial: Difference between revisions

From nuBuilderForte
Jump to navigation Jump to search
Line 33: Line 33:
|-
|-
|}
|}
* Click the "Build Fast Form" button at the top left corner
* Click the '''Build Fast Form''' button at the top left corner


=== product ===
=== product ===

Revision as of 18:35, 4 January 2021

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

product

invoice

item subform