WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question

Maksymilian Stachowiak

User

The thing is that 'On save workflow element' is triggered only, when a Save button in Menu bar (on the top) is being used. (or when someone without edit permission saves comment based on this*) Pressing Save on bottom - the path, doesn't trigger 'On save workflow element' - it triggers 'On path'

Thanks Daniel, I somehow didn't had a chance to use that action yet, and totally forgot about it 🙃

Hello everyone, I've got a use case, where users want to make a specific path always redirect them to a specific dashboard. Right now, the returnurl parameter is built dynamically, and we (developers) don't have almost any possibilities to change that behavior (we can create our custom links, so

Hi Paweł, how did you saved the element? By disk icon on menu bar, or with save path? I've created a sample dictionary, and saving with floppy disk icon on menu bar triggers that e-mail, but saving using a path does'nt. You could create an automation, and use it in 2 places to solve it: 1. Glo

On checkbox change - JS
13.03.2024 11:57

Hi Joanna, Why are you using HTML with tags? Isn't On Value Change* enough? What is the use case? *https://docs.webcon.com/docs/2023R3/Studio/UxRules_General/#id_2

Multiple lines of text Rich
13.03.2024 11:24

Hi Everyone, I don't think that CSS will have anything to do with it, at least not the one from the browser, rather one from e-mail formatting, but it doesn't look like that. It's displayed the same in preview, even after removing standard e-mail content, and just inserting two attributes. (e-mai

Read data from *.XLSM
11.03.2024 11:41

There is probably a reason, why .xlsm are not recognized by default, as it might be considered a security risk - VBA is really old, and often used in phishing. With that in mind, you can try using below SQL query, to get latest excel file attached to an instance: SELECT TOP 1 ATT_ID FROM

Read data from *.XLSM
11.03.2024 11:08

Hi Sebastian, Are you reading data using an Action, or is it Import to a list / dictionary? I'll assume we are talking about action in this reply. Could you share screenshots from configuration window? Have you tried querying for file with SQL?

I had users asking for possibility to attach files inside text fields (It was possible somehow in IBM Notes), but this would solve that case too :)

I'm also missing this one, it could be used to have better readability.

Generate text file
11.03.2024 09:19

This should be possible to do with Run A PowerShell Script Action*. But I'm not sure if it is available in SaaS I'm currently using it to generate XML files, but creating regular file would look like this: New-Item C:\temp\test.txt Set-Content C:\temp\test.txt 'This is a file created by webcon'

Hi Paweł, You should be able to solve both topics without need to use API. Part 1. You could solve it in few ways: 1. If you've already created an action, you could make it visible on top menu button, and execute it using INVOKE MENU ACTION function on change of field containing ID of source d

Hi Joanna, From Advanced configuration there is no option that would change the formatting of the field. You could achieve it with querying database using SQL with FORMAT and REPLACE functions: SELECT REPLACE(FORMAT(123321123321.22, 'N2', 'de-DE'), '.', ' ') AS Test -- Space separated SELECT

Export Hotfix
04.03.2024 19:50

Hello everyone, I've encountered too many times situation, where i need to make really subtle change in application, to fix some kind of error/bug. Changes so small like: * Add column on a report * Update filter on picker field * Update filter on report * Check 'wizard mode' on path * Reord

That is exactly what I'm doing right now, and it is sufficient, i left a voice here, as it could be enchanced in the future :)

I tried to do some more digging, and the hardest ones to do present will be probably actions, as SQL queries for actions, are stored as XML. In WFActions there is ACT_Configuration column, which contains xml like this: select det_id ,0 as {DCNCOL:134} from wfelementdeta

I'm almost sure that it will be more accurate and faster, but it will require a lot of thinking on where SQL could be used, to make sure that you get all the places. But you have to find them either way, manually, or with query. Why is there a SQL COMMAND needed though? It will be much easier

You could easily retrieve SQL Queries from Data Sources, they are stored in WFS_SelectCommand column (WFDataSources table). I'm not sure what you want to do with those queries later, you should be able to execute them using sp_executesql function, and there is no need to nest SQL Command - you use

Hi Marcin, yes it is possible to get that information with SQL Query, here some simple examples, which should help you start: Data Sources Applications: SELECT WFS_Name, APP_Name FROM AppDataSourceAssocs JOIN WFDataSources ON WFS_ID = ADSA_WFSID JOIN WFApplications ON APP_ID = ADSA_APPID Dat