We have build a CRM system in PHP MYSQL that allows you to create customizable fields on the fly but all these fields data type are text type only I want to the user to be able to create a field data types of as described below DataType : Auto Number : A system-generated sequence number that uses a display format you define. The number is automatically incremented for each new record. DataType: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. DataType: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. DataType: 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. DataType: Checkbox : Allows users to select a True (checked) or False (unchecked) value. DataType: 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. DataType: Number : Allows users to enter any number. Leading zeros are removed. DataType: Percent : Allows users to enter a percentage number, for example, 10 and automatically adds the percent sign to the number. DataType: Phone : Allows users to enter any phone number. Automatically formats it as a phone number.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
PHP MYSQL AJAX