(...) Hello, I need to set up two columns to calculate some KPIs for a report. The first one will show the status based on Case statement and date difference: (select case when DATEDIFF(day,WFD_AttDateTime3,getdate()) >0 then 0 when DATEDIFF(day,WFD_AttDateTime3,getdate()) = 0 then 1 else 2 end) The second column should pick the number of instances that have the conditions DATEDIFF(day,WFD_ (...)
(...) Hi, I would like to propose the ability to use HTML formatted text in calculated columns of reports. Now HTML tags are displayed as plain text, e.g. we can use only one link in row or not able to split/format text into lines. I remember that there was such possibility in Sharepoint reports and I miss it :)
(...) Hi, I propose to unify and add a visibility option available on the standard attribute ‘Visibility on report independent of visibility on form’ to the visibility option on item list columns . Regards.
WEBCON: Business Process Automation and Management as its best WEBCON develops the Low-Code Business Process Automation Platform, WEBCON BPS (Business Process Suite). This enterprise-grade system allows organizations to embrace digital transformation by digitalizing their workflows and building comprehensive, scalable, process-centric and future-proof applications applying t
(...) mber Demand in person-months -> testing Floating-point number Demand in person-months -> marketing Floating-point number Personnel Item list with columns as in Fig.2 Personnel -> development Item list identical to Personnel but with a filter on the data source and visibility only in the delegation step from the Development departmen (...)
(...) ble with data from the form. Configuration The first field to define is the Item list. Fig. 2. The item list in WEBCON BPS Designer Studio Then, add four columns containing the order data to the list – two of them are choice field type, one – text field, and one – date. On the form, three rows showing the orders have been added: (...)
(...) ’) Assigned to the same category/task type (Task type) In the WFElements table there are workflow instances from all processes so you must add the conditions for the individual columns : the WFD_STPID column contains information about step where the form is located, and the WFD_DTypeID column defines the form type (the form type ID). For more information about th (...)
(...) modified field value from an existing document In the choice field configuration (Autocomplete and Pop-up search window) there is the ability of transferring values from the data source columns to the fields indicated on the form. The limitation of this solution is the ability of transferring only the exact data that is in the source. If you want to modify data to be transferred, use the SQ (...)
(...) eById – comparing identifiers pickerCompareByName – comparing names Each function takes a variable that refers to the picker column or one of the special system columns in their first argument. The second argument is a string of the id#nazwa form. When it comes to picker fields in multiple choice mode, these values should be entered after a semicolon e. (...)
(...) mation about tasks in the appropriate database table – WFElementTasks. By querying this table and narrowing it down to the instance ID (from the example), you get the following result (selected columns were downloaded in the query): Fig. 9. The table contains information about tasks in the system The WFT_FinishedByAdmin column informs you that the task has been comple (...)
(...) the list of the signed people to which the Signing URLs of the signed people will be saved e) Recipients selection Signer Item List – a list of signed people, must contain columns with name and surname, e-mail address and phone numbers Issuing Country – country code of the signed people without using a Skribble account (example: PL), required only if the SMS verificati (...)
(...) eated in DocuSign will be saved. Fig. 6. The configuration of the action In the next fields, enter the title and content of the e-mail sent with the attachment, indicate columns of the item list where information about the document recipients is entered on the form. DocuSign allows you to send several documents to sign – they are sent as one envelope so all of them mus (...)
(...) Fig. 1. The name view for the selected process is created from their name and the ID number Fig. 2. The process based on the view from Fig. 1 The view displays data from the columns which are present by default for each process, and additionally from the columns that store the selected form field values created in the process – in the number corresponding to the number of (...)
(...) eld Fig. 5. The name above the text field Data row In the “Advanced configuration” of these form field, we manage the way of displaying the selected columns . Next to the “Display name” header there are new options do select: Indicator field – displays the numerical value in the form of an icon with different colors: by less than (...)
(...) view of the process workflow on the mobile devices. Reports and dashboards The new way of displaying reports allows to select defined views and also change the displayed columns and edit reports directly on the mobile devices. New to the mobile application is the ability of displaying dashboards. Dashboards containing reports, charts, start buttons and other elements are ava (...)
(...) e data row form field Knowing of which companies are in arrears with payments, you can add these companies to the “Contractors with arrears” item list. A list consists of two columns – contractor name and their debt. The contractor is selected from the dictionary and the arrears column is a data row configured in the same way as it is shown in Figure 6. For each of the c (...)
(...) a BPS workflow. Read this article if you are interested in SharePoint workflows made easy by using WEBCON BPS. Preparing the document library view Additional columns have been added to the standard view of the document library: BPS URL – hyperlink column which stores the workflow instance address Status – text column which stores the current w (...)
(...) a database configuration, while the “WFAttachmentFiles” stores the attachment files. Fig. 1. Construction of external attachments database The most important columns 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 ID (...)
(...) 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 columns 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 hav (...)