Jacek Wojnar

Hi, attached is an example of reading the name to the id from the fixed values ​​list. 1 - column with ID 2 - Data source ID 3 - column with ID#Name (from the fixed values ​​list) "item" is the column name returned by the "SplitToTable" function query: SELECT DET_Value1 ,(SELECT TOP 1

1. Fixed value list - you can read fixed value e.g. from a query like this " SELECT dbo.ClearWFElemId(item) as ItemID ,dbo.ClearWFElemId( dbo.ClearWFElem(item)) as ItemName ,dbo.ClearWFElem( dbo.ClearWFElem(item)) as ItemDescription from dbo.SplitToTable((select WFS_StaticValues ​​FROM [dbo]

ok - now I understand. What type of data source do you need to connect? fixed value list, BPS internal view or sql (or something else)? I think the easiest thing to do would be to add an INNER JOIN to your query and read the necessary values.

Hi, The question is, what do you want to achieve? Where do you want to connect the data source? You can connect the data source to e.g. sqlgrid or choose field and you don't have to write a separate query. https://docs.webcon.com/docs/2024R1/Studio/ConnectionsAndDataSource/DataSources/.

Hi, I had a similar case once. The cause was the use of {AP: xx} (with a space in the middle) in one of the hyperlinks. Interestingly, it worked correctly in the TEST environment, so I didn't notice that there was an incorrect tag. The problem was with importing to another environment. Proba

as what I checked, it can be calculated by summing the WFH_FormEditDurationToLeave column from the WFHistoryElements table.

Raluca, maybe you tested it on an administrator account (it's probably always visible then). It should disappear on a "normal" account

-

Hi Raluca, you can do a workaround with css ;) [data-key="substitutionsTitle"]{ display: none;}

Hi, according to the documentation: https://docs.webcon.com/docs/2024R1/Portal/Form/ "Form filling time – the total time that the users spent on editing the form"

Hi, try this solution: 1. add a technical column of type "Data row" and define it as "OrdinarNumber". 2. pass the value of the technical column to the StergerAction function as a parameter 3. inside the StergerAction function you should make a for loop and go through all the elements and check i

yes - that sounds interesting. I've also never heard of using business rules in a calculated column :D if it works between environments it'll be really cool :-)

Hi, You can check if there are any tasks to do in this step with a query below If you return the TSK_User column, you will know who to send the email to SELECT 1 as condition FROM ActiveTasks WHERE TSK_WFDID = {WFD_ID} AND TSK_isdeleted = 0 AND TSK_IsFinished = 0 AND TSK_STPID = {STP_ID}

Hi, did you grant permissions for this app in Designer Studio to application/process? check this: https://developer.webcon.com/docs/registration-and-authentiaction

Hi, I would like to submit an idea related to: - Daniel's post: https://community.webcon.com/forum/thread/329?messageid=329 - Maks' post: https://community.webcon.com/forum/thread/5057?messageid=5057 it would be great if the IS IN function has vertical layout (screenshot)

Hi, I don't quite understand... ;) where do you have this condition? is it some global action or do you have it on a specific step? Have you checked what this condition returns in designer studio when you click "Show"?

Hi, I don't have a ready solution for you but maybe this will help a little. First of all the language code should have two characters e.g. de, en (according to the documentation: https://community.webcon.com/posts/post/multilingual-choice-fields/264/23 ) Additionally there is an SQL functio

Hi Lukasz, I just checked and I was able to save over 12,000 characters without any problems. Version 2023.1.2

interesting idea :-) it would also be great if we could specify the formatting of the copied value for fields like number/date (especially useful when copying to other systems that may have different formatting). Maybe through a business rule (then there would be complete freedom and we could a

Hi, you have to generate client id and client secret yourself. Remember to save your secret id, it will not be shown again. See the attachment