---
schema_version: "1"
id: 9bf460a5fab10c1167ba939a2fce300bb13b44881f747ef1e07e04fe2ca837b4
title: Custom Field Attributes
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/platform/264-0-0/custom_field_attributes.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.custom_field_attributes.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 9efbaa515be298800cda6755678c6f84b9bd13e9dddf2aa58d92b7eaf2812713
description: A custom field has different attributes depending on its field type.
products:
  - Salesforce Platform
  - Security
release: "264"
---
# Custom Field Attributes

A custom field has different attributes depending on its field type.

![Important](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-extend_click-264-0-0-production-enus/5f7d9219-b7b1-4552-8891-f1aba9b289fc/images/icon_important.png)

Important Where possible, we changed noninclusive terms to align with our company value of Equality. We maintained certain terms to avoid any effect on customer implementations.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:39.185%">
          <col style="width:60.815%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d121321e41">Field</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d121321e44">Description</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 "># Visible Lines</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">
              <p>For Long Text Area fields, set the number of lines to be shown on Edit pages.
                You can show from 2 through 50 lines (the default is 6 lines). If the text doesn't
                fit in the specified number of visible lines, scroll bars appear. Long Text Area
                fields are fully shown on detail pages and printable views.</p>
              <p style="margin-bottom:0;">This attribute's value
                isn't respected for Long Text Area and Rich Text Area fields in Lightning
                Experience.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Calculation Options</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">Determines how a <a href="https://help.salesforce.com/s/articleView?id=platform.fields_about_roll_up_summary_fields.htm&amp;release=264.0.0&amp;type=5" title="A roll-up summary field calculates values from related records, such as those in a related list. You can create a roll-up summary field to display a value in a master record based on the values of fields in a detail record. The detail record must be related to the master through a master-detail relationship. For example, you want to display the sum of invoice amounts for all related invoice custom object records in an account’s Invoices related list. You can display this total in a custom account field called Total Invoice Amount.">roll-up summary field</a> is
              recalculated after its properties change. Select <strong class="uicontrol">Automatic
                calculation</strong> to recalculate a field the next time it’s displayed.
              Select <strong class="uicontrol">Force a mass recalculation of this field</strong> as a safety
              net option to force recalculation of the roll-up summary field values.</td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Child Relationship Name</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">The name used in API SOQL relationship queries.</td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Data Type</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">The data type of a field determines what type of information is in the field.
              For example, a field with the Number data type contains a positive or negative
              integer. For more information on data types, see <a href="https://help.salesforce.com/s/articleView?id=platform.custom_field_types.htm&amp;release=264.0.0&amp;type=5" title="Salesforce supports various field types, allowing you to select the right one for your data. You can also convert an existing field to a different data type if needed.. When you have data that doesn’t match any of the standard fields, your admin can create a custom field for that data. For example, create a Middle Name field for contacts to capture additional information.">Custom Field Types</a>.</td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Decimal Places</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">For currency, geolocation, number, and percent fields, this field represents
              the number of digits you can enter to the right of a decimal point. The system
              rounds the decimal numbers that you enter, if necessary. For example, if you enter
              <kbd>4.986</kbd> in a field with Decimal Places set to
              <kbd>2</kbd>, the number rounds to 4.99.
            </td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Default Value</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">The value to apply when a user creates a record. For custom checkbox fields,
              select <strong class="uicontrol">Checked</strong> or <strong class="uicontrol">Unchecked</strong> as the
              default value to indicate the default when creating records. Don’t assign default
              values to fields that are both required and unique, because uniqueness errors can
              result. See <a href="https://help.salesforce.com/s/articleView?id=platform.fields_about_default_field_values.htm&amp;release=264.0.0&amp;type=5" title="Prepopulate field values with defaults to save your users time and improve consistency. Default field values make your users more productive by reducing the number of fields they must fill in manually.">Default
                Field Values</a>.</td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Description</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">Text that describes the custom field. This description is for administration
              purposes only and doesn’t appear to users on record detail and edit pages that
              include the field.</td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Display Format</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">
              <p>For auto-number fields, enter a Display Format to control formatting details
                such as the minimum number of leading zeros and any prefix or suffix for the
                number.</p>
              <p>Begin by entering the required minimum <kbd>{0}</kbd> as a
                placeholder for the auto-number without any leading zeros. Add any prefix to your
                number before this placeholder and insert any suffix text after the placeholder.
                Insert any date prefixes or suffixes in the form of <kbd>{YY}</kbd>,
                <kbd>{YYYY}</kbd>, <kbd>{MM}</kbd>, or
                <kbd>{DD}</kbd>, which represent the record creation date in
                Greenwich Mean Time (GMT).
              </p>
              <p style="margin-bottom:0;">For information on using auto-number formats
                when entering your Display Format, see <a href="https://help.salesforce.com/s/articleView?id=platform.custom_field_attributes.htm&amp;release=264.0.0&amp;type=5">Auto-Number Formatting Examples</a>.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Encrypted</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">If checked, this custom field is encrypted using Shield Platform Encryption.
              See <a href="https://help.salesforce.com/s/articleView?id=xcloud.security_pe_vs_classic_encryption.htm&amp;language=en_US" target="_blank">Differences Between Classic Encryption and Shield
                Platform Encryption</a></td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">External Column Name</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">
              <p>Available on external objects only. Maps the custom field to an external data
                source’s table column.</p>
              <p style="margin-bottom:0;">For a lookup relationship field, specify the external table
                column that contains 18-character Salesforce IDs.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">External ID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">
              <p>
                <span id="custom_field_attributes__ExternalIDDef"><a name="custom_field_attributes__ExternalIDDef"><!-- --></a>For each object that can have custom fields, you can set up
                  to 25 custom auto-number, email, number, or text fields as external IDs. An
                  external ID field contains record identifiers from a system outside of
                  Salesforce.</span>
              </p>
              <p>You can use an external ID field to update or upsert records using the API. When
                using the API or the Data Import Wizard for custom objects and solutions, you can
                use this field to prevent duplicates by also marking the field as Unique.</p>
              <p id="custom_field_attributes__ExternalIDLimit"><a name="custom_field_attributes__ExternalIDLimit"><!-- --></a>Custom fields marked as Unique count against an object's
                limit of 25 External ID fields. Custom indexing that occurs automatically in the
                background by Salesforce doesn’t count against External ID limits.</p>
              <p style="margin-bottom:0;">Not
                available for external objects. Each external object has an External ID standard
                field. Its values uniquely identify each external object record in your
                org.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Filter Criteria</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">The criteria used to select a group of records to calculate the value of a <a href="https://help.salesforce.com/s/articleView?id=platform.fields_about_roll_up_summary_fields.htm&amp;release=264.0.0&amp;type=5" title="A roll-up summary field calculates values from related records, such as those in a related list. You can create a roll-up summary field to display a value in a master record based on the values of fields in a detail record. The detail record must be related to the master through a master-detail relationship. For example, you want to display the sum of invoice amounts for all related invoice custom object records in an account’s Invoices related list. You can display this total in a custom account field called Total Invoice Amount.">roll-up summary
                field</a>.</td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Filtering Disabled</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">For custom fields on external objects, determines whether the field is available
              in filters.</td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Formulas</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">Enter the formula for the custom formula field or the custom summary formula for
              reports.</td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Help Text</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">The text that appears in the field-level help hover text for this
              field.</td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Is Name Field</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">
              <p>For external object fields of type text, specifies this custom field as the name
                field for the external object. Not available for text area fields. By default, the
                External ID standard field is the name field for the external object.</p>
              <p>If you select
                this checkbox, make sure that the External Column Name specifies a table column that
                contains name values. Each external object can have only one name
                field.</p>
              <p style="margin-bottom:0;">For
                internal use only, Salesforce stores the value of the name field from each row
                that’s retrieved from the external system. This behavior doesn’t apply to external
                objects that are associated with high-data-volume external data sources.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Label</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">The name of the custom field as you want it to appear.</td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Latitude and Longitude Display Notation</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">
              <p>For geolocation fields, determines how the latitude and longitude notation
                appears in the Salesforce interface.</p>
              <div id="custom_field_attributes__latlongnotedef"><a name="custom_field_attributes__latlongnotedef"><!-- --></a>
                <dl>

                  <dt style="font-weight:bold;padding-top:.25rem;">Degrees, Minutes, Seconds</dt>

                  <dd style="padding-left:1.5rem;padding-bottom:.5rem;">A notation for angular measurement that is based on the number 60: there
                    are 360 degrees to a circle, 60 minutes to a degree, and 60 seconds to a
                    minute.</dd>


                  <dt style="font-weight:bold;padding-top:.25rem;">Decimal</dt>

                  <dd style="padding-left:1.5rem;padding-bottom:.5rem;">Expresses the value as degrees, and converts the minutes and seconds to a
                    decimal fraction of the degree. Decimal notation doesn’t use cardinal
                    points. North and East are positive values; South and West are negative
                    values.</dd>

                </dl>
              </div>
              <p>For example, the coordinates for San Francisco can be expressed
                as:</p>
              <p>Latitude: 37° 46' 30" N, Longitude: 122° 25' 5" W or</p>
              <p>Latitude:
                37.794016°, Longitude: –122.395016°</p>
              <p style="margin-bottom:0;">Regardless of the notation you choose to
                show in the interface, latitude and longitude are stored in Salesforce as
                decimals.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Length (for text fields)</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">For text fields, the maximum number of characters that a user can enter in a
              field (up to 255 characters).</td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Length (for number, currency, percent fields)</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">
              <p>For number, currency, and percent fields, the number of digits you can enter to
                the left of the decimal point, for example, 123.98 for an entry of 3.</p>
              <p>Changing the
                number of digits (either manually or through workflow rules) can result in
                truncated values in Salesforce Classic and no value changes in Lightning
                Experience. This example shows this behavior. In Lightning Experience, the record
                shows the percentage as 1,235,689.22% and in Salesforce Classic, the percentage
                appears as 689.22%.</p>
              <ul>
                <li>Create a percentage field with a length of 16 and 2 decimal places.</li>

                <li>Create a record that includes the field with set the value to 1235689.22.</li>

                <li>Change the percent field digits to a length of 3.</li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Mask Character</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">For encrypted text fields, determines the character to use for hidden
              characters. Available options are * and X.</td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Mask Type</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">
              <p>For text fields encrypted with Classic Encryption, determines which characters
                are hidden and the use of dashes in the field. Masked characters are hidden using
                the character selected in Mask Character. Available options are:</p><a name="custom_field_attributes__StandardMaskTypes"><!-- --></a>
              <dl id="custom_field_attributes__StandardMaskTypes">

                <dt style="font-weight:bold;padding-top:.25rem;">Mask All Characters</dt>

                <dd style="padding-left:1.5rem;padding-bottom:.5rem;">All characters in the field are hidden. </dd>


                <dt style="font-weight:bold;padding-top:.25rem;">Last Four Characters Clear</dt>

                <dd style="padding-left:1.5rem;padding-bottom:.5rem;">All characters are hidden but the last four are shown.</dd>


                <dt style="font-weight:bold;padding-top:.25rem;">Credit Card Number</dt>

                <dd style="padding-left:1.5rem;padding-bottom:.5rem;">The first 12 characters are hidden and the last four are shown. Salesforce
                  automatically inserts a dash after every fourth character.</dd>


                <dt style="font-weight:bold;padding-top:.25rem;">National Insurance Number</dt>

                <dd style="padding-left:1.5rem;padding-bottom:.5rem;">All characters are hidden. If the field contains nine characters, Salesforce
                  automatically inserts spaces after each pair of characters. Use this option
                  for UK NINO fields.</dd>


                <dt style="font-weight:bold;padding-top:.25rem;">Social Security Number</dt>

                <dd style="padding-left:1.5rem;padding-bottom:.5rem;">The first five characters are hidden and the last four are shown. Salesforce
                  automatically inserts a dash after the third and fifth characters.</dd>


                <dt style="font-weight:bold;padding-top:.25rem;">Social Insurance Number</dt>

                <dd style="padding-left:1.5rem;padding-bottom:.5rem;">All characters are hidden but the last three are shown. Salesforce
                  automatically inserts a dash after the third and sixth characters.</dd>

              </dl>
            </td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Master Object</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">The object on the master side of a master-detail relationship used to show the
              value of a <a href="https://help.salesforce.com/s/articleView?id=platform.fields_about_roll_up_summary_fields.htm&amp;release=264.0.0&amp;type=5" title="A roll-up summary field calculates values from related records, such as those in a related list. You can create a roll-up summary field to display a value in a master record based on the values of fields in a detail record. The detail record must be related to the master through a master-detail relationship. For example, you want to display the sum of invoice amounts for all related invoice custom object records in an account’s Invoices related list. You can display this total in a custom account field called Total Invoice Amount.">roll-up summary field</a>.</td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Related List Label</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">For relationship fields, the title for the related list that shows associated
              records on the parent record.</td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Related To</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">For relationship fields, the name of the associated object.</td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Required</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">
              <p>Makes the field required everywhere in Salesforce. Not available for external
                objects.</p>
              <p><span id="custom_field_attributes__campaignmember_required"><a name="custom_field_attributes__campaignmember_required"><!-- --></a>You must specify a Default Value for
                  required campaign member custom fields.</span></p>
              <p style="margin-bottom:0;">Don’t assign default values
                to fields that are both required and unique, because uniqueness errors can result.
                See <a href="https://help.salesforce.com/s/articleView?id=platform.fields_about_universally_required_fields.htm&amp;release=264.0.0&amp;type=5" title="Improve the quality of data that users enter in Salesforce by creating universally required fields.">Require Field Input to Ensure Data Quality</a>.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Roll-Up Type</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">
              <p>For <a href="https://help.salesforce.com/s/articleView?id=platform.fields_about_roll_up_summary_fields.htm&amp;release=264.0.0&amp;type=5" title="A roll-up summary field calculates values from related records, such as those in a related list. You can create a roll-up summary field to display a value in a master record based on the values of fields in a detail record. The detail record must be related to the master through a master-detail relationship. For example, you want to display the sum of invoice amounts for all related invoice custom object records in an account’s Invoices related list. You can display this total in a custom account field called Total Invoice Amount.">roll-up summary fields</a>, choose the type of calculation to make:</p>
              <ul>
                <li>COUNT: Totals the number of related records.</li>
                <li>SUM: Totals the values in the field that you select in the Field to Aggregate option. Only
                  number, currency, and percent fields are available.</li>
                <li>MIN: Displays the lowest value of the field that you select in the Field to Aggregate option for
                  all directly related records. Only number, currency, percent, date, and
                  date/time fields are available.</li>
                <li>MAX: Displays the highest value of the field that you select in the Field to Aggregate option
                  for all directly related records. Only number, currency, percent, date, and
                  date/time fields are available.</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Starting Number</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">
              <p>For auto-number fields, enter a Starting Number that’s less than 1 billion.
                Select <strong class="uicontrol">Generate Auto Number for existing records</strong> to
                automatically number all current records that begin with the starting number that
                you enter. If deselected, the next record that you enter is assigned the starting
                number and your older records are blank in this field. For leads, only unconverted
                leads are assigned a number.</p>
              <p><span id="custom_field_attributes__startingNumber_next_number"><a name="custom_field_attributes__startingNumber_next_number"><!-- --></a>When you create records, the Starting Number
                  value increments to store the number that will be assigned to the next
                  auto-number field created.</span> You can’t edit Starting Number after creating an
                auto-number field. To edit a Starting Number value, change your auto-number field
                to a text field and then back to an auto-number field. To restart Starting Number
                values for fields on objects from a managed package, uninstall and then reinstall
                the package.</p>
              <p>Be sure that you don’t create
                records with duplicate auto-number values.</p>
              <p>An auto-number field can contain up to 10 digits and up to 20 extra characters for
                your prefix or suffix.</p><a name="custom_field_attributes__startingNumber_metadata_api"><!-- --></a>
              <ul id="custom_field_attributes__startingNumber_metadata_api">
                <li>You can’t retrieve the starting number of an auto-number field through
                  Metadata API. To specify a Starting Number while deploying, add a
                  <code>startingNumber</code> tag for your field to your
                  <samp class="filepath">package.xml</samp> file. For example:
                  <code>&lt;startingNumber&gt;42&lt;/startingNumber&gt;</code>
                </li>

                <li>If you deploy without specifying a Starting Number value in your
                  <samp class="filepath">package.xml</samp> file, the default starting number for
                  standard fields is <code>0</code>. The default starting number for custom
                  fields is <code>1</code>.
                </li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Sharing Setting</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 "><span id="custom_field_attributes__SharingSettingMDDef"><a name="custom_field_attributes__SharingSettingMDDef"><!-- --></a>For master-detail relationship fields, the Sharing
                Setting attribute determines the sharing access that users must have to a master
                record to create, edit, or delete its associated detail records.</span></td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Sorting Disabled</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">For custom fields on external objects, determines whether the field is
              sortable.</td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Summarized Object</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">The object on the detail side of a master-detail relationship used to provide the
              values calculated in a <a href="https://help.salesforce.com/s/articleView?id=platform.fields_about_roll_up_summary_fields.htm&amp;release=264.0.0&amp;type=5" title="A roll-up summary field calculates values from related records, such as those in a related list. You can create a roll-up summary field to display a value in a master record based on the values of fields in a detail record. The detail record must be related to the master through a master-detail relationship. For example, you want to display the sum of invoice amounts for all related invoice custom object records in an account’s Invoices related list. You can display this total in a custom account field called Total Invoice Amount.">roll-up summary field</a>.</td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Unique</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">
              <p>If checked, prevents duplicate field values.</p>
              <p>For text fields, you can control
                whether values that are identical except for their case are considered unique.
                Select <strong class="uicontrol">Treat "ABC" and "abc" as duplicate values</strong> to enforce
                case-insensitive uniqueness, or select <strong class="uicontrol">Treat "ABC" and "abc" as
                  different values</strong> to enforce case-sensitive uniqueness.</p>
              <p>Some
                characters have both single-byte and double-byte versions. For example, all the
                following characters have single-byte and double-byte versions:
                “!@#$%^&amp;*(){}[]\|:";',.&lt;&gt;?/~`”. </p>
              <p>For the purpose of unique field
                value comparison, the single-byte and double-byte versions of these characters are
                considered identical.</p>
              <p>Superscript characters aren’t treated as unique
                characters. Text such as ABC² and ABC2 are considered identical.</p>
              <p style="margin-bottom:0;">Custom
                fields marked as Unique count against an object's limit of 25 External ID fields.
                Custom indexing that occurs automatically in the background by Salesforce doesn’t
                count against External ID limits.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e41 ">Values</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d121321e44 ">For picklist fields, a list of available values (up to 255 characters for each
              value). For picklists, optionally choose to alphabetize the picklist entries. You
              can also set the first value as the default selection. <span id="custom_field_attributes__picklist_value_attributes"><a name="custom_field_attributes__picklist_value_attributes"><!-- --></a>If you select both options, Salesforce alphabetizes
                the entries and then sets the first alphabetized value as the default.</span> For
              multi-select picklists, enter a list of values, select the sorting options that
              apply, and then enter how many values you want shown at a time on edit pages. The
              number of values determines the box height.</td>

          </tr>
        </tbody>
      </table>

## Auto-Number Formatting Examples

Use these examples when setting the display format for auto-number fields.

 
| Format | Displayed Values |
| --- | --- |
| {0} | 3 66 103 |
| {000} | 003 066 103 |
| Sample- {00000} | Sample- 00003 Sample- 00666 Sample- 10023 |
| Value- {00} {MM} {DD} {YY} | Value- 03 12 02 04 Value- 76 03 03 04 Value- 123 11 09 04 |
| PO #{0} {MM}-{DD}-{YY} | PO #12233 12-20-04 PO #25 06-07-04 PO #3 07-07-04 |

#### See Also

- [Create a Custom Field](https://help.salesforce.com/s/articleView?id=platform.adding_fields.htm&release=264.0.0&type=5 "Capture your unique business data by storing it in custom fields. When you create a custom field, you configure where you want it to appear and optionally control security at the field level.")
- [Create a Many-to-Many Object Relationship](https://help.salesforce.com/s/articleView?id=platform.relationships_manytomany.htm&release=264.0.0&type=5 "You can use master-detail relationships to model many-to-many relationships between any two objects. A many-to-many relationship allows each record of one object to be linked to multiple records from another object and vice versa. For example, you create a custom object called Bug that relates to the standard case object such that a bug could be related to multiple cases and a case could also be related to multiple bugs. When modeling a many-to-many relationship, you use a junction object to connect the two objects you want to relate to each other.")
- [Object Reference for Salesforce and Lightning Platform](https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/)