We have build a CRM system in PHP MYSQL that allows you to create customizable fields on the fly but all these fields datat type are text type only I want to the user to be able to create a field data types of
Auto Number : A system-generated sequence number that uses a display format you define. The number is automatically incremented for each new record.
Formula : A read-only field that derives its value from a formula expression you define. The formula field is updated when any of the source fields change.
Roll-Up Summary :
A read-only field that displays the sum, minimum, or maximum value of a field in a related list or the record count of all records listed in a related list. You cannot create this type of field on this object because it is not the master in a master-detail relationship.
Lookup Relationship : Creates a relationship between two objects so you can associate two records with each other. A lookup relationship creates a field that allows users to click a lookup icon (Magnifying Glass Icon) and select another record from a popup window.
Checkbox : Allows users to select a True (checked) or False (unchecked) value.
Currency : Allows users to enter a dollar or other currency amount and automatically formats the field as a currency amount. This can be useful if you export data to Excel or another spreadsheet.
Date Allows users to enter a date or pick a date from a popup calendar.
Date/Time : Allows users to enter a date and time, or pick a date from a popup calendar. When users click a date in the popup, that date and the current time are entered into the Date/Time field.
Email : Allows users to enter an email address. The entered address is validated to ensure that it is in the proper format. Users can then click on the field to automatically launch their email program and send an email to that address.
Number : Allows users to enter any number. Leading zeros are removed.
Percent : Allows users to enter a percentage number, for example, 10 and automatically adds the percent sign to the number.
Phone : Allows users to enter any phone number. Automatically formats it as a phone number.
Picklist : Allows users to select a value from a list you define.
Picklist (Multi-Select) : Allows users to select multiple values from a list you define.
Text : Allows users to enter any combination of letters and numbers.
Text Area : Allows users to enter up to 255 characters on separate lines.
Text Area (Long) : Allows users to enter up to 32000 characters on separate lines.
URL : Allows users to enter any valid website address. When users click on the field, the URL will open in a separate browser window.
WE MUST BE ABLE TO ADD THE FIELDS DYNAMICALLY
you can see a demo of the crm at
[url removed, login to view]