Database

Tutorial 1

So lets build the form below notice the sticky to the right letting us know the total ?

Here is the concept Joe Wants to start up a pizza franchise. His factory makes pizza and he franchises out to some franchises who hire employees. Joe wants a system that 1 will take the customers name and order. Secondly the form has to send an email to the employee who took the order confirming the order, to the customer that bought the pizza, the correct owner of the franchise that sold the pizza for record keeping. Franchisee 1 does not want to see Franchisee 2’s two order and Franchisee 2 does not want Franchisee 1 knowing how he was doing. Similarly, the owners do not want the other employees knowing how the others are doing.

So we need three things: 1) A basic Form letting us know about the customer order {see below} 2) A way to get the employees into the system along with {Registration Forms} 3) Program up the form to send the order based on how we registered the user. Lets Start with the from See below.

BUILDING THE FORM

Three things to be noticed about the input area 1) the blue border, the yellow backgound and the little sticky on the pcs showing the order total 2) the logo 3) the pricing and conditional logic

The Fields Used

The Fields

The Fields

 

Feature Title

Feature content

The basic field all database and windows design is based on.  Windows and Gnome Programmers will recognize most of the above but we will go through them.

Single Line Text

This is just a short text field meant to hold either a name, telephone number, item anything less than 255 alpha-numeric characters in length

Drop Down

This is just a drop down list.  The user can select a single value and only a single value.

NUMBER

Same as the single line text made to ensure the user enters a number.  Not “A Number”  yes we have some people that when playing guess the number will enter “A Number” instead of 1 or 2 or 3 or 4.  And amazingly these people will think your an idiot.

Radio Buttons

Same as the windows one and just like the drop down list  you give them a bunch of premade options and only one is allowed to be chosen.  Examples would be male or female [yes yes I know these days we get binary], sick or healthy [I am sure one day someone would be made to feel special], the colors of the rainbow.  The basic idea is instead of the combo box (drop-down list) the user does not scroll through but can see all the choices at once.

HTML

HTML is Hyper-Text Markup Language.  This is standard web language like your reading now.  This is used to create information boxes and warnings and display text.  For example if the user says I am working above 12 feet or in a confined space the form can display a warning giving them further instructions like this

Warning You need fall arrest Equiment

PAGE

Used to split content up into next page so the user does not get tired of entries.  For example the first page can be his information, the next page can be his work history, the next can be his hobbies, the next can be his application for employment.  Or the first page is his information, the next is his hazard assessment, the last can be the work he did.

PARAGRAPH TEXT

This is the same thing as the single line text but mean’t for longer texts.  Instead of YES/NO the user can enter in a novel.

MULTI SELECT

This is basically a combo box (Drop Down List) that allows the user to select multiple values) for example did he wear steel toe boots, did he don a hardhat, did he wear a tie, did he have to use tools, did he pick up a pen ?

CHECKBOXES

Just is just a multi-select radio box.  The choices instead of being in a drop down list are displayed side by side

HIDDEN

This is a specialized field used to transfer information we don’t want the user editing for example his name and company.  the date and time of submission.  the database this would be written into. specialized diet information.

SECTION

This is the same as page but instead of having the user scroll through multiple pages you break the page up into sections.  For example, user name, info, address, dependants, coverages applied for

Database Design Concepts

So we developed this database forms to solve a variety of situations encountered in small business activities.  Most of this has been designed so the office administrator/secretary can create the form and make the changes within 5 minutes of receiving the order.

What can you do with them ?

Quite Simply:

  • Take Surveys
  • Check to see if your potential client needs your services
  • Create Quizzes
  • Quality Control Sheets
  • Invoices
  • Quotes
  • Custom Menus and Quotes
  • Plus many More

Before you read on there are some terms that the base layman needs to know:

  1. Conditional Logic – when the user enter or answers a question can the form change its response.  For example if the user tells you he has no dependents do you really want to ask him questions about his dependents.Below is an example of Conditional Logic:                                           
  2. Variables – this is a value that varies or is an amount unknown to us:Below is an example of a variable (I have no clue as to the product you would select or the quantities yet we have to calculate the total price): 
  3. Dynamic Lists – when we don’t know the number of entries we would need, examples would be the names of dependants, the lines on an invoice or estimate

 

Back to Top

2XL4U DESIGNERS AND PROGRAMMERS
DESIGNED 2XL4U ANALYTICS LTD. CORPORATE DESIGNERS.