Skip to main content
WEBCON BPS
Documentation
2024 R1
  • 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
      • Creating a new process
      • General
      • Business rules
      • Form rules
      • Automations
      • Action templates
      • Performance indicators
      • Constants
      • Form fields
        • General form field configuration
        • Basic form fields
          • Single line of text
          • Multiple lines of text
          • Integer number
          • Floating-point number
          • Item list
            • Advanced configuration
              • General
              • Initialization
              • Totals control
              • Import settings
              • Layout
            • Column configuration
            • Basic columns
            • Choice columns
          • E-mail
          • Picture
        • Picker fields
        • Survey fields
        • Data presentation
        • Specialized form fields
        • Shared global fields
        • Groups and tabs
      • Form types
      • E-mail notifications
      • Start workflow in process
      • Attachment details
      • Related processes
      • Process check out
      • Verify process
      • History of changes
      • Generating process documentation
      • Exporting/Importing translations
      • ToDo List
      • Process context menu
    • Workflows
    • Actions
    • Automations
    • Importing and exporting applications
    • Variables
    • Business rules
    • Form rules
    • Administration tools
    • Data sources
    • System settings
    • Reports
    • SDK plugin packages
  • Portal
  • Mobile application
  • MS Office Add-Ins
  • Guides
This is documentation for WEBCON BPS 2024 R1, which is no longer actively maintained.
For up-to-date documentation, see the latest version (2025 R2).
  • Designer Studio
  • Processes
  • Form fields
  • Basic form fields
  • Item list
  • Advanced configuration
  • Initialization
Version: 2024 R1

Initialization

Configuration of the Item list initialization allows users to define values to be automatically entered in the Item list rows after opening the form. Additionally, it is possible to initialize columns which are not displayed on the form (their visibility is restricted or they are marked as technical columns).

Init_screen.png

1. Action mode​

Selection of action mode from the following options:

  • Initialize only in the first step – initializes Item list on the first step only,
  • Initialize on ever step (without ending steps) – enables the Item list initialization also on other steps, except the finishing ones when the list has not been edited so far and there are no versions available from the previous steps in the history.

2. Initialization​

There are two available initialization options:

  • Use data source or query – initializes the list with an SQL query that returns rows with which an Item list will be initialized or column mapping.
  • Use static initialization: – allows to define a fixed set of items with which the Item list will be initialized.
Static initialization

Using the + or - buttons you can add new items to an Item list. The ID value must be a number.

Init_custom.png

SQL query in the Use data source or query initialization

The query should follow the following format: "Select ‘text123’ as ‘DET_Att1’, ‘9’ as DET_Att2". In the case of this query the "text123" value is inserted in the "DET_Att1" column, and the form field with the ID of "9" is entered in the "DET_Att2" column.

The ID and the field corresponding to a given form field in the database can be viewed in the form field general configuration.

Init_custom_2.png

The Data source field allows users to select a data source that is different than the default one, and, consequently, sending a query to a source different than the content database. The query must return columns with names corresponding to the names of Item list columns in the database.

When a default source is selected, the query is executed with content database connection parameters.

info

When it is not necessary to link with an external data source, use the default one, as its modification affects the query execution efficiency.

An example of an SQL-based initialization​

A demonstrative Item list (a list of products):

custom.png

Column nameType
NameSingle line of text
AmountFloating-point number
PriceFloating-point number
DescriptionMultiple lines of text
Ordered byChoice field (picker)

The SQL Products table is used as a data source:

Column name
ProductName
ProductPrice
ProductDescription
ProductCount
OrderedBy

The table has been created in the default data source, i.e. the content database.

An example of initialization configuration:

custom_2.png

The query automatically maps the data source columns and copies their values to the Item list columns, e.g. the ProductName column of the source table corresponds with the DET_Att1 Item list column. The database name of the Item list column is displayed in the Column field of column configuration window.

The configured initialization is executed only at the first step. The initialization result:

custom_3.png

Previous
General
Next
Totals control
  • 1. Action mode
  • 2. Initialization
  • An example of an SQL-based initialization
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.