WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question

Daniel Krüger (Cosmo Consult)

MVP

Hi Christian, thanks, I didn't thought of this. :) Using the option to execute business rules from form rules which is available since 2022 this could actually be a replacement for the validate form action. The condition/validation rule could be defined in a business rule or form rule. This

Hi everyone, I think it would be great to have an opportunity to add the option to execute a form rule in case of a 'Validate form' action fails. In most of my cases there some special condition which relates to a field/tab. Having the option to execute a form rule would allow to: - focus the

Hi Flo, since the column WFD_AttText1 could be the title in one process and in another a Comment, it typically doesn't make sense to do this. The only exception from this is global fields, but these should have the same meaning across all processes they would be selectable. For your use cas

Issue with License Services
10.05.2023 20:52

Thanks for posting the solution. In could help others :)

What a coincidence, I got a request this afternoon to modify a data table which displays information about subworkflows. The comments from the subworkflows should be displayed. Here's the part regarding extracting the comments and concatenating them back Best regards, Daniel ,(select STUF

Hi Michał, is the f_clear_desription a custom function? I can't find it in my databases. Have you checked whether the value is converted, when an instance is saved? I don't have a similar environment, so I can't verify it. If this the case you could use a date or alternatively you could test

Issue with License Services
09.05.2023 22:54

Hi, the license service is a part of the windows WEBCON Workflow service and needs to be enabled.. If this is the case and even after restarting the service you could take a look at the windows event log. There's a separate event "log area" for Webcon in the navigation. The events are not part

How to edit comments?
09.05.2023 22:50

HI Radek, this is simply not possible. Best regards, Daniel

Hi Damian, maybe I'm missing something at leas in my case it seems to work just fine: 1. Defined a column of type "related attachment" 2. Defined a simplified dynamic query which uses the attachment id of the parent workflow attachment. The document is referenced. Best regards, Daniel

Cloning an app or workflow
09.05.2023 08:21

Hi, Ok, let's ignore the fact that you would need to replicate any change in the cloned workflow. The cloning will generate new ids for every element. The most relevant would be - Workflow - Steps - Paths Are you using any of these information in any automation / view / data table fiel

That's an interesting idea Nik. It will probably be easier to handle any issue with the request using the PS script. I'm guessing that you pass the filename to the PS script so that you can retrieve the correct file for this workflow instance using the SDK action. Or you are passing the instance id

Cloning an app or workflow
08.05.2023 20:53

In this case I would do the following: 1) Add global constants for the Ids of the groups 2) Create a field for example "Responsible department" where those groups are used. 3) Use the field in the task 4) Add a start tile for those groups settings the id of the group as a default value. I'm

Cloning an app or workflow
08.05.2023 12:54

Hi AndreeLi, the best way would be to avoid the duplicated process, but that's obviously an answer from someone who doesn't know your use case. Maybe you could elaborate on these questions: 1. Do you only need to change the task assignment? 2. Are different privileges are assigned in the De

Hi Patryk, as far as I can tell it's somehow related to the automatic checkout of the current workflow instance to the user. I haven't seen this before so my only ideas right now are: 1) Does your account has values for display name and mail address? I'm asking this because if either is null t

Hi Klaus, the easiest option would be to use a calculated column. I have to variations for this: 1) Number of attachments (select Count(*) from WFDataAttachmets where ATT_WFDID = WFD_ID) 2) Traffic light/indicator whether an attachment exists (case when (select Count(*) from WFDataAttac

Item list in email
02.05.2023 21:23

Hi Andree Li, reading the text I don't really understand it either. Maybe the example in the help file F1 is more useful as you can copy it. Just search for SQLGRIDHEADERTEMPLATE The most important information is that you can reference a data table in a html template using {SQLGRIDROWTEM

Hi, the underlying reason was that the SQL statement compared the id of a picker field against an instance id. So far so usual. Somehow the customer was able to save a value in the field which did not contain the the id. This caused the problems. No, the field did not allow to save values w

Hi everyone, I was working on a process and out of the blue I receive the following errors: In BPS Portal / testing a data table: The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction In the event viewer there's the

Distinct values
28.04.2023 08:52

Hi Andree here's an example to filter a data source. I don't know whether your company is a business entity or a normal field. In your case you would have a field or a business entity in which you selected the Company. In the project field, you can use the value to filter the available ones.

Hi Andree, the view depends on the "location" from which you opened the Expression Editor. Not all functions would work in all areas, so those which won't work are hidden. Based on the displayed functions it looks like you are in picker/data source and have the option to filter the data. If