Tips&Tricks

How to present field 'Picture' on dashboard

0 5

Hello, Question 1: Is there any possibility to give user access to form but restrict/limit form history (only user have access to current form not for previous versions)? Question 2: I have form field 'Picture' in dictionary form which (that form) is connected with user by field 'User' - do you have any idea how to present that picture on users dashboard? Do be clear: Form 1: Field User: X Field Picture: A Form 2: Field User: Y Field Picture B On dashboard User X (...)

Delete comments

0 4

Hi, Is there any way to remove saved comments from an element? I would like to use the native comment field, but I need to delete the old comments in a certain step. Is this possible, or should I use the AttLong attribute instead of the native comment field? Best regards, Bartek

Exporting SQL data rows from within the designer studio

3 0

Hi everyone, I just had the need to get multiple rows of data without having access the the SQL database. I didn't want to create a field for this one time use case. Unfortunately the 'Test' result window of the expression editor, didn't have the option to copy the result. Luckily I thought of the Administration Tools\Search Logs. As you can see in the attached picture, I was able to execute an arbitrary SQL statement and could export the result to Excel. :) Best regards, Daniel

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 (...)