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

Maksymilian Stachowiak

User

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

Hi Paweł, a) Could you share where do you need to use that list row no? Is it context of designer studio, or are you creating SQL query? (if so, then there is DET_RowIndex, which could be helpful). b) Autocomplete shouldn't be much slower than choice field, that's what I'm using as default for

There is also "Change form type" action, but you can't directly select the form type in that action - users are choosing which form should be presented: https://community.webcon.com/posts/post/the-change-form-type-action/289

I'd suggest using Webcon API to achieve it, and some Powershell/Python/any scripting language running with Cron, or Windows Task Scheduler, depending on host system. There are endpoints, which should make it possible (https://portal.webconbps.com/api/index.html?urls.primaryName=API%20v5.0) - atta

Date Time Picker
20.02.2024 15:52

HI everyone, Since I've started using Date Time picker in applications I'm always confused when using that Time control part. Most of the time I'm pressing Today instead of Close (and i can see same happens for other users), and it's frustrating that i can't type in the hour/minutes with keyboa

That's a nice solution, if PowerBi is available, i like it! :)

Character counting
15.02.2024 15:12

Hi Dariusz, there is already word/character counter at least in version 2023.1.3.29. It requires to select that it will be formatted field, but it doesn't require any formatting options to be active. So on advanced configuration in tab "Standard" mark it as formatted, and in tab "Advanced" unche