search results

(...) Hi, unfortunately there seems to be no configuration for output parameters in PowerShell script invoke actions. This is much needed to get back calculated values , created logs or whatever else. The workaround from Daniel is not really convenient: https://daniels-notes.de/posts/2021/retrieve-ps-variable-value It would be really nice if one could define input and output parameters like in other (...)

(...) anything in the body. Depending of the chosen body type it would be great if WEBCON would automatically set the correct string. E.g. null if JSON is chosen. Right now one has to set all attribute values in quotes to prevent this and to cast them on the endpoint's server side or a form rule and extra form field are needed to create the needed string for the body if the field value is empty. Could (...)

(...) Hi, I'm working with api that doesn't allow uptade of whole list at once and it could be done only row by row. How to call REST API for each row in item list and pass related values ? I've tried to use foreach row and business rule in call definition but it doesn't work.

(...) Hi, I'm writing this post to verify, that I didn't overlooked an option. Situation: I have a data table to get the data of subworkflows and the base 64 encoded values of their attached images. This data table is used to create a word document. The standard SQL connection uses the bps_user which neither can read data from a separate database nor is the user allowed to read the attachment file tab (...)

(...) Hi, Is there a chance to add alternative way of filtering data on reports based on text fields rather than filtering specific values ? It's quicker for user to enter directly search phrase rather than choosing from list, even filtered values (sometimes user have to check multiple options that meet search phrase). Additionally it skips one sql query used for generating list of values in filter. It could (...)

(...) sts and the protocol that I want to achieve it with is by using cyclical actions. I've created an automation that is runing subworkflow(sql) and there is a problem with mapping. Data source has exact values that I need, and I'm using them as intended but the problem is I'm getting data rows I don't want and even then those queried fields are still not applied to created instances after running the actio (...)

(...) Hi everyone, I’m trying to display numeric values in WEBCON BPS Word printouts with thousand separators (for example, 1.000,00€ instead of 1000,00€). Interestingly, in Item Lists (tables) the formatting is shown correctly with thousand separators. However, in regular form fields (for example, floating-point numbers), the values are displayed without the separator. Is there a way to configur (...)

(...) update two fields in the info panel, shown in the screenshot below ? I'm running a 'Start workflow(SQL)' action and it seems that I can only overwite the author, but that still wouldn't work because values is not obtained thorugh sql, but applied.

(...) Hi, i use the "Hyperlink"-actiontype for copying some values of a filled form to a new form (see attachment). That works very fine. But if I add a picture form field, the copy process failed with a message "HTTP Error 414. The request URL is too long" Is there any other possibility to copy a picture from a filled form to another new form? Thanks for reply Franz Mayer

(...) Hi everyone! Is there a standardized way to remove binary data from the ATF_Value column in attachments? This column displays values like 0x[…] whenever an attachment exists on the form. However, when we delete the attachment manually, the binary data is still visible because it’s stored in the element’s history logs. When I use the Delete attachments action with the options “all” and “delete a (...)

(...) I need to call a REST API from a WEBCON form and write the returned values back into form fields. The REST API performs several validations on the incoming JSON payload (e.g. date from valid, date to valid, amount valid, etc.). In case of a validation error, the API returns something like: { "state": "error", "error_msg": "Date to must be greater than date from" } Approach 1 – Automation (...)

(...) I am using the "Generate an Excel File" action to generate and send out an Excel to a customer, using values from an Item List. Following that action, I'm using another "Generate an Excel file" action to then update the existing Excel and map it's column name cells (A1-Z1) to Business Rules containing translations for those column names, so we don't have to use our internal Item List names. That now lea (...)

(...) Hi all, I have a question about calculating a Date to field based on two other fields in WEBCON. I have: Date from – DateTime field Time (h) – Choice field (values like: 1, 1.5, 2, etc.) Date to – DateTime field I want Date to to be automatically calculated as: Date to = Date from + Time (h) hours I tried to use a form rule, but I keep getting an error in the Date to field. Ha (...)

(...) Hi all, I have several questions regarding WEBCON BPS capabilities and best practices: Is it possible to create printouts (printable documents / reports) that use values from form fields (e.g., Date from, Date to, Choice fields, Text fields) and generate a printable confirmation for the user? Does WEBCON BPS have a built-in task scheduler / job scheduler (harmonogram zadań)? What are plugin (...)

(...) now what functions are called when i press the "Duplicate" button on a row in an itemlist ? We want to give the user the ability to copy a row, however after copying the row i need to change certain values of the copy. Right now i trigger the duplicating by selecting the html element and executing a .click() on it(the user is not allowed to just copy a row). The problem is i cannot change the value (...)

(...) me or impossible without workarounds. Proposed Improvement: Introduce parameter support for Data Sources, similar to how Business Rules allow input parameters. Parameters could include: - Filter values (e.g., a specific cost center, OU, or status) - Context values (e.g., current user, workflow field, or system variable) This would allow a single Data Source to be reused dynamically across multi (...)

(...) Hi, short: Business rule text parameter string values only containing digits seem to get casted to an integer value in WEBCON. long: Declaring a VARCHAR variable in SQL as a string like '001' is returned as string. If 001 is replaced by a text parameter in between single quotes its value '001' turns to 1 as integer. I would expect that a string value '001' remains a string when using it as a t (...)

(...) lobal form rules" and "Process form rules". Same for constants and business rules in the respective editor tab. E.g. "App constants" between "Global constants" and "Process constants" in the editors "values " tab. Same for automations. Kind regards Sébastien

(...) a source filter of a choose field I'm preparing the filter value on step entry. This is sufficient for this case.. #With a standard SQL data source I would use one of these options. The hard coded values would be replaced by the field value. {COLUMN:ID#ID} in ('KHL_030','KHL_020') {COLUMN:ID#ID} in (select item from dbo.SplitToTable('KHL_030,KHL_020',','))*/ #The first approach fails Field val (...)

(...) Hi, I've created a timer with an action 'Update item list values ' and 'send a custom email'. I want it to refresh my item list every 6 hours. Please find attached my timer configuration (to test it I set the interval to 1 minute and added an email action I mentioned above). I saved the process and waited looking at my form instance. Nothing happened. I also can't see this timer in Reports > Timer ope (...)