How to create used cars database

Create online database in 5 minutes. Today I’d like to introduce you an example of MTH database. In this post I will tell you about MyTaskHelper field types. For example I decided to show "Used Cars" database. It is possible to make the online database in 5 minutes. If you are the cars sales manager this post will be useful for you.

So let’s start. Steps of creation:

1) Go to MyTaskHelper and Login

2) Create you first project - "Used Cars Database". Enter a project name in the field "New project" , please enter the form name - "Used Cars".

3) Now you have the form and you can start to place into the form fields: in this example I tried to use maximum field types (String, Integer, Float or Single Line Text, Text or Multiple Lines, File, Image or File, Image, Video Upload, Boolean or Yes, No, Date and DateTime, Select or Drop Down, Checkboxes, Country). For each field, please, select validation. More about this service you can read here.

- The first field is “Brand”. Choose Select or Drop Down type. Please, find “Set default value” link. Click on it and fill it with your selling brands.

- The second field is “Type”. Select Select or Drop Down type. Click on “Set default value” link and fill it with your selling car types.

- The next field is “Model” – type String. In this field your can enter model of the car (only text symbols).

- Color, type Check box. In this field your can select one of few colors.

- Fields “Description” and “Experts Comment”. Type Text or Multiple Lines

- Field “Price $” – type integer. You can use only numeric data.

- The next field “Credit sale” – type boolean. It’s a Logical type. User can select one of the two logical values (Yes/No).

- Also your can state the date of the sale car, field “Sale Date” – type Date.

- If you need to upload more information about the car you can use fields Image, File.

- To state the country where the car has been taken, please, use field type Country.

- The next Field is “Experts opinion”. To select one of the few points I use field type radio button.

So now your form has done. You can enter data. Go to the menu Records and start data adding. If you have done everything correctly your first record will appear. For form submit use Customize & Integrate module.

===========================================================

• You can find and sort clients in your database using search and sort functions.
• Now you can place this form into your site using Customize and Integrate module.
• MTH supports Database roles. You can edit “Used Cars database” with a team.

10.01.2010 Igor Petrushenko