Tips&Tricks

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

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

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

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?

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?

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

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

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

Assign worklof as child

0 0

Hi, I need join new started workflow as child of exist workflow in other aplication, i would like to know is it even possible?

Migration of completed projects from Sharpoint to Webcon 2022

0 0

Hello. Have any of you done archived (completed)process migration from Sharepoint? Are there any built-in solutions? I would appreciate for any hints.

Moving Comments /Attachments to a Tab

0 0

Hi everyone, does anyone has an idea /have a hack to move the attachments / comments option to a tab? I'm currently trying to create a form, which should: - look good or at least ok - be usable with a big multi line text box - while using the task "view" and displayed info panel - has to compete with a paper based process with an arbitrary number of steps and options to write any information on the paper Best regards, Daniel

Filter on Date in Item LIst

0 0

Hi, I have an item list with a "date" column. I figured out that filtering (or even showing it in a customized date format in a data table) is tricky as the daty type of the column is actually nvarchar(1000). What I want to reach is to filter the data table based on a "date picker" field, but I don't manage to. Kind regards, Klaus

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.

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

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