Manage Bulk Data Form

About the Bulk Data Form

The Bulk Data Form lets you view the details of multiple records assigned to the same family and which belong to the same family. This can be useful if you want to compare data for multiple entities without having to switch between records and remember the information in each record.

If a master/detail datasheet is designated as the default datasheet for a family, at least one non-custom form datasheet must exist for a family before that family can be opened in the Bulk Data Form. If a master/detail datasheet is specified as the default datasheet for a family and you try to open that family in the Bulk Data Form, the Bulk Data Form will display the family using the first non-custom form that appears after the default datasheet in that family's list of datasheets.

Using the Bulk Data Form, you can filter the records that appear in results, create new records, modify existing records, or delete records from the database. Like in the Record Manager, to create, modify, or delete records in the Bulk Data Form, you must have the necessary privileges to create, update, and delete the relevant family.

Regardless of whether you open one record or multiple records, the Record Manager lets you view only one datasheet at a time. So, even if the record hierarchy displays multiple records, you can view the details only of the selected record.

Using the Bulk Data Form, you can add new records and modify existing records in the database.

About Freezing and Unfreezing Columns on the Bulk Data Form

When you view records in the Bulk Data Form, more columns may be available than the number of columns that can be displayed on one screen. In this case, you will need to scroll to the right to view all the columns. In some cases, the first column or the first few columns in the grid may contain information that you need to reference while you view information that appears in subsequent columns. In this case, you can freeze the columns that should remain visible as you are scrolling. When you freeze a column, that column and any column that appears to the left of it will remain in their current positions on the screen, even as you scroll through subsequent columns that appear to the right of the frozen column(s).

After a column or set of columns is frozen, if you want to freeze different columns, you will need select the columns to freeze. You can freeze a maximum of four columns on the Bulk Data Form page. Also, if you change the page setting to view a different page for the records, any columns that were frozen will be unfrozen automatically. Additionally, after you navigate away from the Bulk Data Form, the next time that you view records in that family in the Bulk Data Form, the settings for the column are saved as a user preference for the user, and will be frozen the next time the user accesses the form.

Access the Bulk Data Form

Procedure

  1. Access Record Manager.
  2. In the Record Explorer pane, in the Related Families section, select a family to expand its contents.

  3. Select , and then select Manage All Related Records.

    All records related to the record you initially opened appear in a Bulk Data Form.

Freeze and Unfreeze Rows on the Bulk Data Form Page

Procedure

  1. Access the Bulk Data Form page.
  2. On the Bulk Data Form page, in the grid, select the row that you want to freeze.
  3. On the upper-right corner of the page, select , and then select Freeze Row.

    The row is frozen, and the scroll bar moves from that row to the next row.

    Note: You can freeze a maximum of three rows on the Bulk Data Form.
    Note: The Freeze Row option is only available if sequential rows at top of form are selected or freeze row behavior applies to everything above the bottom most selected row.
  4. To unfreeze a frozen row, select the row that you want to unfreeze, and then select.
  5. Select Unfreeze Row.

    The row is now unfrozen.

Freeze and Unfreeze Columns on the Bulk Data Form

Procedure

  1. Access the Bulk Data Form page.
  2. On the Bulk Data Form page, in the grid, select the column that you want to freeze.
  3. On the upper-right corner of the page, select , and then select Freeze Column.

    The column is frozen, and the scroll bar moves from that column to the next column.

    Note: You can freeze a maximum of four columns in the Bulk Data Form. However, you will not be able to select and freeze the Site column.
  4. To unfreeze a frozen column, select the column that you want to unfreeze, and then select .
  5. Select Unfreeze Column.
    Note: You will not be able to select and unfreeze the Site column.

    The column is now unfrozen.

Choose Columns in Bulk Data Form

Procedure

  1. Access the Bulk Data Form.
  2. On the upper-right corner, select , and then select Column Chooser.

    The Choose Columns window appears.

  3. Depending on the columns that you want in the Bulk Data Form datasheet, select or clear the check boxes next to the columns.
  4. Select Re-order.

    The columns now appear as selected in the datasheet. The settings are saved as a user preference for the user.

Modify an Existing Record in Bulk Data Form

Procedure

  1. Access the Bulk Data Form.

    The bulk data form appears.

  2. As needed, enter values directly into the cells for the record that you want to modify.
  3. Select .

    The changes are saved.

Add Reference Documents to a Record on the Bulk Data Form Page

Procedure

  1. Access the Bulk Data Form page.
  2. On the Bulk Data Form datasheet, in the grid, select the checkbox next to the record that you want to add the reference document.
    Note: You can add a reference document to one record at a time.

  3. Select , and then select Reference Documents.

    The Reference Documents window appears.

  4. Select .

    The Add Reference Documents datasheet appears.

  5. As needed, enter the values for ID and Description.
  6. In the Document Path field, select .

    The Edit Document Path window appears.

    Note: You can either upload a file from the local network by selecting Browse, and navigating to the path of the file or you can link to an external network file.
  7. Select Save.

    The Reference Document is added to the selected record in Bulk Data Form.

Copy a Record on the Bulk Data Form

Procedure

  1. Access the Bulk Data Form page.
  2. On the Bulk Data Form datasheet, in the grid, select the check box beside the record which you want to copy.
  3. On the upper-right corner of the page, select , and then select Copy.

    A copy of the record appears at the bottom of the list.

  4. Select .

    A copy of the record is saved.

Delete a Record on the Bulk Data Form

Procedure

  1. Access the Bulk Data Form page.
  2. On the Bulk Data Form page, in the grid, select the check box beside the record which you want to delete.
  3. On the upper-right corner of the page, select , and then select Delete.

    The Alert dialog box appears, asking you to confirm that you want to delete the record.

  4. Select Yes.

    The record is removed from the Bulk Data Form.