top rated

Using SQL script to update WFD_Signature in WFElements

0 0

Currently I'm migrating files from SharePoint to a custom built WEBCON DMS application. 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 the old system. (...)

Connection between an item list and a dictionary

0 4

Hi, I want to compare(lookup) an item list with dictionary items. On a start step I have the item list where I want to upload some rows from an excel file, then I want to check if uploadet rows exist in the dictionary. If exists, webcon should mark a column in the item list that the entry exists. Do you know how to achieve it? Could you help?

SQL query for calculated column suddenly no longer working when added as constant

0 1

Hello folks, We have used constants which contain SQL queries for calculated report collumns a couple of times already, so this does work. But i now have a query which works perfectly when added into the calculated collumn directly, but no longer works when stored in a constant. (img attached) Through logs we found that he has a problem seemingly with strings, but we found no way to baypass that. Anyone have an idea what is done with the query on the way or why this might be the case?

Branch problem as the task is created in postivie step

0 1

I have a workflow when I have a branch that's check whether user ticked the box 'yes' or 'no'. If user ticks the box yes - the workflow goes to the postivie finished step. However, I needed to configure the task creation, and that worflow stays as a user task . How do I omit the user task creation?

Setup SOAP web service

0 0

Hi, we would like to use the SOAP web service in WEBCON (DBVersion 2022_1_2) . How can we get the delivering result? Webcon by default marks only the "Messages" area. See screenshot. Unfortunately, other markings are not possible... Thanks a lot! Florian

Translation of ALERT and CONFIRM contents in Form Rules

0 4

Does anyone know if it is possible to provide translations for the Form Rule Functions ALERT and CONFIRM? I tried with "MyText$$DE$$Mein Text" but that doesn't do anything. Cheers Pasquale

Populating Dropdown List from REST

0 8

Hi there has anyone an example on how to populate dropdown lists from REST data sources ? I got the working requests in POstman, but I cannot get them to work at all in webcon. and its kinda hard to debug since error messages or logs are seemingly not available... thanks for your help in advance.

Check VAT Status [Poland] error

0 4

Dear Community, from last Friday (29th of July) I experience issues with SOAP Web Service at https://sprawdz-status-vat.mf.gov.pl that checks if Supplier is active VAT payer. Does anyone have same issue? Should we consider "migrating" to https://wl-api.mf.gov.pl REST Web Service, where we can check VAT status also? What about limitations of wl-api service? Thanks in advance for any response here. Best, Adam Hatak

Item list and adding new items with Javascript

0 6

Hi all! We are wondering if there is a good way to add new items to an item list on the client side. We already found a way to add new item (which can be triggered by a form rule) and set some form fields before, which then act as default values for the new row. Since it all is asynchronous it has to be a promise chain, like this pseudo code: p.then(() => { SetValue(formField, 'Value') }).then(() => { InvokeRule('#{BRUX:1526:ID}#') }) This is working fine but unfortunately this s (...)

Fileupload failing

0 0

I need to upload attachments to our company cloud services. Below is the web api endpoint that accept a file: [HttpPost("createfilewithcontent"), DisableRequestSizeLimit] public async Task<ActionResult<GoogleFile>> CreateFileWithContent([FromForm] GFileWithContentWrite fileInfo) { var stream = fileInfo.File.OpenReadStream(); var createdFile = await _driveService.CreateFileAsync( new GoogleFileWrite() { Description= fileInfo.Description, MimeType = fileI (...)

Adding multiple attachments

0 2

Hi everyone, I have problem with adding multiple attachments. When I use action "Add attachment", I can add only one attachment (picture1). When I use the same action, but the SQL query returns more the one attachment - the action doesn't work (and it doesn't matter if the ID's of attchments are in the one row or many rows). Thank you for your time :)

Delay start of workflow for 1 minute

0 3

Hi all! We are currently biting our nails with the following problem: We need to delay execution of workflow for 1 minute, after 1 minute it should go to a path. Every attempt to achieve that failed up to now. The attached setting should trigger after 1 minute (as far as I understand that), but it seems to start immediately. What are we doing wrong here? Many thanks & best regards, Nik

Change multiple fields with Empty Value

0 4

Hi everyone! Hope you're doing great! I need some help here! I want to change a selection of fields with empty value on path transition. The idea is that I have a cyclical process and I need to clean some fields in order to be available on the next step. I'm trying to use the Multiple Change Values to make them as empty, but I'm being unsuccessful here! Does anyone have any ideas? Thank you all!

Prevent users from printing and downloading the attachment

0 2

Hey everyone, When an attachment is opened on the form, it shows the download button. Can we disable it? Also, when previewing the attachments there is always the top bar that contains the download and print button. Anyone knows if it is possible to disable it? Thank you, Martin

Active Directory department query as datasource

0 2

Hi. Is there a way to query the Active Directory only for the department column and add this as a datasource. What I'm seaking is a list of all departments we have in the company. Kind regards Klaus

Set the value of the form field field

0 1

Hello, I have a form that has a 5 steps. On each step I have a form field that has 4 options('statuses') : open,closed, opened-again, in-progess. I want to have the value open in first 3 steps, than on step 4 i want to have a status 'closed'. How do I make the step depend on the field?

Sending notifications when step has paths that are "available for mailapproval"

0 2

Hi, I have an issue with sending mails in steps that are defined as 'available for Mailapproval'. In the current case I only want to send out a notification email for information, the receipient doesnt have a task in the step. So i defined a template, put fields and grids in, and lokked at the preview. Whatever i try, if I test with an instance that is currently in a step that is avi for MailApproval, Webcon adds the available path-buttons to the end of the email. This will confuse people tha (...)

How to present field 'Picture' on dashboard

0 5

Hello, Question 1: Is there any possibility to give user access to form but restrict/limit form history (only user have access to current form not for previous versions)? Question 2: I have form field 'Picture' in dictionary form which (that form) is connected with user by field 'User' - do you have any idea how to present that picture on users dashboard? Do be clear: Form 1: Field User: X Field Picture: A Form 2: Field User: Y Field Picture B On dashboard User X (...)

Error set field type Picture empty

0 2

Hi, I'm trying to use the "change the value of a single field" action to set the image field to empty after an image was added. The action is done, but there are no changes regarding the image (it's still there). WEBCON version 2022.1.1.53

Using rich text fields in word generation

0 1

We have the requirement, that text from a rich text enabled multiline field should be displayed in the word document together with its formatting. Does anyone have experiences how this can be achieved?