Pizza Delivery Tutorial: Difference between revisions
Jump to navigation
Jump to search
| Line 37: | Line 37: | ||
* Navigate to '''Home => Setup => Forms''' | * Navigate to '''Home => Setup => Forms''' | ||
* Click on the record having Table '''customer''' with Code '''FF0''' | * Click on the record having Table '''customer''' with Code '''FF0''' | ||
* Replace field Code with '''CUS''' and Description with '''Customer''' and click Save button. | * [[Media:CustomerFormRename.png|Replace field Code with '''CUS''' and Description with '''Customer''']] and click Save button. | ||
* Navigate to '''Home => User Home => Customer => Add''' | * Navigate to '''Home => User Home => Customer => Add''' | ||
* Click the '''Form Settings''' (three vertical dots) button and [[Media:PageSettingsMenu.png|select '''Arrange Objects''']] | * Click the '''Form Settings''' (three vertical dots) button and [[Media:PageSettingsMenu.png|select '''Arrange Objects''']] | ||
Revision as of 19:10, 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 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
