.
Hello there :) I have a problem when trying to generate a table using the manual initialization via HTML Button. It only works when I initialize the table manually. I want to use SQL however, to automate the whole thing. I failed using many Select Statements. What would be the ideal Select statement that would return the days between two dates, which happen to be the attributes? Best Regards, Igor
Dear Community, we have installed WEBCON BPS Standalone and published it through Azure AD Application Proxy. We are synchronising users in BPS with on-premises Active Directory. Currently we experience timeout issues after some time of inactivity on WEBCON BPS site. Sometimes it's few minutes, sometimes about 1 hour. See example in attachments. Please notice that WEBCON BPS and SQL Server (VMs) are placed in Azure. Does anyone experience same issues? Any feedback is more than welcome :)
Hi, Is there a set of rules, an instruction on how to directly (using insert-sql) import data into the database (into the WFelements table)? Which field values should we generate so that there are no problems with the operation of the application. Of course, WFF_STPID - step ID, WFD_DTYPEDID - form ID depends on the process, and the rest, e.g. RowVersion (some hexadecimal value) ? And other?
Dear Community, just a general question about e-mail notification with Microsoft 365 accounts. On 01.10.2022 Microsoft will disable Basic authentication. How do you plan to keep working e-mail notifications with SMTP from M365?
.
Hello all, Does anyone tried to use the concat function using a form field? I have a form field that is single text and I want to use it plus another info like below: concat ('AaAA' 'Form Field') But I'm always getting an error saying that the rule is not correct, I tried to use a SET before and keep the information in another field but it doesn't allow to save. Anyone used this already? Thank you!
Hi, I am trying to configure an OCR action. For my configuration I have followed various instructions in the webcon community, especially: https://community.webcon.com/posts/post/the-ocr-verification-view-for-the-modern-form/71/3. I have seen in the text layer queue report that the status of my documents is "ProcessingPending". I don't see anywhere what is the reason why the status is not changing or that anything is happening with this document. (FineReader is installed and license key is en (...)
I have problem with validation form. 1. I have step where task is assigned to tech group All (other groups in form) a) Lider = Person A or Person A and Person B b) User group = Person 1, Person 2 ... Person X c) All = Lider + User group Now I have conditions to few cells in "item list" If user is one of Lider (group) then he need to fill and set proper values in each row in "item list". if user is one of User Group then he don't need to do anything or is filling first part of "ite (...)
Hi I have a question. I want to return all weekend days in SQL for my form validation. This is my SQL Code that returns these days, but only for the current month: WITH Dates AS ( SELECT CAST(DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0) AS DATE) AS DateValue UNION ALL SELECT DATEADD(DAY, 1, DateValue) FROM Dates WHERE DATEADD(DAY, 1, DateValue) < DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) + 1, 0) ) SELECT DateValue FROM Dates WHERE DATEPART(WEEKDAY, Date (...)
Hi, I have a situation where multiple users get assigned tasks on a certain path. The parallelism is set to Completion - All. It mostly work fine. But if certain users complete their task before other users do, the workflow goes into the next step, despite other user tasks not being completed. When I look at the element history, when other users finish their task, "Completion - All" and their name is logged. But when these "special users" finish their task, it logs "Information (editing allow (...)
Hello everyone In a process I run a cyclic action in the Global Actions. This action contains a "Start a subworkflow (SQL)". When the subworkflow action is executed I just get the message 'Incorrect syntax near '}'.' in the *Last error* field. As seen on the screenshot There is no '}' in the SQL query of the subworkflow action... So now I am facing the mystery where exactly this error occurs at all and what exactly is the cause. Does anyone know where I can find more information about t (...)
We are in the process of setting up Sandbox environment. Installed 2021.1.2.136 version successfully , Activated temporary license received from webcon and activated it. When tried to login to Designer studio initially , it's giving that "No rights for designer Studio " message. How can I assign designer studio access? Not sure what is missing.
I try to read/load in an xml-file in the Webcon application about the attachment section. Then I build myself a choice picker, where I can chose the selected file. After that I want to run an SDK action, where I get the data from my xml-file. In my code I implemented something but the file path is static at the moment and compares the file names. Normally every read in file gets an ID in the database but I don't know how to access this data. Has anyone experience with this and kno (...)
As 2025 version have been released, we've got a new changelog to read through: https://webcon.com/wp-content/uploads/2024/11/Changelog_2025_1_1_23_EN.pdf What are your thoughts on changes? Which ones are yours favourite? :) For me - ALL TRUE, and ANY TRUE operators sounds great! So many nested boolean logic to update ;)
Hi, Is it possible to include the comments field into a pdf generated based on a template? So like you can include various form fields by creating a tag e.g. {WFD_AttText1}, is there such a code for the comments field? And will it work if we include it in a template to generate pdfs? Thanks!
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 and 1 day, saved it second record as form1, step2 and 2 days, saved it. 3rd record as (...)
I have Item list [slave]with column where I can pick people (from other item list [master] which contain 1. BPS users, 2. AD users (some of them are in BPS users - not all) and others - people out of AD and BPS. 1. I would like to run sub flow for each row of item list (done) 2. fill proper data (done) 3. assign to people from item list [slave] : a) assign to all BPS users and skip non BPS users and others b) if any of people is not BPS user then assign to person from form (who is BPS use (...)
Unfortunately I can't use as source "BPS Users" and I need to change source to "AD Users". The BPS Users have 100 users but AD Users have 300 users In both sources I need name of Manager. I use item list with dropdown list with Autocomplete when source id BPS user is fine but if I switch to AD Users then I would like to column "manager" but it give me: CN=John Doe,OU=Users,OU=Employees,OU=CTM,OU=People,DC=xyz,DC=xyz,DC=local and I need just "John Doe" in text box ...
Hi, Is it possible to remind the user to save the form after adding several items to the item list (WFD_SubElems). I ask because users report a problem, such that they forget to save (click on the transition path).