What is a Database?
A database is a repository that stores and organizes information. Soffront databases are made up of multiple tables each of which contains different fields to store relevant information. The database is organized in such a way that the CRM can easily find the information you are looking for.
How to Add Custom Fields in a Database?
You can add custom fields to your database if the fields you want to add to your database are not present by default.
To add custom fields to your Database follow the steps below
1. From the Home screen of your CRM, navigate to the Settings icon and click on it.
2. On the Settings page, click on the Database option under Customization.
3. Then select the Table whose form you want to customize. (For this article we will select the Accounts Form as an example) You can add custom fields to the other Tables (Contacts, Opportunities, Cases, etc) as well.
4. Customize Accounts database form shows up.
5. All required fields are marked in Red.
6. Left-click on any field and then click Insert field on the Database form.
7. The Add Field dialog box shows up. Make sure to choose a custom field for the Field name.
- Field Name: Choose desired custom field as per your requirement from this drop-down list. The custom field will appear with the length of the characters to create in the custom field. For example, Custom Field9 (255) where 255 is the total number of characters allowed for the field name.
- Field Label: By default, there is a unique field label for each custom field but you can modify it as per your requirement. While mentioning the field label makes sure the label is unique. Once you change the Field Label the Field Name will be the same as that of the label. Refer to the image below:
- Field Type: For text-type custom fields, this drop-down list has two options; Text and List. For the Date type, it has two options Date and Date Time. For numbers, it has two options Float (numbers with decimal) and Integer which stores only numbers.
- List Type: This field is enabled only when List option is selected in the Field type field. This drop-down list has two options None and Regular List. If the Regular list is chosen the List Items button is being enabled automatically, provide values for your regular list using the dialog box which comes up after clicking on the List Items button.
- Default: Here you can define the default value for that particular field which will comes automatically when the submit form loads.
- Description: Use this field to add meaningful and sort descriptions for your custom field.
- Length: It is the maximum length of characters that will fit into the field.
- Required: This option allows you to make your custom field required in the record creation as well as the modification form.
- Non Editable: This option allows you to make your custom field as a non-editable field in the record creation as well as modification form. Please choose the default value for your custom field if you are assigning this attribute.
- Add to this List : This option allows the user to modify the list values in the run time for the custom list-type fields.
- Phone Field: This option will allow you to use the field for storing numbers.
8. You can drag and drop your field to your desired location within the form by using the 
icon available at the left side of your field. This is available for all fields.
9. Once you are done click the Save button to make the changes permanent.