forum

Filter function in the report for calculated columns (using substring) no longer works after update to version 2021.1.4.36

2

We get an error message by using filter function in the report for calculated columns (using substring). I use the following formula. SUBSTRING(WFD_AttText8,1,2). The report view shows the correct values in the calulated column. As soon as I want to filter this column, I get an error message. Does anyone else have the problem or am I doing something wrong? Best regards Nancy

Documents are checked out after uploading into SharePoint List

0 2

Hello everyone, I have an action where I upload one or multiple attachements (PDF) to a SharePoint list in SharePoint Online. Currently all attachement uploaded to the SP list are checked out. Is there a known configuration in the action or in SharePoint? Or has anyone else had a similar problem? Best regards, Tim

Adding Attachments to the form not working anymore before Instance is saved

7

Hi, we just updated on Friday to Version 2021.1.4.36. Just now a user called and showed me that she is getting an unknown exception error when trying to add an attachment to a manually created new instance. She has the rights to do so, and can add attachments as soon as the instance is manifested in the DB through save button that directs to the same step. So there is a known workaround, but it would be nice if this got fixed. I as an administrator can still add attachments before saving th (...)

Word add-in formatting

0 1

Hello, has anyone stumbled upon a problem with the formatting of numbers in Word templates after the upgrade to version 2021.1.4.36. I was using formatting of numbers with thousand separators, which worked fine with version 2021.1.2.101, but after the upgrade, instead of numbers, the field name is present in the output. When I leave the formatting with \* MERGEFORMAT, the values are transferred into the document. Did anyone else notice the problem? Best regards Aleš

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?

Possibility of using two form types in one workflow to rearrange form fields for one step only

0 3

The structure of the form fields does not suit one specific step in a workflow. How could I rearrange the form fields for this one step?

DASHBOARD: How to use REPORT TILES in HTML code ?

0 0

Hi everyone, while designing a new Dashboard for my latest application, i am wondering wether it is possible to use the REPORT TILE logic in HTML, so i could optimize the free space usage (eg. a two column table for 2 report tiles instead of two seperate report tiles). Does anyone of you managed this already? Thanks for your help in advance, Bjoern Poller

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

Stored Procedure as Datasource

0 2

Hello. Is there a way to use a stored procedure as datasource instead of a view or table or Select statement? I use at the moment a query on two tables (UNION) which has an inner join on another table. The speed is not really breathtaking, thus I wanted to use a stored procedure where I can perform all the timetaking steps already on the SQL server. Regards Klaus

Attachments in dictionaries

0 4

Hi everyone, Is there a way to add attachments to dictionary process type entries? I only need one attachment per entry and if this will not be possible, I will have to redesign the process to the standard version.

How to create required parralel tasks?

0 1

Hello all, my first post here. :) I have an issue with creating parralel tasks that should all be required. The user has 3 checkboxes on the form. Depending on which of them are checked, there should be created a specific task for each in a single step. The tasks are being created in the action of "Approve" path of the previous step. It's all fine for now. (ex. if (checkbox1) -> create Task1 etc.) The problem is, before moving to the next step all of those tasks should be completed. Instead (...)

How to relate Subworkflow which is Parallel and not Child

0 3

Hello all, First of all I would like to thank you for taking time reading my post! I'm working on a current process where I need to trigger many subworkflows to request information for the main one. Because the main one will keep being edited after the subworkflows are launched, I've decided to set them as parallel. They will be started through a item list and after one person for the task is selected in that item list. This is bringing me many issues and challenges. First of all, (...)

Raport Export to Excel

1 0

Hello, I made a report in WEBCON Designer Studio and one of the columns is "Link". However, when I export that report to excel, that column is converted to a simple text (not a link). Can I in some way configure it to receive in the exported excel that column as link? Best regards, Vitalii Lukash

Check Users defined in Business Rules

0 2

Hi all, I'm implementing an application for user management taking the guide done by Webcon: https://community.webcon.com/posts/post/checking-user-and-group-privileges/258/3 So far, I'm able to check Applications and Processes privileges but when it comes to the Business Rules, I get an error for the column they use as Users (users . BRD_Users) : select users . BRD_ID , isnull ( DEF_Name, '<Global>' ) as DEF_Name , usage. BRD_Name , usage. BRD_Documentation from WFBusinessRule (...)

Default value does not cause entering the values from the columns into the target fields

0 0

Hello everyone, After updating to 2021.1.3.205, I noticed that setting values from available columns to target fields, stopped working when the field is initialized with a default value. Setting the value only works when I manually change the value in the field. I have not noticed such change in changelog (but maybe it is), so I wonder if maybe it is a bug? Maybe some of you have noticed such a change, or encountered the same problem? EDIT: Since I was testing mostly on the default value of the (...)

[SOLVED] ITEM LIST: Generating clickable link from column of same row -> How?

0 3

Hi there, i am struggling with generating a clickable link from column of same row. I would like the user to enter a link in the column LINK and a clickable link should be generated in the next row column (LINK-TEST) on every value change (see attached picture). The perfect way would be a little HTML button, so i should be able to set the "[TECH] angeschaut" checkbox when clicking. What i am searching for: 1) a way to implement EMBEDDED HTML with usage of row value as parameter OR (...)

Hide history of an element/task from a specific group of users

2 0

Dear Community, is there any method to hide history of an element/task from a specific group of users? KR, InnFlow Team

Any option for getting next tasks assignments?

0 2

Hi everyone, does anyone have an idea whether it's possible to retrieve the users to whom a task will be assigned in the next step? What I've tested so far: - Verified that the variable 'System fields\Assigned persons' contains the current persons during path transition, exit and entry. - Created an SQL statement which returned the latest row from WFElementTasks, and executed this in an action during path transition, exit and entry. They all returned the old row. - SDK object RunCustomActionPa (...)

Grouping in reports

DONE 2

Hi everyone! I wonder if anyone noticed in their enviroment a rather unwanted and dangerous behavior of grouping in reports. Today an acountant showed me, that when you apply grouping something really strange happens (ver. 2021.1.3.205). As seen on the attached screenshot the number of items in grouping is different than the one shown in the rectangle. This can be very misleading. And there is something even dangerous - in the ungrouped report I see some item that don't even show on the grouped (...)

Form: Changing left/right layout from 50%/50% -> 75%/25%

9 0

Hi everyone, this is just a simple JavaScript which changes the assigned space of the left and right panel from 50% for each to 75% for the right and 25% for the left. The JavaScript can be copy&pasted into a JS Form Rule (1) which gets added to Behavior tab (2) so it get's executed. window.ccls = window.ccls || {}; ccls.changePanelWidth = {}; ccls.changePanelWidth.execute = function (timeoutCounter,timeoutMax){ var items = document.getElementById("RightPanelOuter"); // verify th (...)