(...) 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 (...)
(...) ds, you need to choose one of two data preparation methods: Use a predefined data format that allows you to define a default name along with its translations for specific languages. Add extra column s with translated values to your Data source and map them accordingly in the form field Advanced configuration. METHOD 1 – Data format The Data source intended for use in a Cho (...)
(...) 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 (...)