Skip to main content
WEBCON BPS
Documentation
2023 R3
  • 2025 R2
  • 2025 R1
  • 2024 R1
  • 2023 R3
  • 2023 R2
English
  • English
  • Polski
ctrlK
  • Introduction
  • Getting started
  • Designer Studio
    • Licenses
    • Main menu
    • Designer Studio Toolbar
    • Applications
    • Processes
    • Workflows
    • Actions
      • Sequence of action execution
      • OCR and scanning
      • Notifications
      • Form
        • Change value of single field
        • Hyperlink
        • Validate form
        • Change values of multiple fields
        • Update item list values
        • Clear item list
        • Replace item list
        • Remove item list row
        • Add item list rows
      • Task assignment
      • Privileges and public access
      • Workflow control
      • Substitutions
      • Excel, Word and PDF
      • Reports and printouts
      • Digital signatures and certificates
      • Barcodes
      • BPS users and groups
      • Exchange
      • Active Directory
      • SharePoint content
      • SharePoint users and privileges
      • Integration
      • Attachments
      • Database retention
      • OneDrive
      • Performance indicators
    • Automations
    • Importing and exporting applications
    • Variables
    • Business rules
    • Form rules
    • Administration tools
    • Data sources
    • System settings
    • Reports
    • SDK plugin packages
  • Mobile application
  • MS Office Add-Ins
  • Guides
This is documentation for WEBCON BPS 2023 R3, which is no longer actively maintained.
For up-to-date documentation, see the latest version (2025 R2).
  • Designer Studio
  • Actions
  • Form
  • Update item list values
Version: 2023 R3

Update item list values

This action allows you to change (update, add or remove) the data stored in Item list.
The formula that changes the value should be saved as an SQL query.
If the data source has been specified, the query is executed with the connection parameters specified in the data source definition.

Update item list values

1. Item list​

Allows you to specify the Item list to be changed.

2. Change type​

Specifies the type of change that will be carried out:

  • Update the existing rows ​​– updates values in the Item list rows. It updates only those rows whose Data source and Item list identifiers provided in the Unique value mapping field are matching. The Column mapping field allows you to specify the cells whose value will be overwritten by the value stored in the data source.
  • Add new rows from the data source ​​– adds rows to Item list. It adds only the rows that exist in the Data source, but are not available in the Item list. The rows to be added are identified on the basis of unique values provided in the Unique value mapping field. The Column mapping field allows you to specify the cells into which the data source column value will be inserted.
  • Remove rows that do not exist in the data source – removes the rows that are not found in the Data source from the Item list. The rows are identified on the basis of unique values specified in the Unique value mapping field.

You can simultaneously employ multiple modes.

3. Data source​

Data source in the context of which the query will be executed.

4. SQL query​

An SQL query should return columns corresponding to the columns in the Item list.

5. Unique value mapping​

Allows you to assign a unique value to identify the rows of the Item list to be changed.

6. Columns mapping​

This option is used to map data source columns to Item list columns. Based on this mapping configuration, Item list columns will be filled according to their order on the form in the given step.
If column mapping is not configured, the column will be skipped when setting values.
If the data source fails to return a column (despite mapping), the column will be skipped as if it was not configured. Item list initialization and the action will be logged as missing column configuration.

7. Get columns​

Gets a list of columns corresponding to the current SQL query.

Previous
Change values of multiple fields
Next
Clear item list
  • 1. Item list
  • 2. Change type
  • 3. Data source
  • 4. SQL query
  • 5. Unique value mapping
  • 6. Columns mapping
  • 7. Get columns
WEBCON is the leading European-based provider of a complete Low-code Application Platform for mass delivering business solutions. Companies choose WEBCON to dramatically reduce time and cost of app development. The platform allows them to automate and manage business processes across the entire organization – using a single, unified platform. Thanks to its unique InstantChange™ technology, WEBCON embraces change like no other platform on the market.
  • Copyright © 2025 WEBCON
Platform
  • The latest version
  • InstantChange™ Technology
  • WEBCON BPS overview
Community
  • WEBCON Community
  • Developer portal
Meet us
  • About WEBCON
  • News
  • Contact
Copyright © 2023 WEBCON

Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪.

Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.