These are the web database most common used data type that you will use when creating a new table or new form. Most HTML form collects all data as words, or text, or string. It is dangerous because the integrity of data is lost. Here are the step by step to create this smart form.

Let do it. The first step 1 of 3:

Picture: Copy the database script. -> Paste in the Code Area -> Click [Submit SQL Code] button will create a new web database table my_support_center. with default a new empty record. Go ahead to enter more data record anytime. Even after the database table is created, you can always go back and change its field names, size, even data type.

Quick description of web database myNet.Dbase

- = If the table has many fields displaying, when clicking on this close icon, that table field, example COMPANY, will not display on screen. Click [Reset] button to redisplay this field.
- To Scroll, you can choose how many records, 5, 10 (default), 20, 50, 100, or all, to display on screen. Thus, it doesn't matter your database contains 100 records (row) or 100000 records, myNet.Dbase loads 10 record rows by default at a time. It is faster and more efficient. Other databases will load all. Thus it is slow. Reset lets you to redisplay all fields.
- To Sort, click on any field header to sort data according to that field. For example, click on NAME or PHONE to sort table according to NAME or PHONE. The number displays under the field name is the size of that field (or column). ID, always in the first column, is the primary key of the table. ASC tells you the sort direction ascending...
- To Add a new record for this table, click on button [Add New Entry] or click on the button [INSERT] of Data Entry form to insert new record.
- To Delete a record, click on icon Del in ACTION column. Or click on the button [DELETE] of Data Entry form.
- To Edit a record, click on icon [Edit] in ACTION column. Or click on the first field table key ID = 1. It will open a Data Entry form. Make changes. Click button [UPDATE] of Data Entry form to save the changes. (See Data Entry form)
- To Email a record, click on icon Email in ACTION column. It will pop up an email interface with default TO = email field of that database record.
- To View a complete all fields of a record of a database table like a report.
- To Customize View: myNet.Dbase lets you View a certain fields when table is displaying. To customize the view of fields:
From main menu: Net.DBase -> View -> An Gui Interface pops up lets you select fields of that table to view on screen.
Next time, when you load that table, it will display fields or columns may interest you. Not all.
For example, Invoice database, each record has about 52 fields, like INVOICEID, CUSTOMERID, INVOICE_DATE, NAME, ADDRESS... The table my_support_center has 14 fields or columns per record row. To select 20 fields to view of Invoice table that has 52 fields, you use [View] sub-menu of Administration menu. Thus, when you open Invoice database, it displays only 20 fields you want to see. If it displays 56 fields, that is too long for a row to display on computer screen. If you want to see the rest all fields, you click on icon View in ACTION column.
At the right side:
-  Table: -> To Open a table, you can use a database script. Or select from the right side pull down list of all database tables you created. At Table:
- Action: To run database administration using step by step. Most actions, like Change Name of a column field,  you will get the same results using database script faster.
- The Search box: To Search, enter the name, for example like John Smith, or email = john@yahoo.com. Then select category = NAME or EMAIL to search that record.

Few Simple Database Administration using database script SQL

To add extra column field in this table, for example the field OFFICE_NOTES with data type = Text after the exiting column SUPPORT_TIME, run this blue database script in Code Area.
ALTER TABLE my_support_center ADD Office_Notes text  AFTER  SUPPORT_TIME;
NOTE The blue code is case is not sensitive. Spaces between words are not important.

To add extra column field in this table, for example the field COMPANY_SIZE an integer after the exits column COMPANY, run this blue database script code in Code Area.
ALTER TABLE my_support_center ADD Company_Size int default 0 AFTER Company;
NOTE int default 0 =  tell database this field is an Integer and has the default = 0 (or 3 or 5..)

Or to add a field ALREADY_MEMBER of Enum type, value = "yes, no, will register", after column SUBJECT. Default value is the first value = yes
You enter the blue database script, one at a time, in the Code Area. Then click [Submit SQL Code]. Case is not sensitive.
ALTER TABLE my_support_center  ADD ALREADY_MEMBER enum ( 'yes', 'no', 'will register' ) default 'no' AFTER Subject

To Change a column name of a database table, for example change name Already_Member to become new name = Is_Aready_Member with new values
ALTER TABLE  my_support_center  Change Already_Member  Is_Already_Member  enum ( 'yes1', 'no1', 'will1' )

To Change a column name, data type, and value of a database table. For example change name Already_Member to become new name = Is_A_Member. Change data type from Enum = to select 1 option into Set = to select many options, and new values.
ALTER TABLE  my_support_center  Change Already_Member  Is_A_Member  set ( 'Gold', 'Silver', 'Brown' , 'Free')

To Delete a column of a database table:
alter table my_support_center  drop column ALREADY_MEMBER ;

** Click here To Learn Basic Database Programming Script 
** You can build a whole complex big database with many related tables using Database Relationship Methodology. It is linking tables using Primary Key. Then use database script SQL to search for data in multi-related tables.

CONGRATULATIONS! YOU HAVE JUST CREATED A WEB DATABASE TABLE WITH COMPLEX DATA TYPE IN JUST 10 MINUTES.

The next step 2 of 3:

1. First, Design web page named Support Center display on website for people to submit.
   - From [Net.Page] -> [New Page] -> Enter at top left corner box [Fname] = Support Center -> Click to select Menu Navigation for this page = Sub Menu (the round button) -> From the pull down list display of all web pages, you select the web page Become a partner so that this web page Support Center becomes its sub menu.
   - In the editor area, type text, design the content of the web page Support Center. -> Click on [Save] button to save. Click on [View] to view this page in real time. (See picture) Now, you have just created a Support Center page under the main menu webpage Become a partner.
   NOTE: If you select webpage Support Center as Main Menu, then it displays the top menu like Home main menu. You can have sub-menu level 2 or sub-menu of of sub-menu. In this example, Support Center is sub-menu level 1 because Become a partner is main menu. Use Page Manager to insert icon in the menu.
   
   
    
2. Next, Insert Smart Form Builder in Step 1.
   From main menu [Insert] -> Select submenu [Smart Web Database Form Builder] will pops up an window interface (GUI). You fill these information:
   - At 1) FORM TASK = Support_Center. Which is the Task of this form used as Name for this form.
   - At 2) FORM FORMAT = Table Format Form. It is the form format display. There are 2 formats: Table format and Blue Round Corner Format also called Nifty.
   - At 3) FORM TABLE = my_support_center. It is the database table that contains the data submitted by the form.
   - At 4) Select Webpage = Support center. It is the webpage you just created and save in step 1. You can select any webpage. It you don't select, then it assumes that you create a Private Link Form. People access to Form from its link in email.
   - At 5) Check box [v] = Do You Want to Receive Email.. So that Smart Form will send the content of the form to people you set up in Email Manager.  
   Click [Next>] button.
    
3. In Step 2 of 2 - Insert Smart Form Builder
   You click to select fields of table my_support_center in the left column. Then click [->] arrow to move these selected fields into the right column. Do not remove the pre-selected fields ID (table primary key), and EMAIL. Then click [OK] button.
   
   
   Picture: Step 2 of 2 SMART FORM BUILDER to select fields for the form.
   Note: we do not select NAME, or OFFICE_NOTES field for the form. That's why you don't see it created in this Support Center form.
   - After form submitted, fields that are not selected for form will have values blank. You have to open that table to enter data for empty fields.
   - The order of the fields you select will become the order of the form field. The primary key field ID Integer type will not display in the form because ID is a table key, auto increasing to 1 when adding a new record in the table. People don't need to enter anything in that field. Form is starting from EMAIL field.

CONGRATULATIONS SIR/MADAM! YOU HAVE JUST CREATED SMART FORM WITH COMPLEX DATA IN JUST 15 MINUTES WITHOUT ANY PROGRAMMING.
 

THE EMAIL CONTENT OF THE FORM IS SENT TO CUSTOMER AND IN-HOUSE STAFF AFTER FORM WAS SUBMITTED.


Picture: This is the email of the form content are sent to both in-house staffs and customer received.

- Email of customer= build_eshop@yahoo.ca. Email of in-house staff specified in ETO = daviddnct@yahoo.com.
- There are many in-house staffs' emails who also receive this email but you don't see displayed here because their emails are in BCC.
- Because in Smart Form Builder, at STEP 1 OF 2,  you select check box [v] to receive email. This is mail is setup in Email Manager = table x_email_manager
- If you don't want the person who submit this form not receiving this email. In table x_email_property, select field MEMBER_RECEIVE = no.
- Your in-house staff will receive emails any where they are, in their Black Berry. They reply the email customer requests quickly. When they login Admin, they will update question in database for other support staffs to know.
 

- Copy and Paste the create database table blue script code in the Code Area. Then click on button [Submit SQL Code].
- A new database table = my_upload_resume_files is created with a default an empty record.


Picture: A new database table = my_upload_resume_files is created. It is used to store submitted data from this Upload Files and Resume Form.

Next, Step2:
- From [Net.Page] -> Select New Page -> Create the webpage with menu navigation named = Upload files as a sub-menu of main menu = Jobs and Supports.
- Then Save this webpage first before inserting the smart form builder tool.
- Next, from [ INSERT ] main menu tool, select tool = Smart Web Database Form Builder -> Then follow its instruction to create this form.


Picture: Use myNet.Word to create a webpage. Then use Smart Form Builder to select what fields will be on the form. The field OFFICE_NOTES is not selected.
NOTE: The primary key of the database table = UID is pre-selected.
- The order of fields display on form depending on the order you select. In this care First Name is the first order. You can select Email field to display first on the form.

CONGRATULATION! You have just created this smart form Upload files and Resume in just 2 STEPS.

The result of the Upload files form as seen on your website.

Picture: The screen of this upload files form on your website. You can create as many as 30 upload file buttons in a form.

CONGRATULATION SIR/MADAM! YOU HAVE JUST CREATED A RESUME DATABASE AND ITS WEBSITE FORM IN JUST 15 MINUTES WITHOUT ANY PROGRAMMING.

What happens after people submitted files using this form?

All files, pictures, that were uploaded, are saved in your website server folder = /upload/.

Picture: After Dan Smith submitted this form, this is the second record that was created in resume database.

- Open this database table, click on files, it will lunch your Ms Office in your laptop computer. Click on picture, it uses web browser to open.
- You can also use myNet.Explore to open files and work, print, download, upload, collaborate wherever you go, in meeting, hotel, convention, at home...
- Now, your company have a database of resume so that all staff can work, search, and collaborate on resumes.
- The resume database doesn't store upload files. Just the names of upload files. This way is much better than to store people's resume information directly in database table.

To find all resumes where the JOB APPLY = Manager ( any job apply that has words like manager), you run this database script:
Select * from my_upload_resume_files where JOB_APPLY like ' %Manager% '

To find all resumes where the Last name = Smith , you run this database script:
Select * from my_upload_resume_files where Last_Name = 'Smith'

It is easy for your company to maintain. Imagine, your company stores all resume in email. It is so hard to share, collaborate and maintain.
NOTE: Email is not database. Email is not safe, easy to be hacked, spy ware, viruses. Use form to submit files instead of email files.
- If you need your members to upload important files, use Member Collaboration to create a Member Task = Upload form like this form. Members login your website to upload files.

** Option *** Setup Email Notification for this Upload Resume form

Let you setup email notification for this form, for example: Who your staff's email will receive email notification when people submit this form...You put their emails in ECC, EBCC columns.

Open database table = x_email_property of Email Manager. Select the record  ETYPE = upload_resume. This record is created by Smart Form Builder when you use it to create this form. You just need to fill info for Email Notification.


Picture: Smart Form Builder automatically created this default empty record, ETYPE = upload_resume.

- The Form Task Name = ETYPE = upload_resume, you named when you used the Smart Form Builder tool.
- If you don't setup, it is ok, but no email is sent out after people submitted this form.


Picture: Fill all info of Email Notification for this form: EFROM_AUTH_PW, EFROM, ELOGO...
That is it for the setup Email Notification for this form.

Use Member Collaboration to create Smart Form for Members Login their account or Member Home to submit files.

If you want to collect data from private members who will submit form from login your website. Use Member Collaboration to create a member task to upload files. Member logins your website in their  MEMBER HOME to submit data, upload files...

Create Url link to the form and send email the Url link form to member or staff to submit data.

You can also collect data, files by creating an Url link and then send email to members or staff to fill the form. They click on the link that pops up a form.
 

Table Sales_Collection given percentage of Tax1= 0.05 and percentage of Tax2= 0.08 of Sub_Total sales.
You can add more fields like Invoice_Id, Sales_Rep, Company_Name, Phone, Email... in to this form table. In this example, we just want to make it simple.

If using Text Processing Form to collect data, you will get all garbage data dumped in email or or in files.

• Without myNet.Office, without web skills, even if you are web designer, YOU WILL NEVER BE ABLE TO DESIGN SMART FORM.
Now, with myNet.Office you can do it with only 3 Steps. We hope after reading this tutorial, you understand more about data type, database, form...
 
What do we use website form for? Because we want to collect data. The best feature of myNet.Office Smart Form Builder is that it lets people to build smart form without any web skills. Web database Smart Form brings the website form to the next level. That's what we want to do. We want to bring the website, the form... to the next level, the smart web, the smart form. Use Smart Form is R.O.I.