Datasheets

About Types of Datasheets

APM offers the following types of datasheets:

  • Master/Detail datasheet: A form that lets you display a record and all the records that are linked to it through a given relationship definition.
  • Custom datasheet: Datasheets that can be customized to display fields in a more advanced form. APM provides two types of layouts for custom datasheets, the tabular layout and the custom layout.
    • Tabular layout organizes the datasheet content in a standard arrangement with row labels and up to four columns of data per row, and cells of equal size.
    • Custom layout allows for less uniform datasheet configurations with more options for variable cell sizing and grouping items.

About Multiple Datasheets

APM lets you define more than one datasheet for a given family. For example, equipment records may contain many pieces of data including maintenance, engineering, reliability, cost, inspection, design, drawing, project, etc. A datasheet containing all these data fields would be very large and difficult to navigate.

To make data entry easier, an administrative user can create subsets of the data based on specific purposes (e.g., engineering data in one datasheet, inspection data in another, cost data in a third, and so forth). When you access a record, you can select the datasheet that represents your needs.

When more than one datasheet exists for a family, you will be able to select the appropriate datasheet when you create and view a record. The name of the currently selected datasheet appears at the top of any record you are viewing.

About Field Rules

The field properties and rules that you define for family fields determine how fields will behave when users view them in datasheets.

If you have defined a rule for a field that will affect the way it appears or behaves in a datasheet, you may want to test the field rule. To do so, follow this workflow:

  1. Configure the family field properties as needed.
  2. Add the field to the datasheet.
  3. Compile the family.
  4. Open a new datasheet for the family.

If you need to make additional changes to a field, repeat this workflow, but omit step 2. After you add the field to the datasheet, any changes you make to the field rule will be applied automatically to the datasheet.

About Master/Detail Datasheets

A master/detail datasheet is a custom form that lets you display a record and all the records that are linked to it through a given relationship definition. Master/detail datasheets can be configured for any entity family using any relationship definition that relates it to another entity family.

For example, in the baseline APM database, the Calibration Template family is related to the Calibration Template Detail family through the Has Template Details relationship. The APM product includes a master/detail datasheet that allows you to open a Calibration Template record while simultaneously viewing, creating, and modifying linked Calibration Template Detail records.

Privileges for Master/Detail Datasheets

Like standard datasheets, access to records displayed using master/detail datasheets is controlled by family-level security privileges. But because a master/detail datasheet displays records belonging to two entity families that are related to one another through a relationship family, the security considerations for master-detail datasheets are somewhat more complex. Specifically:

  • To access records in a master/detail datasheet, at least View privileges are required on the master family. Even if users have privileges on the detail family, without privileges on the master family, they will not be able to access records that are displayed in master/detail datasheets.
  • To view existing detail records in a master/detail datasheet, users must have View privileges on the detail family and the relationship family that relates the master family to the detail family.
  • To edit existing detail records in a master/detail datasheet, users must have View and Update privileges on the detail family.
  • To create new detail records in a master/detail datasheet, users must have View, Insert, and Update privileges on the detail family and the relationship family that relates the master family to the detail family.
  • To link and unlink detail records in a master/detail datasheet, users must have View, Insert, and Delete privileges on the relationship family that relates the master family to the detail family.

In addition to family-level privileges, the ability to manage records in master/detail datasheets is controlled by datasheet-level privileges. You can define datasheet-level privileges in the Datasheet Builder page, which appears when you create a master/detail datasheet.

Five datasheet-level permissions options are available and control users' ability to manage detail records in a master/detail datasheet:

  • Allow for Deletion: Determines whether users will be allowed to delete detail records.
    • When this check box is selected, users with Delete privileges on the detail family and the relationship family that relates the detail family to the master family, will be allowed to delete detail records.
    • When this check box is cleared, users with Delete privileges on the detail family will not be allowed to delete detail records.
    • Regardless of whether this check box is selected or cleared, users without Delete privileges on the detail family will not be allowed to delete detail records.
  • Allow for Insertion: Determines whether users will be allowed to create new detail records.
    • When this check box is selected, users with Insert privileges on the detail family and the relationship family that relates the detail family to the master family, will be allowed to create detail records.
    • When this check box is cleared, users with Insert privileges on the detail family will not be allowed to create detail records.
    • Regardless of whether this check box is selected or cleared, users without Insert privileges on the detail family will not be allowed to create detail records.
  • Allow for Editing: Determines whether users will be allowed to modify detail records.
    • When this check box is selected, users with Update privileges on the detail family will be allowed to modify detail records.
    • When this check box is cleared, users with Update privileges on the detail family will not be allowed to modify detail records.
    • Regardless of whether this check box is selected or cleared, users without Update privileges on the detail family will not be allowed to modify detail records.
  • Allow for Linking: Determines whether users will be allowed to link existing detail records to the master record.
    • When this check box is selected, users will be allowed to link existing detail records to the master record if they have Insert privileges on the relationship family that relates the detail family to the master family.
    • When this check box is cleared, users will not be allowed to link detail records to the master record even if they have Insert privileges on the relationship family that relates the detail family to the master family.
    • Regardless of whether this check box is selected or cleared, users without Insert privileges on the relationship family that relates the detail family to the master family will not be allowed to link detail records to the master record.
  • Allow for Unlinking: Determines whether users will be allowed to unlink existing detail records from the master record.
    • When this check box is selected, users will be allowed to unlink detail records from the master record if they have Delete privileges on the relationship family that relates the detail family to the master family.
    • When this check box is cleared, users will not be allowed to unlink detail records from the master record even if they have Delete privileges on the relationship family that relates the detail family to the master family.
    • Regardless of whether this check box is selected or cleared, users without Delete privileges on the relationship family that relates the detail family to the master family will not be allowed to unlink detail records from the master record.

Custom-Layout Datasheets

A custom-layout datasheet is a form-based datasheet whose layout can be configured via APM. Unlike standard datasheets, custom-layout datasheets provide more flexibility in the layout of fields. For example, they can contain grouped fields, fields that appear side-by-side, and so on.

The following image shows a custom-layout datasheet that is configured in the baseline ASI module for the Maintenance Item family.

About the Text Editor

The text editor is available in various text fields throughout APM. You can use the text editor to enter text into a desired field and then use the Spell Check feature to locate and correct misspelled words within the text. The text editor is used to enter large amounts of text, such as descriptions, into text fields.

The text editor is available only for some fields. The button appears next to the fields for which the text editor is available. Select to access the text editor for a text field. The name of the field from which the text editor is accessed appears in the title bar of the text editor window.

Note: When using the bulk data form, the button appears when you select a text field.

If rich text formatting is enabled for a field, a toolbar appears in the field and in the text editor. You can use the tools to apply a range of formatting settings to the text, including the font size, color, bold, underline, and so on. You can also insert a hyperlink in the text.

Details

To use the text editor:
  1. In a datasheet, select in the field whose text you want to modify.

    The Text Editor window appears.

  2. Enter text in the text box.
  3. Select Done.

    The text editor closes, and the text that you entered appears in the field from which you accessed the text editor.

About the Calendar Feature

The Calendar feature appears throughout APM and provides the ability to select a date and time. In most cases, the Calendar feature appears in date fields on datasheets. The Calendar feature is not available, however, in all fields that store date and time values. There are three possible configurations for the Calendar feature:
  • Date and time
  • Date only
  • Time only

Date and Time

When you select a date field that has the date and time feature enabled, the button will appear. When you select the button, the calendar will appear, as shown in the following image:

When you select , the time picker will appear. Depending on your settings, the time picker may or may not have seconds enabled, as shown in the following image:

When you select , the calendar will appear again.

Date Only

When you select a date field that has only the date picker enabled, the button will appear. When you select the button, the calendar will appear, as shown in the following image:

Time Only

When you select a date field that has only the time picker enabled, the button will appear. When you select the button, the time picker will appear. Depending on your settings, the time picker may or may not have seconds enabled, as shown in the following image:

Access the Datasheet Builder

Procedure

  1. Access the Family Management page.
  2. In the left pane, in the Entity section, select the entity whose datasheet you want to configure.
    The workspace for the selected entity appears.
  3. In the workspace, select the Datasheets tabs.
  4. Select Manage Datasheets.
    The Datasheet Builder page appears.

Create a Datasheet

About This Task

When creating a datasheet in Configuration Manager, you can create the following types of datasheets:
  • Master/Detail Datasheet
  • Custom Datasheet

Procedure

  • Create a Master/Detail Datasheet:
    1. Access the Datasheet Builder for the master family for which you want to create a datasheet.
    2. Select , and then select Master/Detail datasheet.
      The Create New Datasheet window appears.
    3. Enter a caption, default ID, and a description for the new datasheet, and then select OK.
      Note: If you want your datasheet to be the default datasheet for this family, select the Default check box.
      The Datasheet Builder page appears.
    4. Select the master family datasheet, detail family, detail family datasheet, and the relationship family to be shown in the datasheet, using the respective drop-down list boxes
    5. Select the check boxes for any datasheet-level permissions that you want to make available for the detail family records displayed in the datasheet.
    6. Select Save.
      The Master/Detail datasheet is created.
  • Create a Custom Datasheet:
    1. Access the Datasheet Builder for the family for which you want to create a datasheet.
    2. Select , and then select Custom datasheet.
      The Create New Datasheet window appears.
    3. Enter a caption, default ID, and description for the new datasheet, and then select OK.
      Note: If you want your datasheet to be the default datasheet for this family, then select the Default check box.
    4. In the datasheet, select .

      The Datasheet Builder workspace appears.

    5. Select Custom Layout or Tabular Layout depending on your preference.
    6. As needed, enter values in the available fields.
    7. Select Save.
      The Custom datasheet is created.

What To Do Next

Modify a Datasheet

Procedure

  1. Access the Datasheet Builder page for the family containing the datasheet that you want to modify.
  2. Next to the Datasheet Caption label, select , and then select the datasheet that you want to modify.
    The selected datasheet appears.
  3. Select .
    The Datasheet Information window appears.
  4. As needed, modify the fields in the Datasheet Information window, and then select Update.
    The datasheet is modified.
    Note: The modified details of the datasheet will be available for you in Family Management, whereas to access the datasheet from other modules, you must log out and log in to APM. For other users who are being logged in to APM, the modified details of the datasheet will be available only when they log in to the application again.

Designate a Datasheet as the Default Datasheet

The default datasheet is the datasheet that is used by default when a user opens a record belonging to a given family in the Record Manager. A user can select a datasheet other than the default datasheet after the record has been opened. In addition, via the URL, you can specify that a datasheet other than the default datasheet be used. Because the default datasheet will be used unless a different datasheet is selected, the datasheet that you designate as the default datasheet the one that will be most meaningful to most users.

You can designate a datasheet as the default datasheet when you create the datasheet. After you set a datasheet as the default, you can change which datasheet for a given family, is designated as the default.

Before You Begin

  • If another datasheet currently has the default designation, you must clear the Default check box for that datasheet before you can designate another datasheet as default.

Procedure

Modify the datasheet that you want to designate as the default datasheet, and ensure that the Default check box is selected before you select Update.

Results

The datasheet is designated as the default datasheet.

Hide a Datasheet

This topic describes how to hide a datasheet belonging to a family that you do not want to appear for the corresponding records.

Procedure

  1. Access the Datasheet Builder page for the family containing the datasheet that you want to hide.
  2. Next to the Datasheet Caption label, select , and then select the datasheet that you want to hide.
    The selected datasheet appears.
  3. Select .
    The Datasheet Information window appears.
  4. Select the Hide check box.
    Note: You cannot hide a datasheet that is marked as default. If you want to hide a default datasheet, in the Datasheet Information window, clear the Default check box, and then select the Hide check box.
  5. Select Update.
    The datasheet is saved and is not displayed for any record corresponding to the family.

Delete a Datasheet

Procedure

  1. Access the Datasheet Builder page for the family containing the datasheet that you want to delete.
  2. Next to the Datasheet Caption label, select , and then select the datasheet that you want to delete.
    The selected datasheet appears.
  3. Select .
    The Alert window appears.
  4. Select Yes.
    The datasheet is deleted.
    Note: The deleted datasheet will immediately become unavailable to all users. If you are currently accessing a record using that datasheet, you must reopen the record and select a different datasheet.

Add a Section to a Datasheet

Procedure

  1. Access the Datasheet Builder page.
  2. Next to the Datasheet Caption label, select , and then select the datasheet to which you want to add a section.
    The selected datasheet appears.
  3. Select .
    A new section appears in the datasheet, displaying the caption new section.
  4. Select the caption new section to modify the name of the new section.
    The workspace for the new section appears.
  5. In the workspace, select a custom or tabular layout.
  6. Select Save.
    The new section is saved on the datasheet.
    Note: The newly created section will be available for you in Family Management, whereas to access the section from other modules, you must log out and log in to APM. For other users who are being logged in to APM, the created section will be available only when they log in to the application again.

Rename a Datasheet Section, Column Caption, Field Group, or Field

Procedure

  1. Access the Datasheet Builder page.
  2. Next to the Datasheet Caption label, select , and then select the datasheet whose section or field you want to rename.
    The selected datasheet appears.
  3. Select the section name, column caption, field group, or field name that you want to modify, and then enter the new name.
  4. Select Save.
    The section column caption, field group, or field is renamed.

Define Localized Labels

Procedure

  1. Access the Datasheet Builder page.
  2. Next to the Datasheet Caption label, select , and then select the datasheet whose section or field you want to rename.
    The selected datasheet appears.
  3. Select .
    The Localized Current Value window appears.
  4. Enter the localized labels for each language which are available in the APM.
  5. Select Save.
    The localized labels are saved and displayed as per your language preference.

Delete a Datasheet Section

About This Task

Note: If there is only one section in the datasheet, you cannot delete this section.

Procedure

  1. Access the Datasheet Builder page.
  2. Next to the Datasheet Caption label, select , select the datasheet that you want to modify.
    The selected datasheet appears.
  3. In the datasheet section that you want to delete, select .

    The section is deleted.

  4. Select Save.

Reset the Current Datasheet

About This Task

If you have made changes to the datasheet layout; however, have not yet saved the changes, then you can reset the datasheet to the previously saved layout.

Procedure

  1. In the Datasheet Builder page, for the datasheet that you want to reset, select .
    The You have unsaved changes window appears.
  2. Select OK.

Results

The datasheet layout including all fields and sections is reverted to the previously saved layout.