Custom Fields – Loan

General

LoanPro lets you create custom fields in order to keep track of things that the system doesn’t track by default.  You can add custom fields in four specific areas of a loan: Loan Setup, Loan Settings, Collateral, and Insurance.  You can create custom fields in other areas including investor, customer, payment, and source company, but this article only covers the creation of loan custom fields. This article also doesn’t cover creating auto-calculate custom fields.

How To Create a New Field

To create a loan custom field, navigate to Settings > Loan > Custom Fields > Custom inside your company account.

There are buttons across the top of this page that you can use to select the type of custom field you want to create.  The custom field you create will appear in the section you select.  Once you have chosen the custom field section, click ADD to add a new field.

The following options are available for new custom fields:

  • Active – Choose whether the field is displayed in the loan file.
  • Field Name – This is the name of the field.  This name should distinguish this custom field from other custom fields you create.
  • Field type – This is the type of data that should be entered into the field.  This will control how the field appears and how the data in the field is formatted.  The available options are:
    • Associated Company - A company from your company directory that's associated with the loan.
    • Checkbox – This is a custom checkbox field.
    • Currency – This will be a number formatted as currency (e.g. 9,999.99).
    • Date – This will be a date field and will include the date picker for ease of entry. When displayed, the date will not be converted to the local timezone.
    • Date Time – This is a field that can hold both a date and time. It is actually displayed as two fields. The date field includes a date picker and the time field is a dropdown of times in five-minute increments.
    • Number – This field will not accept any letters, only numbers and some special characters.
    • Percentage – This field works like a number field, but will appear with a percentage tag adjacent to the field.
    • Phone – This field will only accept numbers and they will be formatted as (999) 999-9999.
    • Select – This will not be a field, but a selection box.  Entering option values will be covered a little later in this article.
    • Text – This field will allow all character types. This type of field allows for a maximum number of 255 characters.
    • Time – This is a time field and is a drop-down of times in five-minute increments.
    • Web URL – Your entry into this field must be a valid URL format (e.g. http://yourpage.com).  When the value for Web URL fields is displayed, it will be a clickable hyperlink for easy navigation to the URL.
  • Auto calculate – This option lets you choose to have the field be used to calculate one of the loan numbers.
  • Include in credit report – This selection lets you designate a field to be included in the exported credit reporting data.
  • Include as a Custom Option in the Loan Manager – This selection gives you the option to have a column in the loan manager that will display the value for this field for each loan returned in your loan search results.
  • Include In Loan Status Archive – Choosing “Yes” for this option will save the value of this field daily, in the Loan Status Archive.  This report will let you see the history of values for the field so you can track changes to the value over time.
  • Required – This option lets you choose to make it a requirement to enter a value for the field before the data for the designated loan section can be saved.
  • Searchable – This option is only available for phone numbers and text and lets you choose to be able to search the value entered into this field in order to find loans in the loan manager.
  • Max Length – This option is only available for text and Web URL fields and lets you enter a numeric value for the maximum number of characters that can be entered into the field.
  • Default Value – This option lets you enter a default value for the field.
  • Configure Select Options – This option is only available for select fields and lets you enter the options that will be available in the selection.

Once you have input the necessary data for the field you are creating, click SAVE to save the field.

How To Enter Selection Options

LoanPro provides a few templates for selections you might want, which you can access by clicking Preset Templates. These include

  • Yes/No
  • TRUE/FALSE
  • Rent/Own/Live with relatives
  • US States

You can also enter any options you want. Each line you enter represents a single option. Enter the options in the following format:

id_1, value_1

id_2, value_2

So, if you want to enter a simple Yes/No selection, you would enter the options like this:

1, YES

2, NO

To enter options for your selection, click on the box.

Then enter the options into the box.

Importing a Custom Field via CSV Import Tool

  • Select Type - Include only the selection option ID (i.e 1, 2, 3, 4) not the full name of the selection option
  • Date - All date values should be entered with YYYY-MM-DD
  • Currency - Without the $ sign, such as 50.00, not $50.00
  • Percentage - As a whole number such as 50 will equal 50%

For information on how to create a CSV Import see the Import article.


How did we do?


Powered by HelpDocs (opens in a new tab)