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

Daniel Krüger (Cosmo Consult)

MVP

Generate text file
12.03.2024 07:08

Hi Michał, even so it's a little bit hidden, you can already achieve it. The Add Attachment action supports generating a new file since you are using plain text this should solve your problem. https://docs.webcon.com/docs/2023R3/Studio/Action/Attachments/Action_AddAttachment#5-based-on-sql-query

Notification on comments
11.03.2024 22:51

Thank you Grzegorz, you reminded me of an itch I've forgotten over the time. When I first used the 'Last comment' variable some years ago it was strange for me, that it didn't return the latest/current/new comment. Also the name clearly states, that it will always return the last variable. Sin

Read data from *.XLSM
11.03.2024 21:16

Hi all, before going down the SDK road, how about doing the "rename" in the automation before the action is executed? Ok, it's more like copying the attachment and using a new name, but It's working: SELECT ATT_Value, 'TempExcelFile.xlsx' AS FileName, * from WFDataAttachmets where ATT_WFD

Disable parts of form rules
08.03.2024 15:06

Just for historical purposes: This was also either part of a question in the forum.

Hi, I'm finally taking the time to add this user voice. I think it was in BPS 2020 or 2021 where the option was added that a constant in a business rule would be displayed in the format Group:Constant (1). Right clicking on the name of the constant would show a context menu with all constants i

Hi everyone, it would really be great if we could have the option to check in a business rule whether the edit mode is active. Currently we can check for: - Admin mode - Mobile device - Share mode At the moment I'm using a combination of business rule and form rule to hide /show an elemen

Hi everyone, I just received a response in a ticket and the rich text contained a link to an attachment. I've never thought about this, but I really like this. In this context it would be great, if the context menu auf an attachment would have a function to copy the link of the attachment. A

Hi Gerd, I created a simple case, where a yes/no field is checked, whether a row may be deleted. The solution itself consists of: 1) An html field which is placed below the item list. 2) The html field calls a form rule 3) The form rule goes through the item list and checks a condition. In

Hi, if you have two databases and want to display all applications in one application you will require a custom MSSQL database connection. This database connection will use a user, who can access both databases. Then you could create you SQL query like: SELECT 'Main db' as DatabaseName, [AP

As it happens, I just stumbled about such a case and it made me realize one thing. If the history is displayed in admin mode, the hover should display the value as it is. The line is choose column in the item list with a GUID as a the id and a number as the display name. As you can see it's di

Hi Michał, in the audit trail / version history and there at least in the admin mode. Whenever we have a choose field / column, it would be great to have any kind of option to display the id. At the moment we have only the display name but I can think of a few cases, where the display name i

Hi Björn, the string replace uses a regular expression in the background. You can simply escape the dot with a \ so that the regular expression looks for the dot character and not for any character. It looks a little strange int eh designer studio though. @Michał I hope they are not chang

Hi Michał, do you want to transfer only the data of the workflow instances or the database as mentioned in your question? In the later case, you could take a look at this post: https://daniels-notes.de/posts/2023/copy-a-database Best regards, Daniel

Hotmailbox value on change
29.02.2024 21:37

Hi Maria, when you read the following keep in mind, that I have no real experience with Hot mail box. Form rules and style and behavior actions are only executed in the browser. Since the instance is updated through the hot mailbox feature, there's no browser involved. Instead the service user

Hi Raluca, as far as I can tell the display name is not always resolved and in the DB only the ID is stored. I don't know when it happens but there are some cases. When the workflow instance is then displayed in the form, the fields are "recalculated" and if you hit save, the data may be update

Hi Björn, while using Unicode for formatting text my be suitable for LinkedIn, I would advice against it in the community. Even if the search get's improved, it won't be able to find unicode text. After all I'm using a regular keyboard and the characters are mapped to a code which differs fro

Hi Maks, I suggested the same to a customer, the reply I got was: This doesn't work on an iPad. Best regards, Daniel

Hi Matthias, I'm sorry I have no further idea. I have only iOS and can't do any tests with android. Best regards, Daniel

Hi Björn, the short answer is, no it's not and I have no idea how change it. If I remember correctly, there's also a User Voice regarding this, that there should be a switch to change the default behavior of the link and the icon. Best regards, Daniel

Hi Matthias, did you activate the notifications in your user profile? That's the only remaining setting I can think of. Best regards, Daniel