ResourceFirst 8.5 Knowledge Base

Table of Contents
< All Topics
Print

Data Entry in ResourceFirst

This article shows how to enter data in ResourceFirst views and forms, along with options for using copy-paste and drag-fill.

Forms

Forms are available only for projects. They are displayed on the Project Info page of an individual Project Workspace. This page is accessed by clicking the hyperlink in a project name field on a project page such as Project Data (and others).

clipboard_e7e32701722efbfb45ccc1105f6383e06.png

Data entry in form fields is straight-forward – just left click in the field and start typing. In addition to free-form fields, there are

List Fields      –    Type a few characters of the desired value to filter the list OR click the drop-down arrow

Date Fields    –    Type a date OR select a date with the calendar control in the field.

Views

Views are laid out as grids where each column represents a field/attribute and each row an object or line item. For example, the Project Data page has a row for each project in the current data load. Each cell on a row is in a column representing some attribute of projects, such as project name or manager or start date.

clipboard_ece62264ed80e265f57f5e5514c29c540.png

Some pages also contain a numeric period data grid containing values for things such as resource capacity (hours or FTE) in each period of the current data load.

clipboard_e31ce216b8ef7cb028caac95d1b978f9d.png

Read-Only vs. Editable Pages

Some grid type pages are read-only; others have editable fields and/or period data grids.

The Project Demand page is read-only, as is Resource Utilization, and many others.

On the Resource Capacity page, resource attributes are read-only, but the period data grid is editable.

On Project Data and Resource Data most attributes are editable.

On Labor and Financial Assignment pages most attributes and all period data columns are editable.

Read-Only vs. Editable Fields

Fields can be configured to be read-only for everyone, or for users below some rights threshold.
(See the article Administering Column Headings for details on field definition.)

Some system fields are read-only for everyone, e.g. Modified By and Modified Time.

Assignment page Views can contain native assignment fields, and referenced (“mapped”) project and resource fields.

Mapped project and resource fields included in assignment Views are read-only on the Assignment page. They can be modified only on the Project Data, Project Info, or Resource Data pages.

Locking Records and Periods

There are many ways objects and fields can be locked by administrator configuration or by user action. For a full discussion on how records and periods can be locked, see Data Locking in ResourceFirst.

View (Grid) Data Entry

Note: The behavior of cells in ResourceFirst period data grids is similar to, but not identical to, cell behavior in MS Excel. This section explains those differences. 

Cells in ResourceFirst grids have three states: not selected, selected, and edit mode.

Not selected    clipboard_eec41970f05af8af3e563cf621b83bd1d.png
Selected            clipboard_e934fd3c274f966bd75a6fa0f5f18843c.png
Edit mode        clipboard_eed04a2396ecb53f493d234fd72fcc867.png

Read-only cells cannot be selected. If you click on a read-only cell, the entire row is selected.

A cell is put into edit mode by left mouse click or by tab from the nearest editable cell to its left that is already in edit mode.

Tab works only from a cell already in edit mode and puts the next editable cell to the right of the cell (on the same row) into edit mode (skipping any intervening read only cells).

Left-to-right-tab-entry.gif

A single cell can be selected by left mouse click.

If the cell is editable, this puts the cell into edit mode. Then click the Enter key to put the cell in Selected state. Selected state is needed when doing a Copy/Paste (both the source and at least the first target cell must be in Selected state to perform a Copy/Paste function).

A range of cells can be selected by 1) left mouse click and hold, 2) drag, 3) release left mouse button over the final cell in the target range.

Select-a-cell-range.gif

Shift ClickLeft mouse click and release, shift-click and release elsewhere leaves the shift-click cell in edit mode. Click the Enter key to put that cell in selected mode.

Shift-Click-GIF-2.gif

Control ClickNot supported.

Cell Behavior in Edit Mode

Cell value (if any) is selected – typing, delete key, and paste modify the value

Edit Mode is terminated by:

Enter key – cell changes to Selected state, value change if any is committed

Left Click-Mouse Up on another cell or range – cell state is Not Selected, value change if any is committed

Escape key – cell state is Selected, the cell value is unchanged

Field (Attribute) Edit

Left click in a cell and either type a value or, for list type fields, click the drop-down arrow and select a value.

Multi-Select Field Edit

Check the selection checkboxes at the left of all the rows you want to modify.

Left click in any cell of the target field on one of the selected rows, type or select a value, and click the Enter key.

Multii-Select-Edit.gif

Data Entry in Period Grids

The following methods can be used to enter and modify data in editable period cells:

Typing directly in a cell

Left click in the cell to put it in edit mode and type a value.

Drag-Fill

Select a cell or a range (i.e., left click and press enter to put it in Selected state)

Select the fill handle.

Drag up or down, or to the right or left.

Copy-Paste

Paste operations in the period data area ignore the dimensions of the target selection.

Instead, the first cell selected to make the target selection is used as the target for the top left cell of the paste range.

Single cell copy to single cell selection

[The edit/selected states of the source and destination cells do not matter.]

Left click on the source cell.

Click Ctl-C.

Left click the destination cell.

Click Ctl-V.

Single cell copy to multiple cell selection

This feature is not available.

The workaround is to copy-paste or directly enter the value in a cell and then use up-down and left-right Drag-Fill to populate the target range.

Multiple cell copy

Left Click>Drag from any corner of the range to the opposite diagonal corner.

Press Ctl-C.

Left Click>Drag starting in the upper left destination cell and dragging to the lower right.

If shift left click is used to make an extended selection, it must be followed by the Enter key because that last cell is in Entry Mode.

Note: The Paste operation goes to the cell in Edit Mode if any. If no cell is in Edit Mode, the Paste goes to the active cell which is always the first cell selected to make the current selection.

An extended selection created by left click and drag from lower right to upper left results in the Lower Right cell being the active cell.

Control left click is NOT available to extend a selection.

TIP: The easiest way to create the destination for a Copy (single or multi-cell) is to left mouse click drag over two cells with the first cell selected as the target. The second selected cell is not affected by the paste.

NOTE: The Delete key does NOT work on a selected cell or multi-cell range. The Delete key works only on a single cell that is in edit mode.

Forms Data Entry

Fields on forms are editable unless they are read-only. Some system fields such as Modified By are inherently read-only; others may be configured by system administrators as read-only based on user rights.

Leave a Reply

Your email address will not be published. Required fields are marked *

Play Video
Play Video