Tips&Tricks

Calendar report view

0 0

Dear All, is there any possibility to display report as calendar type, but with 12 months, as full year view? Currently we only see option to display one month (largest one). Thanks for any response here. Best, Adam.

Data table filed - rows coloring

1 3

Hi, Do you know how to make rows in a 'Data table' field colorful? I get some data from subworkflows by the table field and I want to color some rows depending on their status: open - blue, closed-green ... Is there such posibility?

Adding process fields into the task card

0 7

Does anyone know how WEBCON did this on their support portal? Lots of custommers asked us to add form fileds in the task cards, but I thought it is not possible.

Changing text field from "local" to global field

2 0

Hi everyone, this is just a short list of actions I had to do, when I switched from a "local" text field, WFD_AttText1, to a global WFD_AttText1Glob: 1. Fixing Start Subworkflow actions Due to the change of the field type the assignment was "lost". Internally the action uses the database name, so it's obvious, that the assignment of field {690} to field WFD_AttText1 is no longer valid. Configuration after correcting the assignment <field> <attribute>WFD_AttText1Glob</att (...)

Outlook Addin: Create test mail with custom from address

0 1

Hi everyone, I have the following use case for a customer: A workflow should be started from Outlook using the (full) Addon. Based on the from address some more information should be retrieved from a custom database and populate other fields. So far so easy, at least in the dev system where I can modify the data in the custom database. This is where my problem/the question starts: Does anyone have an idea how I can change the stored from address in an msg file/mail? I will ask the custom (...)

barcode unique across application?

0 3

How make sure that field with barcode is unique across application?

Hyperlinks in Item lists

1 1

While trying to cope with problematic hyperlinks to different items in one item list row, I came up with a solution that might come in handy. Explanation: The item list contains one key choice field ("Symbol") which is configured to populate several other fields in the list. Among the populated fields are "Przypisane komórki (BPS)", "Przypisane garaże (BPS)", "Przypisane miejsca postojowe (BPS)" - these are choice fields in read only control mode (technical fields actually). There are rules (...)

BPS 2022: Enable IIS feature "Dynamic Component"

4 1

Hi everyone, WEBCON BPS 2022 has a new IIS requirement "Dynamic Compression Module". You can enable this by executing the following line in PowerShell: Enable-WindowsOptionalFeature -Online -FeatureName IIS-HttpCompressionDynamic Now I'm back to testing the new version. :) Best regards, Daniel

Executing a form rule via JavaScript in all environments

1 0

Hi everyone, experienced BPS Designers will remember a time when form rules didn't have an 'Edit mode', where you could select JavaScript or Form rule. You only had JavaScript. :) In the meantime the 'Form rule' option has been added an the JavaScript mode gets little attention, if at all. But how can you do some of the 'Form rule' actions with pure JavaScript? If you click on the "Show" button in the expression preview you will the JavaScript representing the graphic rules. In my case I want (...)

Business rule: Calculate new date respecting the working day calendar

2 0

Hi everyone, I had the requirement to calculate a reminder date based on a due date. This should be x days before while respecting the working day calendar. SQL Command for calculating a date _after_ the base date, attachment (1): select Top 1 [CAL_WorkingDate] from ( -- Top: number of working days before the base date SELECT TOP {BRP:13} [CAL_WorkingDate],[CAL_IsWorkingDay] FROM [dbo].[Calendars] where [CAL_WorkingDate] > '{BRP:14}' and CAL_IsWorkingDay = 1 orde (...)

SQL command: Populating a multilingual choice field with form type names

4 1

Hi everyone, I had the requirement to provide a drop down which can be used to select a form type. Since I'm a fan of doing things the right way I've chosen to provide a multilingual label. Example: TMeasure$$de$$Maßnahme$$en$$Measure I'm not sure whether I'm missed something because of the late hour, but I didn't found a better option than creating this on my own. If someone else has a similar need, either selecting form types, workflows or whatever this command can be used as a template: se (...)

Change Business Entity

0 2

Hello everyone, in a webcon environment I currently have two business entities (ID 1 and 4, see the attached screenshot). From now on I only want to use the entity with ID 4. Is there a known way to migrate all existing instances from ID 1 to 4 so I can delete the business entity with ID 1 afterwards?

the ability to change the label of the company selection control

0 1

Hi, Do you know any trick, how to change the label of the company selection control on the form, from "Company" (Wybór spółki) to f.in. "Organizational unit"? Thanks in advance. J.

On change Value on Choice Field

0 1

Is it possible to change a choice field to empty when the option picked has no exact match in the option set/ data? If yes, how is that done?

SQL statement to verify that all actions are logged

1 0

Hi everyone, I just stumbled about an action which executions hasn't been logged. The reason is simple, the according checkbox wasn't ticked. If you want to verify that all you actions are logged you can run this SQL statement. It displays all actions which aren't logged. Maybe for a reason or due to some misconfiguration: SELECT AGR_Name, APP_Name, DEF_Name, WF_Name, STP_Name, ACT_Name FROM [dbo].[WFActions] actions join WFSteps on ACT_STPID = STP_ID join WorkFlows on STP_WFID = WF_ (...)

Form: Changing left/right layout from 50%/50% -> 75%/25%

9 0

Hi everyone, this is just a simple JavaScript which changes the assigned space of the left and right panel from 50% for each to 75% for the right and 25% for the left. The JavaScript can be copy&pasted into a JS Form Rule (1) which gets added to Behavior tab (2) so it get's executed. window.ccls = window.ccls || {}; ccls.changePanelWidth = {}; ccls.changePanelWidth.execute = function (timeoutCounter,timeoutMax){ var items = document.getElementById("RightPanelOuter"); // verify th (...)

Q: How to open a link in a DATA TABLE in the same window ?

0 3

Hi there, while starting a new instance, i am giving the users the ability to make a save for the moment (caching all inputs so far), so they could finish the instance later. If the user wants to start that instance again, all input fields are invisible and a DATA TABLE shows the already started instance including LINKS to that instance. I would like to have that links opened in the existing window, but i dont find a working way to configure that. Every time a new windows is opened. Anyone a (...)

Attachments collapsed by default when entering the form

0 1

Dear all is possible to set that the attachments area will be default collapsed when opening the form?

Bug when using target fields in picker as item list column?

DONE 4

Hi, we recently upgraded our DEV-Environment to latest 2021.1.2.136. Today i was evaluating the new version with our existing processes, and stumbled upon something that didn't occur to me in the past. I have a crucial picker field in an item list, that has target fields from some of the columns in that same item list. It works in our current PROD version (2020.1.3.411). In 2021 it throws: "Sequence contains no matching element" - Error, and the value is not transferred into the target (...)

Changing Business Entity

0 1

Dear all, what would be the best practice to update/change the Business Entity of an instance? Background: I would like to create an application containing people related to a company respective business entity. Over the time it is possible they would change the company and so also the business entity. I found a dirty way by using an SQL Update directly on the WFElements table, but I am struggling by running this query by (cyclic) action on a separate path. The path is walking through fine ac (...)