WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question

search results

for calculated columns

Applies to version: 2020.3.x and above; author: Józef Cyran   Introduction The item list is frequently used to store any number of data rows as opposed to other form fields. This functionality makes the actions executed on the item list differ from the standard form field configuration.   Business case: Personnel planning for a project This article describes the

Applies to version: 2020.1.x and above; author: Adrian Baszak   Introduction Setting up default values in form fields is one of the most basic and easy things that we can do to facilitate and improve the user experience of working with forms in the WEBCON BPS system. The following article describes the various methods used to configure the default values and examples of use.

(...) Applies to version 2020.1.3; author: Michał Kastelik   calculated columns enable you to display additional information in WEBCON BPS reports. They are created by adding a new column in the report and then inserting a SQL  formula. They allow the report to be supplemented with additional fields that are not present in an application. A calculated column only works within a given report.   (...)

Applies to version 2021.1.1; author: Kinga Bożęcka WEBCON BPS 2021 introduces the mechanism of diagnostics and recording the behavior of the form and other elements of WEBCON BPS Portal. This mode is a successor to the old Debug mode which was used to track all modifications that impact the visual layer.  This functionality toggles a diag

(...) ; to select which columns should be used in the report. System columns are displayed by default. You can add columns with form fields that are a part of the process and the workflow. You can also add calculated columns ; their configuration is explained in in this article. Fig.7 Columns configuration Under “Default Sorting,” you can sort data in chosen columns. Fig. 8 Sorting configu (...)

Applies to version: 2021.1.x and above; author: Józef Cyran Introduction The article presents two workflows, the first is used to plan absence by an employee, and the second to register absence requests (using wizard). A special workflow for creating absence plans allows the employee to plan the absence (e.g. at the beginning of the year), which will then appear on the Gantt chart.

(...) mptName – field related to the reports, it contains the column names visible on the report, derived from the names of the process form fields presented on the report, and the local standard and calculated columns for the report remember that the change in the ReportColumns section is required only for standard and calculated columns , occurring only on a specific report. In the case of translations of column n (...)

This article aims at providing key information required to configurate new application elements. The article presents both required and optional information that will help you to add configuration components, such as: Form field Step Transition path Report BPS group Action – general Action – form validation Action – e-mail notification Hardcopy templat

Applies to version: 2022.1.3 and above; author: Krystyna Gawryał   Introduction WEBCON BPS introduces many new features regarding the chart view in application reports. The list of charts has been complemented by new chart types, and it is now possible to customize the appearance of a chart, add data series, subgroups, present two charts on one view, and many more. This article

Applies to version: 2022.1.3 and above; author: Krystyna Gawryał   Introduction Item list is a form field displayed as a table with definable columns that contain user’s data. This form field can be edited to the extent provided by the system: users can change the column values as well as add, delete, and clone individual rows. It is also possible to independently configure th

(...)   At the database level in WEBCON BPS, the aforementioned mechanism has been implemented for picker fields by creating indexed choice columns for each picker field type. Those are indexed, calculated columns for which an identifier (ID) is calculated. Please note here the word “calculated”, as the identifier (ID) is not physically saved in those columns, but rather calculated immediately in t (...)

Hello everyone! A problem I encountered in 2021.1.4.118 does not give me a rest. It conserns Item Lists. When I use any type of choice field and in the picker tick "Show link to this item" it still does not show the item with the link (as it does in standard attributes). It doesn't matter if the field is read-only or writable - always no link. I suppose the solution could be a separate hyperlink

(...) process into which about 150,000 objects have been imported using the API. After opening the report, a long loading bar appears and then the message "Failed with unknown exception" and to check the calculated columns . There are no calculated columns in the report. There are no such problems for the previous case of 20,000 loaded objects. What could be the reason? Is there any optimization of the WEBCON platfor (...)

Hi, this may sound strange, but so was the reason, why I'm proposing this. My suggestion is that the expression editor for a SQL command inserts the instance id variable in a way: Currently it is inserted as: {WFD_ID} My suggestion is that it is inserted within single quotes: '{WFD_ID}' The reason for this is, that it would prevent errors which may only surface in production. This is