search results

(...) Hi, I have created a report, in which i am only interested in showing the Year-portion of a date time-field. This works good until i try to group for the shown values in there. The groups are not built by the years in this case, but still on the entire value. It would make more sense to group according to the display option the grouped column is set to. Especially because i dont know how to do calc (...)

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

Hi everyone, if you are going to use field references, process rules or similar in translations, these won't work once the process is transferred to another environment. See this thread for more details/images: https://community.webcon.com/forum/thread/1149 In my opinion this is an error, so I created a ticket. The answer was, that this is the intended behavior. There I'm creating this user vo

(...) How to use the mentioned function (https://community.webcon.com/posts/post/function-dictionary-for-business-rules-and-form-rules/237) without sql to get the date value for the last and the first day of the current month in the default value field of date time type attribute?

(...) Hi there, I'm trying to work out a rule to color backround of a date cell. The condition would be "if the date in the current field is greater than today, then color backround, else dont change the color". Currently the not working JSON code is: { "content": "=CurrentField", "style": { "background-color": "=if(CurrentField > today, '#FF0000', '')" } } I've also tried different va (...)

(...) Hello everyone, on one environment we are running WEBCON 2020 with SharePoint Full-Trust installation. Now this environment is to be update d. In WEBCON 2022 the SharePoint Full-Trust installation is not supported any longer. So there is the question: How do I proceed, to use WEBCON 2022 with this current installation? Is there a technical solution from you guys (webcon), to "update " the Full-Tru (...)

(...) I have update d a translation for one of the system name in Translator tool. I have exported the package and imported in test. I noticed that there is some delay in updating that. After few hours, the new language was update d in test. I have imported the same exported package in prod but it wasn't getting update d.

(...) Hi, We have update d our webcon to the latest 2022 version "2022.1.1.53 Standalone", but after update the "Generate RS Report" action is returning error while execution as below: Error in Menu button action Generate Initial Detail Report. The HTTP request is unauthorized with client authentication scheme 'Ntlm'. The authentication header received from the server was 'NTLM'. The remote server (...)

(...) e subprocesses generates correctly but there is one thing that I need to change - the author of the subprocess document should be change for the employee from field. I tried to change the login by update the WFD_CreatedBy column in WFElements table but it's not possible. I've received an error: "One or more errors occurred. Operacja została wycofana Concurrency Error Concurrency Error" In att (...)

I have a requirement to create dictionary to enter form name, Step name, no.of business days. Form name and step name combination need to be unique and a validation error message should show if the user tries to post a entry with the same form and step combination that already exists in the dictionary. I have 3 different forms with different steps in a flow. I entered 1st entry as form1, Step1

(...) Hi All I need to ask for your help :) This time I need to update permissions for tasks on separate processes/applications, not linked together. Let's say I want to give permission to read a document for some domain user or user group. The problem is that I can't modify these processes. I cannot modify data from the database side because the manufacturer forbids it :/ My idea is to create a ne (...)

Hi, I am populating 'WorkflowID population' form field based on the 'Select Marketing support' selection. Select Marketing support is basically the the type of the request. upon Marketing support selection, populating it's Workflow ID in the 'WorkflowID population' form field. Once that is populated, I need to set a default value 'Workflow name - test' form field. I have created a business r

(...) Hi folks, The "Format date " function just converts the date value into a text value. Sadly we need a date field. Of course creating extra text fields which are visible on the form which are just formatted text fields is an option. But it somehow HAS to be possible just simply set a different date format. Thanks in advance. Best regards

(...) Hi, I have a following problem. I've created a data table form field that downloads data from SQL query. In that SQL query I have a following where clause, which compares a date from Oracle table to a date from a form field that is completed by an user (it is "user's date "): "where table1.date = User's date : date acc. browser settings(text)" and it doesn't work because of different date forma (...)

(...) ange Items List action. It is defined to wait for required tasks to be completed and is tied to multiple people completing an action. But when the last person completes the action, the item list is update d, but only for the last person who completed their task. Is there any way to define the action so it update s the list for all the people who are involved in completing an action beforehand? Thank (...)

(...) Hi all! We have to update some columns in a workflow dependent on other columns from the same workflow item, e.g. WFD_AttDecimal1 = WFD_AttDecimal2 * WFD_AttDecimal3. Sounds trivial, but it isn't, especially in a SaaS system, where 'Run an SQL procedure' is missing. Another approach for us was to use 'Update related workflow instance' action, but this approach obviously leads to nowhere (may (...)

(...) Hello, I have some date set on forms. Need to find any solution to have that date - 1 month for example: date on form is (YYYY-MM-DD): 1. 2022-05-05 2. 2022-01-10 3. 2021-12-25 date that I expect need(YYYY-MM-DD): 1. 2022-04-05 2. 2021-12-10 3. 2021-11-25 Do you have any idea to solve it? My poor trying on the screen below (a lot of counting and IF's and still get wrong format of t (...)

(...) hange one of the filed value on the main workflow( on step " Wait for sub-workflows) which is displayed on the subworkflows form. When I change field value on the main flow, the same field is not update d on the subworkflows form despite it is the same field. Do you know how to update the field on the sub workflow where the same field is update d on the main? It should be 1:1 on the main form and on (...)

(...) cation. Normally the Instance number is generated according to a rule which is perfect for new files. The customer wants to keep their document numbering. For the existing files I would like to update the Instance number (Database: WFD_Signature) using a small SQL script. But is it safe and is it wise to do that? I'm aware the numbers need to be unique in the system, and I know they are unique in (...)

(...) Hi, I have a formfield where I have a starting date and I have the form field with the end date . How can I calculate the diffrence in days between this days?