Tips&Tricks
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 (...)
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 (...)
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 (...)
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
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.
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 (...)
Hello everyone, i am searching for a tip / need a helping suggestion. ๐๐๐๐๐๐๐๐๐ ๐๐๐๐ > ๐๐๐๐๐ > ๐๐๐๐๐๐๐ ๐๐ ๐๐๐๐๐๐๐ ๐๐๐๐๐๐๐๐๐ https://community.webcon.com/posts/post/preview-of-related-instances/47 (see attached picture) "๐๐๐ ๐ฅ๐ง๐๐ซ๐๐๐ฌ ๐ฌ๐๐ฃ๐๐ค๐ฌ ๐๐ก๐จ๐ค ๐ฌ๐ค๐ง๐ ๐จ ๐๐ฃ ๐๐ค๐ง๐ข๐จ ๐ค๐ฃ ๐๐ค๐ง๐ข ๐๐๐๐ก๐๐จ ๐ค๐ ๐ฉ๐๐ ๐๐๐ฉ๐ ๐ฉ๐๐๐ก๐. ๐๐๐ ๐๐๐๐ก๐ ๐๐๐๐๐ฃ๐๐ ๐๐ฃ ๐ฉ๐๐ ๐๐ค๐ง๐ข ๐๐๐๐ก๐ ๐๐ค๐ฃ๐๐๐๐ช๐ง๐๐ฉ๐๐ค๐ฃ, ๐ฌ๐๐ก๐ก ๐๐ ๐ค๐ฅ๐๐ฃ๐๐ ๐๐ฃ ๐ฉ๐๐ ๐ฅ๐ง๐๐ซ๐๐๐ฌ ๐ข๐ค๐๐ ๐๐ฎ ๐๐๐๐๐ช๐ก๐ฉ." ใ๏ปฟ๏ผฑ๏ผต๏ผฅ๏ผณ๏ผด๏ผฉ๏ผฏ๏ผฎใ My question is: When PREVIEW-MODE is BY DEFAULT, is it possible to enable full (...)
Hello everyone, How can I find out more information about the cause using an error ID? Where can I enter the ID in the Designer Studio to get to the form field that is causing the error? I tried to adapt a data source to a "data table" form field because not all existing values โโwere displayed. Now I always get the error "Failed with an unknown exception Error ID: 6f351188-04d9-4049-bd2b-d3da66c64976" Unfortunately the error code doesn't help me understand what exactly happened... Ma (...)
Hi there, I have following idea and search for a solution: I have an items list; now in case a certain field is changed, I want to write the "old" value before the change into a different column of this itemlist row. Any ideas? Kind regards, Klaus
Hello, I have an application that creates a folder within a document library on SharePoint and needs to upload files to the newly created folder. I am encountering difficulties in uploading the file to SharePoint using the REST action with the Graph API. I get this error: "Invoke REST Web service test (2) - Request Url: https://login.microsoftonline.com/f656719a-4d1c-482b-be59-564f8c2af72d/oauth2/v2.0/token Response Code: Exceptions: Cannot add value because header 'Authorizat (...)
Hello. I have a "Invoke REST Web Service" GET action. I would like to save a part from response to a field, more specifically an ID. I have tried multiples methods, but i did not success... This is my response. How can i save the "value/listItem/id" to a field? (id=318) { "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#sites('test')/drives('XNOnVydrSL6yetalE8-T')/root/children(listItem())", "value": [ { "createdDateTime": "2024-01-15T16:28 (...)
Hello, I have an equipment initialization process (1) , followed by another process of allocating this equipment to a user (2). I have created a Report - "Equipment allocation" and I want to add a calculated column to this report that brings in the "Series" of the equipment from the Initialization process. I have this query: (select dbo.ClearWFElemAdv(WFD_AttChoose2)[which is the "Series" column in process (1)] from wfelements where wfd_dtypeid=102[which is the form id of process ( (...)
Hello, I have 4 HTML fields (Categories) and one Choice field (Projects), and I would like to place some hyperlinks on HTML fields that start a new instance. Can I set 'StartElement' function on this HTML field so it can define other parameters that should auto-fill in the instance? For example: I choose a project, then press a 'Category' button (one HTML field) that will start an instance, and in that instance, the project and category should be auto-filled. I have already checked th (...)
Hello everyone, it seems that in a report, you can only drag columns from one items list. If I try to add a column from another items list to the report, I receive an error message " Error adding items list column - There are already selected columns from items list ...." We need a report that combines columns from various items lists. Does anyone know how to solve this problem? Thanks Lina
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 (...)
Hello all, Does anyone know if it's possible to have the behavior of Invoke Menu Action - Create new process using Hyperlink, where the request that we configure open automatically in a new tab but instead of using Hyperlink, the system is launching a subworkflow? Thank you
Hi, I need join new started workflow as child of exist workflow in other aplication, i would like to know is it even possible?
Hello all, I'm trying to set up a calendar with a dynamic condition that will set the color of each instance taking the difference from a date field when comparing with Today's date. Does anyone knows how to set up something like this? Thank you!
Hello all, Does anyone know if the calendar can be configured to only show business hours in Week mode? Thank you!
Is there a way to have more control over the styling of the forms? For example - how to change the color of disabled fields or how to remove or change the border of inputs.
+48 12 443 13 90