Set Field

The Set Field action An instruction within a botflow. places a value in a specific database field in a botflow Automated steps that you can design for each bot that will run.. Using the Set Field action, you can:

  • Edit database field entries.
  • Set the value of a formula to evaluate data.
  • Concatenate together text.
  • Set the value of a set of tokens to aggregate data.
  1. On the Actions list, click Data and then click Set Field from the Records list.
  2. Set up the Set Field options.
    3. Field or button Description
    General
    • Field: Type the Field name or use the Expression Builder to build the action settings using variables or other token values.
    • Value: Type the Value or use the Expression Builder to build the action settings using variables or other token values.
    Culture The Culture drop-down list contains a list of other cultures. If you need to convert fields and variables (dates, decimals, etc.) in the action from one culture into another one, select the new culture from this list before saving the action.
    Note

    (Optional) Type a Note to document any special instructions or functionality.    
    Run Switch

    The Run Switch toggle controls how Nintex Bot runs an action when adding or editing an action in a botflow.

    • Run: To run the action automatically when you click OK, switch the toggle to Run.

    • Don't Run: If you do not want to run the action automatically when you click OK, switch the toggle to Don't Run.
  3. Click OK to add the Set Field action to the botflow.

If you create and execute a Set Field action and a fatal error occurs, follow the instructions below to resolve the issue:

  1. Open a Command Prompt window (run as an administrator).

  2. Run the command line to install the 32-bit version of the Microsoft Access Database Engine 2016 Redistributable package with the /QUIET switch.

    Example: 

    C:\Installs\AccessDatabaseEngine.exe /QUIET