||Label for the user defined field up to 50 characters in length. The default is “User Defined.”
||A value entered in this setup field will automatically be entered as the actual field data by default whenever a new account is added (contact or loan user-defined fields respectively).
||Set field to allow for up to 50 alphanumeric characters.
|Unlimited text size||Select to allow an unlimited length of text into the field.|
|Rich Text Format||Select to allow for rich text (formatted) to be used.|
||Set field for only numeric values.
The maximum field length is 25 digits, so you could define a maximum number of 9,999,999,999,999,999,999,999,999 (this is one short of 10 septillion). NLS will not allow non-numeric characters to be typed into a numeric field.
|Decimal Places||Number of decimal places to use. Click the up and down arrows to select up to five decimal places.|
|Max Value||The maximum value that the field can accept.|
|Min Value||The minimum value that the field can accept.|
||A date field will be displayed in mm/dd/yyyy format, and an empty date field will show __/__/____ to indicate that this field is a date field. The icon next to the date field will bring up a calendar / date-picker.
|Drop Down Field (Allow user input)
||Field becomes a drop down list that allows for selection from a list or for manual entry by typing directly into the field. Click Add to add items to the list and use to re-order selected items in the list. Click Sort to sort the list of items in alphabetical order.
|Drop Down Field (Select only)
||Field becomes a drop down list that allows only for selecting from a list and does not allow for typing directly into the field. Click Add to add items to the list and use to re-order selected items in the list. Click Sort to sort the list of items in alphabetical order.
||A user-defined field of this type will appear as a checkbox. A checkbox stores boolean data (e.g. yes/no, on/of, true/false).
||A button user-defined field is useful for activating Visual Basic Scripts. For fields of this type, a trigger of “On Button Click,” is added to the scripting interface. If you want the button’s label to appear on the button instead of next to it, leave the field label blank, and enter the label in the Default Value field.
Setting a user-defined field type to documents changes the field into a button. Clicking this button will bring up a screen where documents may be attached and documents that are already attached may be viewed. It is similar to the documents tab on a comment.
When the field is not open, a red number of the field will indicate how many documents are stored in this user-defined field. This is designed to save time, as a user will not have to open a document storage user-defined field to determine if any documents are present.5.12-
When the field is not open, a red <doc> will indicate that this is a document UDF.5.13+
Displays a table with up to 15 columns and an unlimited number of rows containing any user defined field types or information from connected contacts, loans, work packets, or tasks.
Fields 51–55 on the Contact Type and Loan Portfolio and fields 101–110 on the Task Template setup screens are available as Grid fields. These grids may be enabled by toggling off the Hide attribute.
In the User-Defined Field Setup window, click to open the Grid Setup window.
|Type||If the grid is to take data from the database, this field indicates if that data is to come from database tables related to Contact, Loan Accounts, Tasks, Work Packets, or if it may take data from more than one of those sources at the same time (generic).|
|Number of Rows||Defines the number of horizontal rows on the grid.|
|Number of Columns||Defines the number of vertical columns on the grid.|
|Column#||All attributes below this point are attributes of a specific column. This field defines which column the attributes displayed below pertains to.|
|Table Link||Allows the grid to automatically populate with values from the NLS database.|
|Column Type||Defines the type of field of the particular column. Each column acts as an additional user-defined field as defined in the section above.|
|Decimal Places||If the column type is Numeric you may specify the decimal precision of the number.|
|Data||If the column type is Drop Down or Drop List, the list items can be specified here.|
NLS 5.6 and later
to use an SQL statement to populate the list.
Maximum of two columns may be queried using the SQL
must be set to None
To populate a single column with data:
select loan_template_name from loan_template
To populate two columns with data, use
+ ',' +
between the columns to include a comma to delimit the data (replace
select shortname + ',' + lastname1 from cif
|Column Width||Defines the width of the column in pixels.|
|Column Header||Defines a title to be placed at the top of the column.|
|Column Alignment||Defines the justification of the column.|
|Read Only||If a column pulls data from the database, you may wish to make it a read only column.|
|Comma||If the column type is numeric, you may specify if it should or should not have commas.|
|Sub Totals (Last row)||If the column type is numeric, selecting this option makes the last row of the grid automatically contain the sum of all rows in the column.|
|Do not save to database||Some grids may be populated with data through scripting. In this case, where the data is refreshed each time that the Grid comes up, it may not be necessary to save the contents of the grid to the database tables.|
|Do not activate dirty flag (Save button)||If this checkbox is selected, then changes in the grid do not lock the data record in the database. In this case those changes will ultimately not be saved to the database.|
|Stretch last column||The right most column of the grid is stretched to fill any remaining space in the defined size of the grid, after the column width of each column has been accounted for.|
|SQL SELECT Statement||If the Table Link field specifies an SQL statement to populate the grid, then the SQL statement is typed here.|
||Check to disable a user-defined field. The corresponding user-defined field on the Contact will display no data, and will not accept any input.
||When selected, NLS will not allow a Contact to be saved unless a valid value is entered into that user-defined field.
||When selected, the entire field will be removed from the Contact display. This can be used to create spaces between groups of fields allowing for greater latitude in customizing the look of the contact screen.
||When selected, the field will be grayed out and cannot be edited, but any information in that field is still displayed. Information can get into the field by being placed there before the field definition is set to read only, by having a default value set in the field definition, or by having the field value set by a VB script code.
||When selected, lower case letters may be used for the User Defined text.