Daniel Krüger (Cosmo Consult)

Hi Markus, my best idea was to use reference a data row, which returns the rich text with html tags, which in turn I hoped to feed to some field functions. That wasn't successful. If you would be fine with a pdf, my best bet would be to generate a HTML which could be converted to PDF. At

Hi Christian, we have never used the mail approval before so I was curious and played a bit with it. We are using version 2022.1.1.2.31 at the moment and it behaves the same. The approval is added at the bottom/before the end of the body of the mail. But we can make use of it. You can see

Hi Nik, I had the same Problem with {} here https://community.webcon.com/forum/thread/1478?messageid=1478 I've used the ASCII Character code: Curly right bracket= Char 125 Curly left bracket = Char 123 -- ,'"'+Char(125)+','+Char(123)) Best regards, Daniel

Hi Pawel, thanks for the confirmation. I hope to do so as you suggested in the near future. We have setup the environment for a customer who uses a single tenant application for AAD authentication. I don't have a guest account in their Azure AD yet. So I'm currently stuck testing the basic fun

Hi Martin, the server is running in Azure with local accounts and the users use Azure AD for authentication. Even so I wouldn't do it in other cases I modified the data in the SQL Database directly since I didn't found another option. Best regards, Daniel

Hi Martin, this fails, without a detailed error. There's just a little error icon besides BPS ID. After trying it in the browser, I could guess, that it's the same error. :) Best regards, Daniel

Hi Nik, there's this function: webcon.businessRules.subelementAddNewRow Unfortunately you can't populate the new row with the same call. You need to find the latest /unpopulated one. General hint with a little trap: If there's a form rule for this, you can also do it with JavaScript, just

Hi everyone, does someone has an idea, how I can add a mail address to a local user account? If I want to add one, I get an error, that the existing BPS Id does not match the UPN format. background information: a customer uses a single server machine for running a test environment for WEBCO

I'm currently sitting in the train travelling to Münster and the internet connection is like a sidescrolling game where you jump to evade obstacles. It's quite fast and every time you hit one, the internet connection is down. :) It's interesting that the business rule removes the html tags. I

Hi Martin, is this a normal text field or rich text? The value looks like a normal one. In this case you have two options. a) Add some css so that the line breaks are preserved inside the HTML mail. In most cases they are ignored. b) Replace the Character 10 and 13 with the HTML line break

Hi Martin, also Pawel already mentioned all mandatory steps, I have one optional. Optional fourth step: Check any constants if the contain links /URLs or entity ids, like a database id. At least in my environment I have a few of those constants. :) Best regards, Daniel

Hi Darek, you can achieve this by using the update related workflow instance action: https://community.webcon.com/posts/post/the-update-related-workflow-instance-action/81 You could execute this action during the sav trigger of the parent workflow. Regarding the "same field": All workflo

Hi Stanisław, the suggestion of Martin could be a start, a complete picture could look like this: 1. Use "Start subworkflow (sql) action and use a query like this select distinct director as RESPONSIBLE_Database_Column from WFelementDetails where DET_WFDID = INSTANCEID and DET_WFCONID = ITEM

Hi Nik, I stumbled about the "Throw error" operator which is only available inside a condition just the other day, see the attachment. :) Without it, I would probably have used the "Valide form" action which would also throw an error. Best regards, Daniel

A new knowledge base post has been added: Quote: "When installing BPS databases on SQL server higher than 2014, changing the Compatibility Level of WEBCON BPS databases from SQL Server 2014 to a higher level is not recommended." https://community.webcon.com/posts/post/compatibility-level-of-web

Hi rohans, I don't know where you life but in Germany for example the bank holidays depend on the region you are living or working in. So a simple table like the non-working dates isn't sufficient. That's probably the reason why the "Days off" data source template has been added. With this data s

Hi Klaus, in this case I would convert the origin data to a value which is excepted using sql. For example select Inserted, case when Inserted = '' then null when Inserted = null then null else convert(datetime,Inserted) end as InsertedDate from ( select '2022-01-01' as In

Hi Klaus, maybe I missed something but I didn't understand which action/method you are using for the data import. Are you using some external tool which uses the REST API, a start workflow (sql) action, import using excel in a dictionary or item list? Or is it something else? A screenshot c

Hi everyone, did someone came across an option to verify, whether the save has been triggered by the save button or by a path transition in a form field extension logic class? I did check to no avail: - Public properties - Non-public properties - Passing {CURRENT_PATH} inside the configurati

Hi, I'm not sure why you want to do an extra REST call which could fail, if you already have the exchange rate data. The only idea I have is that you really need the current rate. But this is beside the question. Which API do you want to use? Do you want to use the NBP API? Maybe I have overlo