I have problem - in dictionary I have companies with have got: name like: "ABC " - Factory Company in name is quote sign on beginning (data from polish national VAT/NIP databese) I was testing: if in string is " or ' all time I have got error if I remove from string [name] " or ' - then workflow is working [code] <div style="text-align: Center;"> <button style="text-align: center;" font-weight: bold; onclick="StartElementInNewWindow(#{WF:28}#,#{DT:58}#,'WFD_AttChoose1='+encodeURI (...)
Hello Community, I've got a problem. I've got two workflows, a parent and one subworkflow. I'm trying to transfer data from the parent workflow (single line of text attributes - 'email' and 'phone') to a table in the subworkflow with the item list update action. The table has columns ('value' - single line of text and 'contact type'(selection list: 1#Mail, 2#Phone)). How to write an SQL query to put different WFD_AttText attributes into one DET_Att column and different Att_Choose values into (...)
Hi, I am currently exploring options for viewing documents within Webcon. Specifically, I am interested in understanding whether there is a possibility to visualize a document by providing a link that points to a document stored either on SharePoint or within a SQL Server database. My goal is to enable the automatic display of the associated document in preview mode when a user selects a record in the application. Has anyone had experience or insights into achieving this integration? If (...)
Hi, When inserting an item list in a word template, the add-in asks for some columns configuration for the final table. Issue is that modifying "Display name" of a column of the item list is not visible in the final document, it is visible only in the template. The attachment document receives the original item list column name. The "Display name" set for an autogenerated column (like ID) works and modification is visible in both template and generated attachment. Thanks, Mihail
Hi all We're on 2022 and I believe it used to be possible to release a user license in Portal. But I can't find it any longer. I thought it used to be under https://[...]/adminPanel/users In Studio I do see the option in the reports section. However, it won't let me release a license saying "User has active state in Active Directory, license cannot be released". I would like to be able to free up a license from a couple of test users and thought this was possible a while ago. Any idea? Tha (...)
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 ( (...)
I have built a Word template and placed all fields I need in there. But when a process is using this template, I have noticed that some of the information are not taken correctly and I don't understand why. Maybe is helpful to say that some of the info here should be taken from a Data Row field type, but still, I can't exactly see the problem here as some of the returned rows are working fine, some not.. This never happened to me before. To put this straight forward, the problems I notice are (...)
Hello, Is it possible to make the comment save button also available for the form in edit mode? Regards D.
Hi guys, got case here where in Webcon's report there is a row from item list. This row is added as a column to the [Columns available in report] as on the screenshot, but remains unticked, therefore not visible in the default view on the report. Nonetheless, report still shows multiple lines with same data/instance ID, if there is > 1 item list row with data on the form. This should be the case if the column is used in the report - ticked either in the default view or in one of the custom views (...)
Hello, Is it possible to center the item list column label? I see that the form rule allows you to center the value in the column -> SET CELL STYLE. Applying CSS to the entire list of items centers labels, but not all column types (works for picklist column type). Regards D.
Hello, I'm configuring a clone feature for nested workflows, and i need to copy attachments from parent workflow to new parent, and from child elements to new children. Something like this: -Parent --Child --Child -NewParent --NewChild1 --NewChild2 It's easy to copy Parent attachments - I'm starting parent with `Start a subworkflow` action, which has `Copy attachments to subworkflow` option - this works great. This is the first step I have in my automation. Unfortunately Categ (...)
Hello Community, is it possible to check whether a value exists in a sharepoint list before I create a new entry via workflow action? What's the best way to do it? Can I use a data connection to query for a certain value in a business rule? Thanks!
Hello everyone I have to correct my post, it's about a problem with process cloning, sorry. I have a general question - have you ever encountered a situation in which after moving processes between environments, certain functionalities disappeared? I'm talking about moving the process from prod->test and then test->prod. Is it even possible for this to cut out recently added functionality?
Hi! We are in the process of upgrading from 2017 to 2021 - testing phase. I have a problem with the visibility and requirement rules for fields in an item list, when the contents of one cell affect the behavior of another cell in the same row. The existing rules do not work. What is wrong?
What I have is working, but just for one item: 1. dictionary with shipping company: a) DHL, GLS ect. b) parcel tracking link with marking place: [tracking_no] 2. business rule is changing [tracking_no] and set to text field as hyperlink and "grab" the tracking individual string (see all screenshots) What I would like to have: the same functionality but add multiple lines (divided shipping ... :/ ) Item list, where I can add rows with shipping tracking link which opens I read this (...)
I added few fields, which take data from other and recalculate them. I want to refesh old elements, so data will update in them. I've tried adding technical field and changing it's value so other values shoud recalculeate, but it doesn't work. This has to be done once. Any ideas?
Hello. I have a subworkflow here I copy the content of an item list of the parent WF (change item list values). That works fine, but the attachment I have in parent item list I don't get copied/moved/linked. Has anybody an idea? Kind regards Klaus
Hi, We installed a fresh Webcon server and attached the backup of the config database to a new SQL Server and connected it to the new Webcon server. The config database now has references to the old host and the new host. Is it possible to remove the old host from the config db? Thanks
1. We currently have installed version 2023.1.1.56, and I cannot find it in the platform center anymore. 2. Does anyone know if importing processes from this to 2023.1.1.89 works? Or do I need to do an upgrade first? 3. Is there anything we need to consider when updating this missing version?
I have a form with drop down list. This drop down list is using static list. Static list have 8 "items". Steps are A>B>C>D I would like to use items 1-3 in step A and B where index ID of stem is for example 111 and 112, and if is in step C or D then the list have only options 4-8. of course i would like to reset value a drop down list when enter to step C . BTW: I don't know SQL yet ... and in editor in filter there is no if then else .... so .... it works only in first step ... b (...)