search results

(...) e of cells, add images etc. In the configuration below you can add a text to the cell with its border.     The report view:     In another example, an express ion with the ‘if’ function has been used, depending on the value in the cell, its color and background color will change and also the appropriate icons with different styles are added. The (...)

(...) r the simplest and most compact WEBCON BPS configuration, one may use a single machine with the following software: Windows Server 2012R2 or newer SharePoint Foundation 2013 SQL Server 2012 express with Advanced Services (Full Search component is necessary) Configured Active Directory service Diagram of „all-in-one” WEBCON BPS installation Hardware requirements for suc (...)

(...) ance. This prevents incorrect instance number creation.   Instance numeration In the “Instance number” field there is a list of instances (Fig. 6):   Fig. 6. express ion edition   In addition to the previously described numbering within the current year, WEBCPN BPS also offers numbering within the month, days, “Date and time” form fields typ (...)

(...) ocument templates process – use the template added to any instance. In the simplest configuration it will be the instance in which the action was used. You can select a category or regular express ion to select a document to be used as a template.     The third method is to create a document template (dictionary) process. In version 2020, this can be done automatically (...)

(...) . Value – this field defines the value set after execution of the action. In this field you can use all functions and form fields available for business rules e.g. arithmetic operations, SQL express ions and form fields available on the form. Error message – this field defines the error message displayed when there is a missing value error. It is recommended to set a custom error messag (...)

(...) p;   Adding the form rule triggered on a button To properly configure the form rule invoke on the form, go to the “Advanced settings” tab of the HTML form field and open the express ion editor (three dots). The rule should be added between the quotes of the express ion onClick = ”” (Fig. 5).   “MoveToNextStep” form rule invoke The “MoveT (...)

(...) r all attachment assigned to the instance are to be selected (Fig. 4).   Fig. 5. The constant item list as a data sorce for the attachment category list   Regular express ion – attachments are filtered based on the regular express ion; in this case, all attachments with names beginning with PO and Purchase_Order will be selected.   Fig. 6. The re (...)

(...) n" field and then the "Business rules" field. When the new screen opens, click the 'New rule' button.   Fig. 8. Adding the business rule   Then in the express ion editor, select the “SQL COMMAND” and create the SQL query referring to the element and save the rule.   Fig. 9. The configuration of the business rule   You c (...)

(...) ther systems. You can use the IIS server module called URL Rewrite. It allows you to create advanced rules that will redirect the user to the new portal address. Rules are created using regular express ion   14. Changing an entry in DNS After completing and verification of all steps, change the entry in DNS and redirect to the new WEBCON BPS StandAlone environment.

(...) e form field name displayed on the form and the appearance of the form field value. The “Regex validation” section is visible only for the text form fields. You can define the regular express ion that validates values entered in the value field. In the “Behavior” tab, you can decide if the form field will be a technical or archival field. In the “Personal data sto (...)

(...) p; You can dynamically display the values from the form in the “Message for validation error” and “Message for successful validation” fields – just add them using the express ion editor (…).   Fig. 5. The express ion editor   The example message for validation error:   Fig. 6. The error message   In the case of conf (...)

(...) its color because the SQL / CAML query is performed for each row. The query must return a hexadecimal color. When you write a query, you can use the tags from the form field search window in the express ion editor.   Look at a sample query: Fig.3 Sample query for coloring the entire row   The effect of the query: Fig.4 The effect of applying the full line color (...)

(...) /db/1/app/13/start/wf/8/dt/8/form?AttText1=Build the new reports for Q3 2020&PARENT_WFDID=7&AttDateTime1=2020-08-05T00:00:00&AttChoose2=4#Reports&AttChoose1=1#High   The express ion has two parts. The first part starts with the database ID (/db/1), then there is the information which application should be started (app/13/start). After that, the express ion tells which process (...)

(...) he workflow instance, The oldest attachment - the action will add a single attachment (the oldest one), The newest attachment - the action will add a single attachment (the newest one), Regular express ion - allows you to select an attachment using a regular express ion, SQL Query - allows you to select an attachment with a SQL query. The query should return a list of attachment IDs from the dbo. (...)

(...) to based on the attachment from the form. In our example, we have configured the action to place the user picture in a category named "User photo."  However, you can also use a regular express ion or SQL query to indicate where it should be placed. The photos created must be saved in an appropriate format (JPG, BMP, PNG, GIF), have a size not larger than 10 KB, and their resolution cannot e (...)

(...) f the meeting (date and time), and end of the meeting (date and time). a) The Year form field (single line of text) – in the “Style and behavior” tab, you can add a regular express ion that allows adding only four numbers in this field. Fig.6 - The configuration of the Year form field b) The Employee and Superior form fields (Person or Group) – after select (...)

(...) query – the SQL procedure invoked by the above action on the database. It allows you to enter data from the form into the database. The variables from the form were added to the form using the express ion editor. It is possible to enter subsequent entries in the EMSI_JobChange_UK table without the need to have direct access to the database. Fig. 8. The procedure for entering data fr (...)

(...) r the simplest and most compact WEBCON BPS configuration, one may use a single machine with the following software: Windows Server 2012R2 or newer SharePoint Foundation 2013 SQL Server 2012 express with Advanced Services (Full Search component is necessary) Configured Active Directory service   Diagram of „all-in-one” WEBCON BPS installation Hardware requiremen (...)

(...)   This rule contains the “Data source value” function with the following configuration:   Fig. 5. The business rule returns the exchange rate of the source currency express ed in euro   Finally, this function returns EUR 1 express ed in the source currency. In the function configuration, indicate the data source of the rule (the query to the currency table crea (...)

(...) ng processes thanks to which the created solutions will be more understandable, less sensitive to change and, consequently, more reliable.   Use of Tags Tags are elements used to create express ions (SQL, CAML, JavaScript) as well as Business Rules and Form Rules. The tag represents a specific value of a specific object in the system, e.g. the value of an attribute. Tags in the case of SQ (...)