Rules, JS, SQL

[Solved] How to get "unsaved data" exists information aka "page is dirty"

2 2

Hi, does anyone know how to get via JavaScript whether the page "is dirty". So I can do a similar check to "You are leaving the form with unsaved data"? Best regards, Daniel

How to limit text in position list to 40 characters

0 5

Hi, I want to limit one column in list position , which is multiline text to show only first 40 characters smth like: <?php echo substr(get_the_title(),0,40).' ...'; ?> after click in '...' it will show all text

Webconapps - Connecting to an Azure SQL

0 5

Hello, I have the following scenario: - Webconapps - Data Sources > Connections > MSSQL Database > Azure_SQL: I have server name, database, user and password filled. When I click Test, I get "OK" so Webcon can connect to the database. However, when I try to create a MSSQL database Data Source and chose the above connection, I get the following error: "Unknown error: The SELECT permission was denied on the object 'table_name', database 'database_name', schema 'dbo'..." Using SSMS the (...)

Change attribute field name on form

0 0

Hello, Is there any possibility to change attribute field name on form based on different attribute value?

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?

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

JS for adding new row in item list

0 2

Hi community! We want to add new row(s) to an item list due to customer requirement. This should be triggered on button click, that means on the client-side. Unfortunately I didn't find a way, to insert new row(s) to an item list in available JS functions. Does anyone know how to do that or could you provide some code samples? Thanks in advance & best regards, Nik

SQL Command in Business Rule removes line breaks (CR-LF)

0 5

Hey everyone! Is there a way to keep line breaks (CR-LF) in the output of the SQL Command used in a Business Rule? I'm selecting values from DET_LongText1 which has line breaks. I'm attaching 3 images to show what I mean. 1. Webcon Form: What I see on the frontend. 2. Notepad++: What I see in Notepad++. 3. Output: What I see in the email if I output the value of the field with a Business Rule. I can't output the form field directly because it is coming from an Item List. Do you have a (...)

Generating QR code from text attribute

0 0

Is it possible to generate a QR code other than the database document ID in Webcon BPS? I used the action described below but it is not optimal for me. I have an action (javascript) that generates a QR code and puts it in an HTML attribute. The QR code is created from the value of the text attribute. I want to insert this QR code into the attachment created from the document process. HTML created in this way cannot be added to an attachment. I added an image type attribute, I can drag from H (...)

Portal Substitutions / SQL-Data

0 2

Hello, WebCon BPS user can specify substitutions on the portal. Does anybody know, where the data is stored in the SQL database? I'd like to create a weekly report with the data. We are on BPS Version 2021.1.4.55. Thank you! Cheers, Balint

Open first attachment from all atachment tab

0 2

Based on Daniels blog (https://daniels-notes.de/posts/2021/javascript-form-rule-execution-on-page-load#show-all-attachments-after-page-load) it is posible to open first attachments after page load but from all attachments tab (becouse attachment is in parent workflow)?

Execute SQL stored procedure & SaaS

0 0

Hi all! We have to transfer some values from old database fields to new database fields, since we want to switch some fields in process to global fields. We plan to do this with well know T-SQL statement (UPDATE WFElements SET ...) within a cyclic action, which can be triggered on demand. Does anyone know if there are any restrictions in Webcon SaaS (Software as a service) regarding SQL UPDATE or is it allowed to do such thing? Thanks in advance & best regards, Nik

Retrieving a value from a PowerShell/SQL Procedure action

0 0

Based on Daniel post https://daniels-notes.de/posts/2021/retrieve-ps-variable-value I figure, it is posible to retrive output value from SQL Procedure? How force "Run sql procedure" action to log ouptut to [dbo].[WFLogs] table? Write-Output in PowerShell is logged to LOG_Description column. How log ouput from sql procedure?

The use of multiple global business rules in one global business rule

0 4

Hello, I tried create sql script for created a global business rule with existing multiple global business rules . I tried use of multiple global business rule ( with parameters) in one global business rule (with parameters). Every global business rule used has parameters. The business rule that appeals to the other business rules has parameters that are mapped in the appealed rules. I get the error when I testing. I explained the error and showed the code in the attached image. Thank y (...)

HTML button onclick + insert to dababase

0 1

Is there a option to insert values do database (my own table) by the button added in html form? My idea is like a picture I addend, but when I click on the button I get error Message=Error occured during rule SQL Dodaj powiązanie (Id: 136) evaluation. Source=WebCon.WorkFlow.Base StackTrace= at: Evaluation requested at: Evaluation node: Rule at: Evaluation node: SQL InnerException: Message=Error occured during rule SQL Dodaj powiązanie (Id: 136) evaluation. Source=WebCon.WorkFlow. (...)

Remove Item from collection

0 9

Hi everyone! Am I blind or there is no function oposite to COLLECTION, that would remove an element from collection? How do you manage to overcome the lack of this function? I came up with an idea of making a JS form rule that takes a collection and removes a value given in one of the parameters. It works. But there are limitations that make the solution inelegant. First of all the form rule can not return a value (in opposition to business rules, but those however can not contain Javascript (...)

Attach sent "Custom Mail" as attachment in Workflow instance

0 2

Hi everybody. I wonder if there is a way how I can attach the message sent by an "custom mail" action as new attachment to the workflow instance? Kind regards, KLaus

JavaScript rules in mobile app

0 0

Hi, Does anyone else have problems with JavaScript rules not working in the mobile app? Is there any trick to it? Thanks

Feature requests: item list delete button visibility restriction

0 0

Hi, we have a column visibility/edit/requirement restriction for every field in an item list. But there is no column visibility restriction for the delete button, so you cannot prevent deletion of some rows. It is something you can do easily with js, but only with classic display form mode. It doesn’t work with modern forms. The problem is that it is not guaranteed that your form rules “Main form -> Behavior-> forms rule to be executed on page load” are being executed AFTER the page has been (...)

Feature request: Set field error text within a form rule / javascript

0 0

Hello, I personally like immediate validation – right after the user checks/selects/enters something on the form - much better than validation on an action. So usually I validate fields “on value change” and set the field error if necessary. Currently I use a js-function like this to showing/remove the error message (form display mode: Modern on BPS portal): function showError(columnName, hintText) { let errorLines = $("#" + columnName + " .attributeErrorsPanel li"); if (errorLines (...)