forum
Hi, I am a new guy here and I just started with webcon designer. I need help with mathematical operation on a form. I want to subtract two dates to get number of days beetwen this two dates. I know that I can use "datediff" function but my point is to get this 'dynamically'. When user starts to fill form, he type date 1 and date 2 and below that he will see in third field numbers of days. How to achive this on a form?
Hello, I'm working on a form of employee's declaration, which should contain a long text (an information for the employee, mandatory for legal reasons). What is a proper way for placing these types of data on a form? Is there a way other than creating an attribute and assigning default value (assuming that the text will be constant).
Hello Webcon community! We already tried several times to install Webcon BPS an a local machine (latest Webcon BPS version 2021 1.2.108). If it comes to IIS application creation, we select https and setup refuses to show wildcard certificate, which was previously installed to personal store for local machine. The cerificate is showing in IIS, certmgr (Personal -> Certificates), but is not selectable in Webcon BPS installation. We cancelled setup and tried new installation (after dropping all (...)
I'm struggling with the syntax of the SQL filter for a report. In general it works, but if I want to use the currently loggedin user, I get an error. I tried with the following syntax: AND (##currentloginname##='servr\Userxxx') The error message is: "Incorrect syntax near '='. Incorrect syntax near ','. Incorrect syntax near the keyword 'order'."
Hello Webcon community! I'm not sure about Webcon BPS and setting the right timezone, I hope you can shed a light on this topic for me. We have a server with Webcon BPS installed in an Azure VM (Region North Europe), which has (according to Powershell) the right timezone for us (see attached picture). We didn't find any timezone settings in Azure Portal for the VM, so we think this should be correct. In Webcon Portal every time shown is 2 hours ahead (including DST), so something is obviousl (...)
Hi, I tried to implement the Docusign SDK according to the KB Article (https://community.webcon.com/posts/post/docusign-digital-signatures-in-webcon-bps/36) but cannot get it to work. When i want to send the Process to the Signature Step i get an error from the Docusign API which i can't figure out. "Error while requesting server, received a non successful HTTP code Completed with response Body: "error":"invalid_grant","error_description":"no_valid_keys_or_signatures"}" I'm guessing that i am (...)
Hello, I am trying to synchronize BPS users with AD, and everything seems to be properly configured - the data is read, but the synchronization fails and each entry shows error as below (of course there is valid data under these xxxxx) Record (distinguishedName: CN=xxxxxxxx,OU=Users,OU=xxx,DC=xx,DC=xx,DC=xx, displayName: Lastame, Firstname, adsPath: LDAP://CN=xxxxxx,OU=Users,OU=xxx,DC=de,DC=xx,DC=xx) doesn't contain property useraccountcontrol Our AD does not populate this property for users (...)
Hello, Our client can't give the type of acces needed to the user in order to install the Outlook Plug-In from the browser platform. Is there a way to install the plug-in manually? I saw that for the Word Plug-In there is an executable file, but i couldn't find such a file for the Outlook Plug-in. Is only found a .vsto file. Thank you in advance! George
Maybe this is simple and I'm just overthinking it. I'm creating new proposals, each new proposal has an automatically generated # associated with it (PFY2021-xxxx). I have the form rule built to create the string, but I need the number portion to append. The xxxx number needs to increment for each new record entered. I can't seem to create an "application wide" variable that I can reference, create a new proposal # and then increment by 1. Now that I think about it like that, can I SQL que (...)
Hello all!! Does anyone configured a rule where the action goes on each row of an item list and if a row has option A for a specific column then column B cannot be empty? There are some new functions for the item list but they only work as form rules and for action (even creating a business rule, form rules don't work as it needs to a TRUE/FALSE result). Even using SQL Command I think it would only work for a subquery because I need to check the value on each row. I've used the Select (...)
Hello all! I have a process where the user will be entering Addresses and I'm saving the new entries in a Dictionary. I have the subworkflow set up and it's working but I need to add some rules in order to not create duplicates neither empty rows. For my case, the information to be checked will be Customer Name and Address (because a customer name can have more than one address). I was trying to follow the query below but I'm not sure on how to add the dictionary there (in the database d (...)
Hi, I am trying to use WebDav in order to edit other types of documents (Others than office apps). I have installed the server side plugin and the client side plugins, but I have no idea how to enable any sort of edit button in WEBCON that would trigger the WebDav App. I have tried the demo in this website: https://www.webdavserver.com/ and works, but that only confirms that I have the client side plugins installed correctly. Thanks!
What would be the best method to remove rows from the item list of an instance inside an SDK plugin in order to make use of them in C# code? I tried to remove rows from the item list in the code C# (SDK plugin ) using function : WebCon.WorkFlow.SDK.Documents.Model.ItemsLists.ItemsList.RemoveAt(int index), but can't delete all the rows because I get the error from the image
Hello, I need to find a way to automatically delete some workflow instances. I know that we can use the Archive workflow instance action, but it doesn't work. In the reports menu, we have a section named "Archive workflow instances queue", I found all my instances there, but I need a way to delete them all automatically
Hello everyone, before you install/upgrade BPS check the default schema of the database user under which the installation/upgrade will be executed. Make sure that the default schema is dbo. If this is a different schema new objects may be created using this schema. This may lead to unexpected errors later on which will be hard to debug. Here's a little script to change it. SELECT name AS [Name], SCHEMA_NAME(schema_id) AS schema_name, type_desc, create_date, mod (...)
When creating an SDK action there is an option to use the Logger Class to create logs (https://developer.webcon.com/2021/resources/online-documentation-sdk/html/2c254e06-3ac3-3a82-7c44-dae3d829d1e4.htm) Does anyone know where these logs are located (log file on file system or a specific database table)?
What would be the best method to get the attachments of an instance inside an SDK plugin in order to make use of them in C# code?
Hello all, Hope you're doing great! Does anyone configured a rule that will color a cell in a item list upon value change? I have an item list that will be initialized with values and if the user changes one of them, I want that cell to be marked so it's easier to check the value. I have found some examples but it's using a rule (like > than X) and it's painting the entire row. In the new release there are new item list actions which allow to paint one cell but I don't know how to wr (...)
Hello all, Does anyone configured an Item List to be initialized with a SQL query that will query from another database? In this case I want to query from an Oracle DB and initialize the columns with the columns from the query: select milestone as {DCNCOL:185}, milestone_date as {DCNCOL:186}, amount as {DCNCOL:187}, currency_code as {DCNCOL:188}, amount_euro as {DCNCOL:189} from PL_Invoicing I'm trying to this but it's not working. Hope anyone has ideas for this! Thank yo (...)
Hi guys, I'm totally new to WEBCON. I tried to install Webcon Express 2021, all looks fine but when I go to set up Portal URL I can't understand what kind of address I have to type. Read few times manual but I can't understand. Tried several things but I can't connect to WEBCON BPS 2021 Designer Studio. Any advice and recommendations are welcome.
+48 12 443 13 90