Previous Topic

Next Topic

Book Contents

Book Index

New Values

New values are the fields which will be updated. Click on the (add field) link to select a field for the person, certification or assignment to be updated, then the operation to be applied to that field. The operations available depend on the type of data each field contains.

Linked Graphic

Operation

Description

Replace with a specific value

Replaces the existing value with one that you enter here.

Erase existing value

For numeric fields, sets them to zero. For checklist fields removes all checked values. For all other field types, erases them (sets them to blank).

Add values to list

For checklist fields only, adds additional checked items to the existing list of checked values.

Remove values from list

For checklist fields only, removes these items to the existing list of checked values.

Number/date add

For numeric fields, adds this value to the existing one. For date fields, adds this number of days to the existing value.

Number/date subtract

For numeric fields, subtracts this value to the existing one. For date fields, subtracts this number of days from the existing value.

Number multiply

Multiplies the current value by the one you enter.

Search and replace

For text and memo fields, does a simple search for existing text values, then replaces the matching value with the new value, which can be blank.

Append text

Adds text to an existing string or memo field.

Assign the value of another field

Copies the value from another field to this one, only fields of the same or compatible type will be shown as options.

Assign a new time value only

For date/time fields like "Start" for assignments, changes only the time portion of the existing value to the one you select.

Assign a new date value only

For date/time fields like "Start" for assignments, changes only the date portion of the existing value to the one you select.

Assignments which are associated with job slots cannot be updated here, since they derive their values from their job slots.

See Also

Bulk Value Updater

Using the Bulk Value Updater

Chaining Values

Bulk Value Updater Example