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

Maksymilian Stachowiak

User

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

I'll add to this, that you can always use regular mouse scroll click to open link in new tab (although i background). Option is not really configurable, but old good scroll click does the job as good as on any other website :) I've tested also some shortcuts: Ctrl + LFM -> Works same as mouse

Task priorities in webcon
23.02.2024 11:04

Hi Dominik, I'm not bringing good news, but as far as i know, there is no way to change the behavior of My Tasks. You get it as is, without any possibility to change. What you can do with some javascript though is a dashboard that mimics, how my tasks work. I've posted some time ago User Voice,

Thanks Pasquale, that's a good starter, i'll have to remember to check blogs, and not only try to search forum. I'm always forgetting :) I'll leave topic open, maybe someone already worked out how to style them more like original webcon comments.

Hello everyone, I have a pretty workflow intense process (at least for me) - from main document i can start up to 5 subworkflows per subworkflow type (right now around 5). It sums up around possible 25 subworkflows, and none of those are technical. To avoid missing information, and digging th