Add and configure Update 1-M Job Properties

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

Do the following to configure the step:

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

    The Step Details panel appears.

  3. Provide a name for the step in the Step Name text box.
  4. 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 Arcade expressions, format the text as follows:

    'This job is currently assigned to ' + JobOwner($Job) + '.'
    Tip:

    Click This input supports Arcade Expressions This input supports Arcade expressions and choose an ArcGIS Arcade expression to add it to its associated text box.

  5. 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.

  6. 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.

  7. Optionally, click Show Default Value 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.

  8. 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 Delete Property.

  9. Optionally, hover over a property, click Reorder Property Reorder Property, and drag it to the desired location to reorder the properties.
  10. Click the Options tab.
  11. 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 your 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 that started the sequence of steps expires will not run automatically. You must have a license for the ArcGIS Workflow Manager Server Advanced role to continue running more automated steps without manual intervention.

    • Run on a Schedule—Run the step according to a schedule you set.

      Learn more about scheduling options

  12. 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.
  13. 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.
  14. 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, you must 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 run in the web app only support HTTP and HTTPS URL formats. Steps 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, you must 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:

      • 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.

  15. Optionally, click the Style tab to change the shape and color of the step.
  16. 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 Copy Step ID to copy the step ID to your 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 valueDescription

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:

OutputDescription

<ExtendedPropertyRecordId>

Returns the ID of the extended property table record that was created, shown, or edited.

Related topics