Daniel Krüger (Cosmo Consult)

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

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

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

Hi, if there are not to many rows in the Excel file I would do the following in a "Processing" workflow. Since I'm not sure how many workflows would be created/updated I would do this in batches Step 1: Import the rows two an item list Paths "imported", verifies whether there is already a

I'm quite sure there are at least two related posts. One from Encorsa and from me. The one from Encorsa was also about doing this automatically via / api. I would like to have this option yesterday when I published a application to 7 environments. :) My addition would be: - to define a confi

Hi Flo, I should have added a screenshot in the first post. :) The screenshot shows the Behavior "Form rule to be executed on page load". Multiply form rules are executed depending on the current step. The used form rules always checks the condition (field value) and either hides or shows t

Hi Dariusz, we used also an Employee file. There was an "holiday leave limit" item list but consist of the column Year, Days from previous year, Days current year, Extra Days This was updated only when something happend to the limits or when the next year item list row was created. Of course

Hi Björn, I was actually able to do this. The following works in 2022.1.4.155. It could be that the ids/classes of the elements are different in your version. $(".fileinput-button")[0].children[0].click(); setTimeout(() => { let select = $(".addWithCategoryDropDown")[0] // https:

Hi Flo, I'm using a similar approach. 1. Using the form field matrix to define which fields should be visible in general. 2. Create a form rule. 3. Use this from rule in the "on value change" 4. Add this "Main form" Behavior" tab and add "if (step =1) then ExecuteFormRule". I don't like

Hi Bo, these are the chapters of our documentation to restore a production database as a formal test environment. I have to ask permission to provide any more information as I have done this during my "working time", whatever the actual term is for this time, when I'm doing something for which I

Hi Flo, in this case I would do the following: 1. Create local parameters for mobile and info AD property in the automation, this can only be done inside the for each. 2. Clear the values of both parameters 3. Add the if condition as you described and set the appropriate value. Execute th

Hi Marcin, it's for sure a bug, or a "glitch" which may happen but it's fairly unlikely to reproduce it and therefore to fix it. At least I didn't encounter it only once. Or better, a colleague reported it to me and I "fixed" it. Since I wasn't able to reproduce it I didn't report it. Be

Hi Marcin. I think I had a similar error message and I had to manually modify the data in the database. The order of the form fields in the placeholders ist stored in the table WFStepFormFields. In my case two fields shared the same value for FLD_Order. I changed the value and for "safety" mea

Hi Flo, maybe I'm missing something obvious to understand your issue, because I really can't wrap my head around what you want to do or why there should be an issue. Of course I don't have your actual workflow but even with the simple mail example I don't see any problem. I've created a simple

Hi Flo, maybe these information will help you: The numbers refer to the number in the screenshot In the for each action you can select different types, in my case the item list is unfortunately called "Item list" (1). In the for each action you have access to the columns/fields of in each ac