Blog

Do you know what you can do with … Blue Mountain RAM’s Field Properties?

Fields can be configured to have one of 22 Control Types (behaviors):

Available Control Types:

  • Asset Control – The field is given a pick list populated with asset records. The type of asset is designated in the field’s Data Source. This is a mechanism for cross-referencing records and if desired, pulling in data from an asset selected in this field. One Example: A User Asset is configured to be a Service Contract record and then service contract records are created. Equipment records have a field that is assigned the control type of Asset Control, labeled “Service Contract”, and assigned the data source of Service Contract records. This results in equipment assets having a field in which their service contract is listed as well as opened for reading.
  • Check Box – A checkbox is displayed for users to check or not check.
  • Craft Members – The field is given a pick list populated with Craft Code members, as designated in the field’s Data Source. The use of this control type depends upon an organization creating Craft Codes under the site’s Codes And Classes node in System Configuration. This is a mechanism for providing a pick list of people with a defined skill. For example, a pick list of electricians or calibration technicians.
  • Currency – The field accepts numeric characters. The currency formatting shown in the field comes from what an organization specifies in: Sites > Your Site > Settings > Site Options, “Culture” section.
  • Data Tree – The field is one of at least two fields taking part in a data tree. Please see Administrator Manual, Chapter 15 – Filter Fields for information on Data Tree Filter Fields.
  • Date – The field will display a calendar tool and only accept dates. The date formatting shown in the field comes from what an organization specifies in: Sites > Your Site > Settings > Site Options, “Culture” section.
  • Document – The field will display a pick list of the Document Titles contained within the Document Category designated for the field in its Data Source. A record launcher button is provided next to the field to open the selected document. Assigning a Document Category is optional. If a Document Category is not assigned, the pick list contains all Document Titles. Please see, Administrator Manual, Chapter 23 – Document Administration, for more information.
  • Email – The field will respond to email addresses entered by users by displaying entered addresses as underlined text that when double-clicked, launches the user’s email client with the clicked address in the email’s “To:” field.
  • Group – The field will display a pick list of the groups in a Group List. Group Lists are created in Sites > Your Site > Group Lists. The Group List that populates a Group field is designated in its Data Source. Please see Administrator Manual, Chapter 15 – Filter Fields for information on Group List Filter Fields.
  • Integer – The field will only accept integers (no decimals). A range may be specified to limit the value that can be entered. Specify a range by entering values in the Lower Limit and Upper Limit properties of the field property window.
  • MUC (Measurement Uncertainty Calculator) – The field will displays a launch button next to a read-only field. The button launches BMRAM’s MUC (Measurement Uncertainty Calculator), and the read-only field displays the measurement uncertainty value that is calculated by the use of the calculator. Please see Administrator Manual, Chapter 7 – Codes And Classes for information about creating options offered in the MUC. Please see Chapter 11 – MUC for information about deploying the MUC. .Please see the BMRAM User Manual, Chapter 10 – Using The Measurement Uncertainty Calculator for information about using the MUC.
  • Numeric – The field will only accept numeric values and the character “e” to allow data entry using scientific notation (an entry of 2.0025e2 displays as 200.25)
  • Personnel – The field will display a pick list of names. The names will come from the Group (Sites > Your Site > Security > Groups) assigned to the field in its Data Source. A record launcher button is provided next to the field to open the selected personnel record. This is a mechanism for providing a pick list of personnel sharing an attribute, such as: Supervisors, Technicians, or Electricians. Assigning a Group is optional. When no Group is assigned, the pick list contains all Personnel.
  • Picklist – The field will display the contents of one of the pick lists created in Sites > Your Site > Pick Lists. The pick list is assigned to the field in its Data Source. For example, a “Manufacturer” field may utilize a “Manufacturers” pick list. Please see, Administrator Manual, Chapter 8 – Pick Lists And Their Maintenance, for more information on the Pick List feature of BMRAM.
  • Report – The field will display a pick list of the Report Titles contained within the Report Category assigned to the field in its Data Source. A record launcher button is provided next to the field to open the selected report. Assigning a Report Category is optional. If a Report Category is not assigned, the pick list contains all Report Titles related to the record type holding the field. Be sure to read the following NOTE. Please see, Administrator Manual, Chapter 22 – Report Administration, for more information on the Report feature of BMRAM.

NOTE: It is possible and to be expected that not all Report Titles within a Report Category will show up in a field’s Report Titles by Report Category Pick List. This is because the record type of the form holding this field acts as a filter to the Report Titles included. Asset record types draw Asset data reports; Work record types draw Work data reports, and so on. Therefore, it is no problem to store asset, work, event, etc. reports in the same Report Category, as this filtering behavior ensures that reports appropriate for a record type are offered on the record type.

  • Request Control – The field assigned the control type of Request Control  is given a pick list populated with the records of All Requests, Request, or User Defined Request 01 – 06 designated for that field in its Data Source. This is a mechanism for cross-referencing records and if desired, pulling in data from the fields of the request record selected in this field and placing that data in the fields of the current record. This transporting of data is handled through the functionality of BMRAM’s Lookup Field Sets feature. One Example: A User Defined Request is configured as a New Asset Request record which holds data for a new asset awaiting approval. Upon approval, the user creating the new asset record can open a pick list field (the configured Request Control field) on the asset and select the Asset Request Record that generated it. This documents the connection between the two records. If the Lookup Field Sets feature is also utilized, the selection of the Asset Request Record automatically populates fields on the new asset with data from the listed Asset Request. This saves data entry time and avoids human error. Please see Administrator Manual, Chapter 16 – Lookup Field Sets and Lookup Fields for instructions concerning working with Lookup Fields and Field Sets.
  • Separator – The field will display as a graphic object: a line underneath the label. The label can be sized and positioned, and the line will always display underneath it. This is a mechanism for visually separating a portion of a tab.
  • Sequence – The field is assigned a Sequence from Sites > Your Site > Numbering, in its Data Source. A sequence contains optional prefix and suffix text surrounding a Counter. The Counter automatically increments for each new record. This is a mechanism for providing an automatic sequential number for record IDs, work order numbering, etc. Please see, Administrator Manual, Chapter 9 – Numbering, for more information on Sequences and Counters.
  • Text Box – The field allows the entry of characters.
  • URL – The field will respond to URL addresses entered by users by displaying the addresses as underlined text that when double-clicked, launches a new window of the user’s browser and navigates to the listed URL (Internet or intranet).
  • Vendor –The field will display a pick list populated with vendor names, as per the records created of the Vendor Record Type. A record launcher button is provided next to the field to open the selected vendor’s Vendor Record.
  • Work Control – The field assigned the control type of Work Control  is given a pick list populated with the records of the All Work, Calibration, General, Maintenance, Validation, or Test Result record type designated for that field in its Data Source. This is a mechanism for cross-referencing records and if desired, pulling in field data from the work record selected in this field. One example: A User Asset Record is configured as an Out-Of-Tolerance Record Type. One of its fields is assigned the control type of Work Control, labeled “Problem Work”, and assigned the data source of All Work. The result is that every Out-Of-Tolerance report/record has a Problem Work pick list field listing all work records and the selected record can be opened and read.

NOTE: Some of the above Control Types have been added to BMRAM over time. If you do not see a Control Type in your BMRAM that you would like to utilize, please consider adding this to a list of reasons for upgrading your BMRAM. Your Enterprise Sales Manager will be happy to discuss upgrade question with you. Do not hesitate to call; we love to hear from our customers!

For further information, consult your Blue Mountain RAM manuals. If necessary, contact us for downloads of PDFs of the manuals. Also, please call and discuss training opportunities with your Enterprise Sales Manager (ESM) at 800-982-2388.