Custom fields in Dynamics 365

The following section guides you through creating custom fields in Dynamics 365.

Create the custom fields under a table

To create custom fields under a table:

  1. You can see a default field is created by Microsoft Dynamics called new_name.

  2. For the FastStats URN, click on the + to add a new column.

  3. Use the data type panel to select the type of field.

  4. After choosing whole number you can see these values change.

  5. Change the minimum value to 0 and then press Save to add the column.

    Note: You cannot change the data type once created with the exception of changing a text fields to autonumber fields.

  6. To find the Logical name click on the 'down arrow' and the Edit column.

  7. Then click on Advanced options and then you will see the Logical name which is what is used in FastStats.

    Note: This is case sensitive.

  8. New column FS URN definition.

    Item Description
    Display name FS URN
    Description FastStats Person URN
    Type Whole Number (Integer)
    Minimum value 0 (zero)
    Schema name new_FSURN
    Logical name new_fsurn

    Note: Use the default values for the other fields.

  9. Click + Add field to repeat the process for the following fields:

    Tip: The following data items are for example only, use data types, naming convention and field length to match your data model.

Additional fields

Item Description
Display name FS Title
Description FastStats prospects title
Type Single line of text
Maximum character count 100
Schema name new_FSTitle
Logical name new_fstitle
Item Description
Display name FS Initial
Description FastStats prospects initial
Type Single line of text
Maximum character count 100
Schema name new_FSInitial
Logical name new_fsinitial
Item Description
Display name FS Surname
Description FastStats prospects surname
Type Single line of text
Maximum character count 100
Schema name new_FSSurname
Logical name new_fssurname
Item Description
Display name FS DOB
Description FastStats prospects dob
Type Date only
Schema name new_FSDOB
Logical name new_fsdob
Item Description
Display name FS Email
Description FastStats prospects email address
Type Single line of text
Maximum character count 100
Schema name new_FSEmail
Logical name new_fsemail

The FastStats Prospects entity is visible in the Sales menu.

Note: Use the Create Personal View or create a Dashboard to view the uploaded data, there are many ways to customize Views and Dashboards in Dynamics 365.