Add and configure Update 1-M Job Properties—ArcGIS Workflow Manager

The Update 1-M Job Properties step allows you to create records and show and edit the properties configured in the step for the latest record in a job's one-to-many extended properties table.

When the step is run, the properties configured in the step appear in the job tile. If the step is configured with step help, it appears at the bottom of the job tile. Default or current values appear in a text box below each property that can be updated.

When the step is run, the following actions can be performed:

The configured properties can be viewed or edited.
The step can be canceled by clicking Cancel.
The step can be finished by clicking Proceed.

Configure the step

To configure the step, do the following:

Create or edit a workflow diagram to access the Step Library panel.
Drag the Update 1-M Job Properties step from the Step Library panel to a connection arrow of a step on the workflow canvas.
Learn more about adding steps to a workflow diagram

The Step Details panel appears.
Provide a name for the step in the Step Name text box.
Optionally, add the message that you want to appear when the step is run in the User Prompt text box.
If the user prompt contains plain text and ArcGIS Arcade expressions, format the text as follows:
```
'This job is currently assigned to ' + JobOwner($Job) + '.'
```
Tip:
Click This input supports Arcade Expressions and choose an Arcade expression to add it to its associated text box.
Choose one of the following options for the Mode setting:
- Create New—Create a record for the properties configured in the step.
- Edit—Edit the properties configured in the step for the last created record.
  Note:
  If no record exists, a record is created for the properties configured in the step.
- View—Show the properties configured in the step for the last created record.
  Note:
  If no record exists, the step fails.
Click the Job Property drop-down arrow and choose the table name and field name of the property that you want to be updated.
Optionally, provide a keyword in the Job Property text box to filter the list to show valid job properties that contain the keyword.
Optionally, click Show Default Value to define the default value and visibility settings for the property when the step is run.
1. Choose one of the following options:
  - Value—Provide a static value.
  - Arcade Expression—Provide a dynamic value using an Arcade expression.
2. Provide a default value for the property in the Value or Arcade Expression text box.
3. Check the Visible check box to allow the value to be changed when the step is run.
  Caution:
  If the Visible check box is not checked, a default value must be provided.
4. Check the Editable check box to allow the value to be edited when the step is run.
  Note:
  If the Visible check box is not checked, the Editable check box is unavailable.
Note:
Checking the Visible or Editable check box in the step overrides the Visible or Editable check box specification in the extended properties table.
Optionally, click Add New Job Property and repeat steps 6 and 7 to add more properties.
Note:
To delete a job property, hover over it and click Delete Property .
Optionally, hover over a property, click Reorder Property , and drag it to the desired location to reorder the properties.
Click the Options tab.
Configure Step Options as necessary:
- Manual—Run the step manually.
  - Optional—Allow the step to be finished without being run.
- Automatic—Run the step as soon as it becomes active.
  Note:
  If the workflow diagram is configured to automatically run a sequence of steps that includes the Evaluate Data Quality or the Run GP Service step, steps that attempt to run after the user token expires will not run automatically. The ArcGIS Workflow Manager Server Advanced role is required to run additional automated steps without manual intervention.
- Run on a Schedule—Run the step according to a set schedule.
  Learn more about scheduling options
Optionally, check the Enabled check box in the Step Commenting section to allow a user to add a comment to the step when the step is run.
Optionally, if you enabled step commenting, check the Required check box in the Step Commenting section to require a comment to be added to the step before it can be completed.
Optionally, choose one of the following options to configure help in the step:
- None—Configure the step without step help.
- Text—Configure help text for the step in the Text text box.
  You can use ArcGIS Arcade expressions to provide a dynamic value for the step help. If the step help contains plain text and Arcade expressions, format the text as follows:
```
'For further assistance, please contact' + JobCreator($Job) + '.'
```
- URL—Configure the step with a link to a help resource in the URL text box.
  Note:
  Steps that are run in the web app only support HTTP and HTTPS URL formats. Steps that are run in ArcGIS Pro support HTTP, HTTPS, and file formats.
  
  You can also use Arcade expressions to provide a dynamic value. If the URL contains plain text and Arcade expressions, format the text as follows:
```
'https://pro.arcgis.com/en/pro-app/latest/tool-reference/' + JobExtendedProperty($Job, 'tools', 'toolbox') + '/' + jobExtendedProperty($job, 'tools', 'alias') + '.htm'
```
  Configure the Automatically Encode Arcade Result check box as follows:
  - If an Arcade expression returns special characters that must be escaped when converted to a URL, such as a space or a forward slash, ensure that the Automatically Encode Arcade Result check box is checked.
  - If an Arcade expression is used to form the base URL, uncheck the Automatically Encode Arcade Result check box.
Optionally, click the Style tab to change the shape and color of the step.
Optionally, click the About tab and provide a description for the step in the Step Description text box.
Tip:
The About tab also contains the step's ID that can be used with dynamic job properties to obtain a step's output. Click Copy Step ID to copy the step ID to the clipboard.

Return value

When the step is completed, its return value is stored to indicate the result of the step. The return value can be immediately evaluated using paths to determine the next steps in the workflow. You can also retrieve the return value for completed steps throughout the workflow using ArcGIS Arcade expressions. The following table lists the step's return values:


Return value	Description
S000001	The step completed successfully.
F000001	The step failed to complete successfully.

Output value

When the step is completed, its output value is stored and can be used to determine the path the workflow follows or can be used as inputs for other steps throughout the workflow. The following table lists the step's output value:


Output	Description
<ExtendedPropertyRecordId>	Returns the ID of the extended property table record that was created, shown, or edited.

Configure the step

Tip:

Note:

Note:

Caution:

Note:

Note:

Note:

Note:

Note:

Tip:

Return value

Output value

Related topics

In this topic