search results

(...) 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 (...)

(...) st, choice field with a search option (a.k.a. Search window), and autocomplete. This article discusses the operating mode of the choice field type, types of choice fields in item lists (a.k.a. choice column s), the person type or group field type as well as the differences between the form fields presented above.   Tab.1 Comparison table with choice field types Mode (...)

(...) vailable for selection. If possible, give the name of the data source (other BPS workflow instances, SQL table, web service) Data table Provide only for data tables. Give the list of column s to be displayed in the table. Indicate the column that should be displayed in the form of links. To save space on the form, you can divide the table into pages by specifying how many rows are to be (...)

(...) (and in the case of the described application, all types of activities displayed on the Gantt chart).   Fig. 6. A query returning absebce types   The names of the returned column s are as in the query above: VACType_ID --> ID of the absence/activity (must be unique) *required VACType_ColorID --> specifies the color of the bar on the Gantt chart *required VACTyp (...)

(...) e indexed ID MS SQL, Oracle technologies as standard The views delivered by the customer should be outside the contents of WEBCON BPS databases. 2. Examples of views View of Customers column : ERP_ID - unique ID applied to the entire data set, required NAME - required NIP [TAX IDENTIFICATION NUMBER] - required COUNTRY - optional, two-digit country code CITY - optional AD (...)

(...) of fields on the form. They allow you to configure the form in terms of dynamic setting required fields to be completed. Business case The ability to set the required form fields (or item list column s) on the form depending on the value change of other form fields is one of the most frequently used system functions. Until now, to achieve this effect, it was necessary to change several configurati (...)

(...) nce, and any collection defined as a business rule.   Fig. 2. Collection type   Item list – the ability to select all available item lists in the process. All column s of the item list, excluding column s of local attachments (these column s are not available for reading or saving) can be transferred to an action, operation, or automation.  Data source &ndash (...)

(...) on the operation of WEBCON BPS Scalar functions defined in WEBCON BPS mostly perform conversion or formatting operations on single values. There are no subqueries or arithmetic operations on a few column s from the table - passed as input parameters. “Inline” of such functions in WEBCON BPS databases does not improve query performance. However, because they are used in large numbers in SQL (...)

(...) udf-inlining Scalar functions defined in WEBCON BPS databases mostly perform conversion operations or format data on individual values. There are no subqueries or arithmetic operations on multiple column s of the table passed as entry parameters. “Inlining” such functions in WEBCON BPS databases does not improve performance. On the contrary, due to them being used extensively by SQL querie (...)