Tips&Tricks

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

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

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

Showing multiple "assigned to" in report

3 2

Hi, I'm seeking a hint, how to show in the table report that an item is assigned to more than one person. Has anybody an idea? When a task is assigned to more than one, it is visible in the info bar in the item form, but in the tabled report (e.g. "all open instances") it shows only one name. Is it possible to show the result of a business rule in a report? Kind regards, Klaus PS: we are using V2021

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

SQL-Query for short Workflow History Data-Source

3 1

Hi all, i thought it might be a good idea to share useful queries that should be reusable for any of us as they are. Although I personally find the built in Workflow-History very useful and really like it for admin-purposes, it might be some kind of an detail-overkill for common users. In order to give users a more simple look of what happened so far in the workflow, I created a datasource that should work for all workflows and translations. Values are shown depending on the users browser la (...)

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

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

New font 'Aptos' from Microsoft in WEBCON BPS

1 0

Dear Community, Microsoft recently announced that the new default font for Microsoft 365 applications is changing from Calibri to Aptos: https://support.microsoft.com/en-gb/office/new-office-theme-e7bbfe02-d1fb-4c4d-b3b7-6a47f0cefd3f If you already have this font on your device, give it a try in WEBCON BPS. In my opinion, it looks really good in WEBCON BPS Portal. If you want to test it, just set global CSS style in your configuration: body {font-family: Aptos} This may not be the b (...)

Generate reports - scheduled

1 3

Hello, I would like to create some daily or weekly reports based on the requests made that day/week. Is there a scheduled process that can do that? Or Is it possible to achieve this in Webcon? For example, in Power automate there is a scheduled flow that can be set to run whenever you want. Thanks.

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?

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

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

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

Calculated Columns with If conditions

0 1

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_AttDateTime3,getdate()) = 0 DATEDIFF(day,WFD_AttDateTime3,getdate()) < 0 and then divid (...)

Check status/step of subworkflows

0 1

Hello everyone, I am new to Webcon so it might be a dumb question. Anyway, I am trying to create an App where one Department starts one Workflow that creates subworkflows for several other departments. The main Workflow should be able to see the current status/step of every subworkflow. But with what I did, I am getting 2 Errors [Form] "Failed with an unknown exception Fehler-ID: d1a18cc6-c67d-43bb-b883-66e3584445e9" [] "during saga execution: Failed with an unknown exception". See the at (...)

Filter report current user

0 1

Hello, I have 2 form fields - Person (Assignee, Manager) I would like to create a report and filter that report based on these 2 columns. It is working fine, until Assignee/Manager is multiple value. If there are 2 persons assigned, it doesn't bring that instance in the report. This is my formula (SQL filter): and (WFD_AttChoose1 like trim('##currentloginname## ' )+'#%' OR WFD_AttChoose6  like trim('##currentloginname## ' )+'#%') Do you have (...)

How to prevent deletion of a inital row in an ItemList

0 1

Hi Guys, i perhaps have a simple question regarding the itemlist. We initalize the first row of an itemlist with default values in the coloums. I now would like to prevent the first row (init row) from deleting by the user. How can i manage this? Thanks so far Gerd

Multiple lines of text Rich

0 2

Hello, I have a form field - multiple lines of text (rich). When i send an e-mail, i set my form field - last entry text. If i write a text and add a new line, it multiples the number of lines in e-mail...as you can see in the attached screenshots. Do you know why is it happening? And what is there to do? Thank you.

Hotmailbox value on change

0 1

Hello, I have set up a hotmailbox - Add to elements based on e-mail content. I am saving the BodyContent to a multiple lines of text form field called BodyContent - set always. I have created a global Menu buton which must be triggered when the value of BodyContent changes. So, on the form field - Style and behavior - Form rule to be exeuted on value change - I set "Invoke menu action - my button". If i send another e-mail and i mention that Instance ID, the value of BodyContent is modi (...)