Custom Field

...

3. Select the 'Type' of custom field from the drop down.  The 'Type' defines the format of the field. Refer to the 'MORE' section at the end of this chapter for more details about the various Type formats.

4. Select the record that this custom field will apply to from the 'Applies To Record' drop down

...

• • Display Name: field name you want displayed on the interface
  • Order: order number you want it to appear within the group.  For example, if you want the custom field to be displayed at the beginning of the 1099 section in vendors, leave the order default to '0enter '1'. 
  • Property Name: name for report properties
  • Group: section of the interface you want the custom field displayed

Image RemovedImage Added

 7. Click on to save the custom field to the system, click on to not save the custom field and return to the Custom Field Grid.

After, you can view the newly created custom field on the user interface.  For example, if I created a boolean field to indicate the W9 is on file, I would see the following in the Vendor interface as the first field on the 1099 section.

Image Added

Search Custom Field

The  custom field grid allows the user to search for existing custom fields on the system by clicking in the filter row in the grid columns and entering in the desired information. Click on any row of the search results to see a summary view of the record. Click on beside a custom fieldt to see the full details.  The Advanced Search can be utilized by clicking on the in the upper right side of the grid.

Note: To filter the grid result by the Applies To property you have to surround your search criteria with wildcards (%).  So to limit the grid to all custom fields that apply to vendors, you enter %vendor% in the filter box.  This does a 'starts with' query, so you can enter all or part of the word vendor, but you need to surround it with %. 

Click on  in the grid beside the custom field to edit the custom field. Only fields that are allowed to be edited will be displayed.

...

A Custom Field may be a code, date, money, text, web address, email address, user or a Boolean (true/false) field, as defined by the "type" selected when the Custom Field is created.  Each Custom Field applies to a single type of data, for example, Vendor.   A Custom Field which has an "applies to" of Vendor will only appear in the Vendor interface and when generating Vendor reports.

Some of the types have types have unique restrictions or capabilities:

• Boolean: displays a checkbox for the custom field allowing you to 'click' on it to select it.  It will typically be represented as true or false, or as a checkbox which may be checked (true) or unchecked (false) 
• Code: The user is presented with a dropdown list allowing them to select from the list of valid codes.  The list of valid codes are entered during the code's custom field creation.
• CreateDateTime: read-only; automatically updated to the system date when creating new record. 
• CreatedUser: read-only; automatically updated with the username of the user who created the new record
• Date: must be in proper date format (mm/dd/yyyy)
• DateTime: read-only; automatically updated to the system date and time when creating the new record
• Email: must be in a valid email address format
• LastModifiedDateTime: read-only; automatically updated to the system date and time when the record was last modified
• LastModified User; read-only; automatically updated with the username of the user who last modified the record
• Money; automatically formats in number format.  Will not accept dollar signs or commas.
• Number: enter a mininum and maximum number range.  Figure entered in this field must be within the range defined when the custom field was created.
• Text: custom text field.  Limit of 1000 characters,
• User: allows selecting a valid username from a dropdown list
• WebAddress: must be in a valid web address format  http:// or https:// is required at the beginningCustom Field Video