search results

(...) Applies to version: 2020.1.x and above; author: Michał Kastelik   This article describes: How to start a WEBCON BPS workflow using advanced column formatting in the SharePoint library. How to download an attachment from a SharePoint library and insert it in a BPS workflow.    Read this article if you are interested in SharePoint workflows made easy by using (...)

(...) a database configuration, while the “WFAttachmentFiles” stores the attachment files.   Fig. 1. Construction of external attachments database   The most important column s in the “WFAttachmentFIles” table are: ATF_ID – a row ID ATF_ATTID – a relation to the WFDataAttachmets table in the content database ATF_WFDID – an instance I (...)

(...) EID – the form type iD, the main key (DTYPE_ID) in the WFDocTypes table Data storage The WFHistoryElements table stores all information about the progress of the instance. Selected column s of this table are presented below: WFH_Version – informs which entry is which version of the instance. After starting the workflow, the first entry in the WFHistoryElements table will ha (...)

(...) roduction WEBCON BPS can be extensively integrated with Microsoft SharePoint Online. This article describes how to start a workflow by using a standard SharePoint list with advanced column formatting. In the presented scenario, the SharePoint list will be used to start the workflow of inviting people to the conference – after entering the name and surname, a marketing workflow (...)

(...) Item lists and data tables In the template you can also add the item lists defined on the form. After adding the item list, a window will appear in which you should set the visibility, order and column names. For the column s with numerical data there is the ability to add a row summing the values.     After confirming the configuration, the list will be added to the template (...)

(...) WEBCON BPS Designer Studio   You can define the non-working days of week and non-working dates (e.g. holidays) in a given year.   Storing the data Below three most often used column s from the user’s point of view was displayed: CAL_IsDeleted – information whether the row was deleted CAL_WorkingDate – a date CAL_IsWorkingDay – information whether (...)

(...) from the classic process instance report, BPS gives the ability of configuring, among others: Business entity – you can limit people in the schedule relative to the company Visible column s – these column s display the information on how many days of vacation a given person has to use. You can also decide what kind of information will be visible on the schedule. Vacation ty (...)

(...) ueue” option. This option is set by default.   Fig. 1. The “Send a custom e-mail” configuration   WFMails table structure A description of WFMails table column s: MAIL_Status – information about the status of the message MAIL_AttemptsNumber – a number of attempts to send a message MAIL_LastAttemptTime – a last attempt to send a mes (...)

(...) on The WFSecurities table contains information about current privileges granted at the process level, instance and type form in the context of a given workflow. The table consists of the following column s: SEC_LevelID – information about the access level: 1 – Admin 2 – Modify without delete 3 – ReadOnly 4 – AddNew 5 – ReadOnly without at (...)

(...) oping the process is related to an increase in the number of form fields used, although this is not always necessary. For more information see: WEBCON BPS  – limits of form fields and column s. This article describes how to limit the number of form fields in WEBCON BPS 2020 and presents good practices in planning and configuring process – so that these limits are not reached. (...)

(...) in the following screenshot:   Fig. 4. The SQL Manager Studio window   How to write a query to see what happens in the action logs?   The most frequently checked column s in action logs are: LOG_ACTID – stores the action ID number LOG_ActionSucceeded – information whether the action was correctly performed LOG_AdditionalMessage – additional (...)

(...) s you to indicate a substituted and substitute user or group. The values can be entered in the “Always to” field or a dynamic selection can be set based on the form field or the item list column (the action is executed only on the first login, the others are skipped). Substitution date – enter the start and end date of the substitution. The date can be selected from the calendar or c (...)

(...) the item list by using this action.     The “Project name” and “Project description” form fields are provided without mapping because they are the same column s. While, the column s on the Tasks list item list – “Person assigned” and “Task description” are mapped to the corresponding form fields.   The form (...)

(...) You can set the value by specifying the ID that uniquely identifies the row/entry from the data source. To correctly complete the choice field, the given value must be found in one of the data source column s (those for which the search option was selected in the advanced configuration of the form field).   Fig. 2. Configuration of searching in the choice field. If the default value will n (...)

(...) The instance to be updated is selected based on the value (ID) found in this form field. SQL query – the instance to be updated is selected based on the SQL query. The query should return one column containing instances ID to be updated. The query can return several rows. You must indicate the data source on which the query should be performed   Process – selecting the pa (...)

(...) ldquo;All” or “Selected” options refer to instances from the content database while the “Archived” option refers to instances from the archive database. In the “column s” tab select the column s that will be displayed on the report. Fig. 4. WEBCON BPS Designer Studio – column view configuration on the report   After selecting the column s (...)

(...)   Introduction In WEBCON BPS 2020, a new method of creating translations for data values in picker fields has been added. To simplify the process of translation, you can use data source column s.   Creating a translation data source To create a data source for translation, you can use the functionality of dictionary processes. First create a Dictionary Process from the wizard (...)

(...) nced configurations using the conditional instructions.   The option is available in the report configuration:     When editing the report, a new “Style” column appears in the “Views” tab. By clicking the “Pencil” icon next to the selected column of the report, a window with the option of choosing one of four coloring modes is opened: (...)

(...) duction In the WEBCON BPS 2020 version, the application reports have been expanded with the ability to display data from an Item list form field. In the report configuration, you can add column s of the selected item list – data from only one item list can be presented at one time. If the item list will display multiple rows on the report, the values of the other normal fo (...)

(...) generated Excel file – the default name of the file is the name of Data table form field, Open the Excel spreadsheet – open a directly generated spreadsheet without saving it. All column s visible to the user are exported to the file. Important! For performance reasons, a maximum of 1,000 rows can be exported from a Data table to an Excel spreadsheet.   Fig.3. Genera (...)