search results

(...) ; author: Józef Cyran Introduction WEBCON BPS 2021 introduces new functionality of grouping rows of item lists. Now, users can collapse and expand groups and display subtotals when the column has been configured to display totals. This article describes how to configure and use this option on an example of a simple subscription management workflow Process description The subscriptio (...)

(...) about the synchronized item from AD and save it in the BPS database. 30 additional properties that were read from the AD are available to download, and their values will be saved on selected database column s. Pointing to additional data for synchronization is not necessary.   Fig. 3. The "Settings" tab   Some information about a user can be independently stored bot (...)

(...) between entering values to the system by the user (form field save) and creation of a new index for a modified instance in SOLR base. Index is created for values of all form fields and items list column s. All text document added as attachments to the forms are also indexed. Apart from text formats such as TXT, RTF, XML, HTML, SQL indexation is also done to documents in following formats: Word (DOC, (...)

(...) r) 3x Date & time 3x Floating-point number 1x Integer number 3x Single line of text 3x Multiple lines of text 2x Person or group picker 1x Yes/No choice 1 item list comprised of 5 column and 5 rows: 1x Choice field column 2x Single line of text column 1x Date & time column 1x Floating-point number     For the form pictured above, (...)

(...) tion   Dynamic – by indicating a form field that stores the appropriate users/groups (If it is a form field other than the “Person or group” type, you must designate a column that contains a user login or group ID).   Fig. 4. The "Dynamic" option   SQL query – by entering the appropriate SQL query that will return user login (...)

(...) then filter the values so that the function returns the value of the currency indicated on the form (the source currency code from the data source must match the one from the form). Next, select the column of the returned value - in our case, it will be a column that returns the currency rate. Similarly, the rule should be configured after selecting the target currency and supplementing the technica (...)

(...) n all environments (TEST and PROD). Configuring the source in the context of the appropriate environment can be deferred until the process is deployed to that environment.   Using database column names Process form field values are stored in the database column assigned when the form field is created. An example of the "Acceptor" form field, the values of which will be stored (...)

(...) ible in the application, there are two technical form fields: _oldest order time and _oldest order.   Fig. 4. Configuration of the application   The Orders item list has six column s, the Status column is supplied with the “Fixed values list” data source type.   Fig. 5. Data source used in the “Status” column   To dynamically co (...)

(...) or/employee). Instead of the data type form field (From/To), create an item list – it allows the employee to plan absence e.g. for the whole year. It’s a good idea to add a calculated column (text type) that will automatically display the number of working days that the plan contains. Below is the configuration of this column :   Fig. 2. Configuration of the calculated colu (...)

(...) Applies to version: 2021.1.x and above; author: Konrad Wojtycza Introduction The “Item list” form field is used to store any number of data rows organized into column s. In business practice, there is a need for the item list to be updated based on the values from other elements or updated automatically, and a user cannot edit it. For this purpose, you can use the “Change items l (...)

(...) (ex. PL, EN, DE, IT) LANG_NAME Value translation for a specific language   It is possible to provide an unlimited number of translations, the only limit being the column size in the database to store translatable values. Example Below you can see an example of a phrase with a default value „Kolor” for which three translations were made – in En (...)

(...) Applies to version: 2021.1.x and above; author: Konrad Wojtycza Introduction WEBCON BPS 2021 introduces the new SELECT VALUES function that allows you to retrieve data from a selected item list column . This function enables saving data from all rows of a given column in a form field indicated in the configuration. Data are saved as a collection separated by semicolons. The function ignores empty v (...)

(...) ata is to be downloaded.   Fig. 5. Configuration of the SQL query returning the attachment   Mapping tab – in this section a user assigns sheet cells (Excel address column ) to the corresponding form fields (Form field column ). The cell address must be configured according to the SheetName!CellAddress rule – e.g. Sheet1!A1. A dynamic selection of cells and sheets (...)

(...) has a source configured to support multilingualism:   Fig.8 . Translation of values in the "Fixed values list" data source.   The permission’s item list column s have also been translated, as well as the column headings of the "Assigned Equipment" data table.   Configuration of document templates in different languages Two templates f (...)

(...) result it is possible to switch between Pop-up and Autocomplete behavior modes freely. In the field configuration, you can define what information is visible about each selectable value, and by which column s the data source can be searched. column s returned by the specified data source can be added and rearranged in the Source column  section of the configuration table.     (...)

(...) oved?" is a workflow control step. It returns workflow instances to the approval step until all required persons have approved the invoice. The invoice approvers visible in the Approver (Fig. 9) column are assigned to individual accounts of the analytical breakdown.   Fig. 10 Configuration of the "Accounting" workflow   Workflow control configuration on the " (...)

(...) nbsp;Dashboards – system dashboards 4.    DashboardWidgets – widgets on the dashboard 5.    Reports – application reports 6.    Reportcolumn s – the report column s 7.    BpsChartViewConfiguration – report views 8.    Processes – processes 9.    WorkFlows – workflows 1 (...)

(...) source, most often in a table of an appropriate form (Fig. 1) Defining additional settings in the advanced configuration window The basic table for the Chart form field must have at least one column that acts as a numeric data series.   Fig. 1. “E-commerce revenue Poland” data source   The advanced configuration Data - the table displays all the col (...)

(...) hat can be included in the dictionary of Customers and their bank account numbers (the values from these dictionaries will be narrowed down).   Dictionary of Customers column Type of data Comments ID int column with unique values   Name string (...)

(...) on configuration in WEBCON BPS Designer Studio Input data     Output data   Example of the data in SQL view with procurement status  column Type of data Comments ID int column with unique values Procurement ID string (...)