Default Field Values
Information on default values for nullable fields when creating new records.
These values should be set or changed by an experienced system administrator or by Professional Services. This should not be confused with Configuration Settings, which control default settings which are configurable in the Platform.
Nullable (Non-Required Fields)
When a new record is created, a default value is inserted for any nullable fields with a default value defined in SQL Server.
Default values have no impact on required fields in the Platform.
Example
If you have a field Groups.Target_Size with a default value of 12, that value is automatically saved in the field if it's left empty when creating a new Group record.
Side Effects
A User sees default values when opening a new record and can change the value before saving. In the previous example, the Group Target_Size would start as 12.
This can be useful for fields that you want to ensure are set with a particular value and not left blank. If you are creating custom fields, remember this if you add a default value.
Potential Errors
If a default is defined on a Foreign Key field and the default value doesn't not have a corresponding record in the related table, the following Error can result:
Record Corresponding to provided identifier is not found: Parameter name: value
To fix this Error, change the default value defined in the database.