(...) dd new elements to the indicated list. Select the connection and list address, and choose how to add elements: Static - in this mode, fields from the workflow form should be assigned to the column s in the SharePoint list, Dynamically - in this mode, you should define a SQL query. It will return column s with the same name as the SharePoint list column . Fig.6 Configuration f (...)
(...) default form field name with the xlsx extension. Fig. 3. Import and export button visible on the form field Open the downloaded file – regardless of the number of column s defined in the item list form field, the data export applies only to the column s that are visible on the form. column s hidden in a given view will not be exported to the Excel file. Im (...)
(...) When you go to the next screen, you will see applications and processes that will be imported. You can import everything or choose what you want to import by checking boxes in the "Import" column . In the "Changes" column , there is information if there were any changes (then it shows "New") or if there were no changes ("No changes") in the applications or proc (...)
(...) nel Fig. 3. The All users tab The WEBCON BPS users list contains both users synchronized with the internal user database and external users (“Type” column ). The list of users synchronized with AD comes from Active Directory and is completed after each synchronization. In the case of WEBCON BPS Cloud, the users list administration tab is also used to ma (...)
(...) Fig. 5 Administrator preview You can search for recorded sessions by a session identifier, user identifier, or time interval. You can also sort the column s by a user identifier, date, or session identifier by left-clicking on them. Fig. 6 Searching for a session Login details Below is a simple example of how you c (...)
(...) l to the value declared as the maximum requisition value a given supervisor can accept. For the condition to be considered fulfilled, it must return “1” or “True” in the first column , in the first line of the query response. Let us comment on the function in figure 12 now. The value “Limit” reads the approval limit set for the superior who is being checked at the (...)
(...) re the dashboard – click the “+” symbol and select the section layout. Fig. 3. Adding sections to the dashboards In our case, the "One-third left column " option will be selected. In each section, you can select the “+” symbol and add a widget in a given place. Fig. 4. Adding a new element Elements that c (...)
(...) D. The value will be passed on from the promotion process. Initially, the tags that are already registered will be locked for editing. However, we cannot make the “Tag’s name” column read-only in the Field matrix because we will still need to add new tags. Therefore, the list in the Modification step should look like in figure 3 below. The first two lines have been added earlier, (...)
(...) . Statistics at "Acceptance I" step In figure 7, you can see instances’ time in step and edit time for individual employees, the average time, and the trends. The "Trend" column tells you how the column s' value has changed between the previous month and the current month: Shorter time than in the last month. Comparable time to the last month. L (...)
(...) f behaviors for an employee: Fig. 1 - Sample behaviors and attitudes To create such a list, you will need a simple two-step workflow and a “List of behaviors” item list with two column s – The occurring behavior and Not active. Fig. 2 - The “List of behaviors” workflow If the superior's competencies are assessed differently than those of the employee (...)
(...) ins the "Data" group where you must select the entry that should be updated. The entry is selected based on the "Industry" and "SIC_1" choice fields corresponding to the column s in the data table with the same names. It is possible to update data in the following fields – make changes and click "Update." Fig. 3. The fragment of the UK Jobs Change Upd (...)
(...) hould be shown on the report. The condition should be entered after the keyword AND; for example, AND YEAR(GETDATE())=2021 Fig. 6 Mandatory filters configuration Click on the tab “column s” to select which column s should be used in the report. System column s are displayed by default. You can add column s with form fields that are a part of the process and the workflow. You can al (...)
(...) ; 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 (...)