Mark records for updating according to one or more criteria by creating an update
job.
Antes de Iniciar
Role required: admin
Procedimento
-
Either choose to mark specific records for updating or
mark all records in a list for updating.
- To mark only specific records for updating, navigate to .
- To mark all records in a list for updating, in any list of records,
right-click a column heading, and then select .
-
Select the table that contains the records you want to update.
- Opcional:
Limit the number of records in the update job by adding a condition or
conditions that records must meet.
-
Select a field, operator, and field value.
For example, [Category] [is]
[Software].
- Opcional:
Use the OR and AND operators to add conditions.
- Opcional:
Select New Criteria to add another set of
conditions.
Nota: Limiting the number of records that are added to the update job can help
prevent the table from being locked when the job is executed.
- Opcional:
View the number of records that match the conditions.
-
Select Preview.
-
Select the link with the number of matching records.
-
In the Fields & values lists, select the field that you want to update and
a new value.
- Opcional:
Select additional fields and values to update more fields.
-
Select Continue.
Resultado
The job is saved and the form provides options to schedule the job or execute it
now.