Tips&Tricks
I would like to conduct tests in the context of a specific user, using their permissions as an example. How do you do this?
Hi everybody, has anybody an idea how I could manage to make (copy) out of a base64 type picture field an attachment for a bunch of instances? I.e. I have an QR code within my workflow instance as picture field. But I need to export it for external use. Kind regards Klaus
Hello everyone, How can I find out more information about the cause using an error ID? Where can I enter the ID in the Designer Studio to get to the form field that is causing the error? I tried to adapt a data source to a "data table" form field because not all existing values were displayed. Now I always get the error "Failed with an unknown exception Error ID: 6f351188-04d9-4049-bd2b-d3da66c64976" Unfortunately the error code doesn't help me understand what exactly happened... Ma (...)
Hello, I have an equipment initialization process (1) , followed by another process of allocating this equipment to a user (2). I have created a Report - "Equipment allocation" and I want to add a calculated column to this report that brings in the "Series" of the equipment from the Initialization process. I have this query: (select dbo.ClearWFElemAdv(WFD_AttChoose2)[which is the "Series" column in process (1)] from wfelements where wfd_dtypeid=102[which is the form id of process ( (...)
Hi! We have a business request to save email in instance we have just sent out with Webcon action. I know some workarounds: - show some details from wfmails table - create hotmailbox and process cc-d email But I do not like them. I have not tried, but maybe with msgraph api it is solvable. Does anyone have a good solution to save sent email in msg/eml file as attachment? Thanks! BR Peter
Hello, I would like to create some daily or weekly reports based on the requests made that day/week. Is there a scheduled process that can do that? Or Is it possible to achieve this in Webcon? For example, in Power automate there is a scheduled flow that can be set to run whenever you want. Thanks.
Hi there, For security reasons, we need to add a timeout for all user logins such that after a couple of hours, after login, the user will be prompted to log in again. I looked through the GlobalParameters data base and found the following (line 44 - PortalTokenSigningKey) ..."Expiration":"00:00:00","RefreshTokenExpiration":"0.00:00:00","AuthCookieExpiration":"0.00:00:00","AuthCookieSlidingExpiration":true} I am not sure if it's the right place, what format it uses (days:hours:minutes (...)
Hi, Do you know how to make rows in a 'Data table' field colorful? I get some data from subworkflows by the table field and I want to color some rows depending on their status: open - blue, closed-green ... Is there such posibility?
How make sure that field with barcode is unique across application?
Hi there, while starting a new instance, i am giving the users the ability to make a save for the moment (caching all inputs so far), so they could finish the instance later. If the user wants to start that instance again, all input fields are invisible and a DATA TABLE shows the already started instance including LINKS to that instance. I would like to have that links opened in the existing window, but i dont find a working way to configure that. Every time a new windows is opened. Anyone a (...)
Hi How can I trigger the deletion of a given WFelements element in my own action? I know there is a delete button but you can only trigger it by standing on the form, I would like to trigger the deletion action as a cyclic action. Thx Maciej
Hi everyone, I got the below error, when mails should be send via Graph: "Content type text/html does not have a factory registered to be parsed" As it turned it, the cause have been invalid/corrupted credentials. Updating the credentials resolved the issue. Best regards, Daniel
How to export xml file using UTF-8 encoding?
Hi all, first of all: this is not supposed to be a moaning complaint, just a heads up so other people dont fall for the issue that hit us today. I wanted to share some info regarding the update from 2022 to 2023, as we ran into some very unsatisfying issues with SQL COMMAND business rules that are querying field IDs. It hit us on some neuralgic spots in our main workflow, causing quite some pain right now. If you still have to update to 2023 make sure you test every SQL COMMAND based ru (...)
Hi, I would like to create validation for the input in a column of an item list. I have an item list with two columns (Input, Source). If the Source is "External," I don't want to validate for special characters. I have been using regex on the column, but now I have this condition. One solution I thought of is to create a "for each" loop on the item list and add a validation form... But I would prefer it to happen immediately, when user is inputing, not when the user clicks on the next (...)
Hello, I am trying to update some form fields and columns in an item list after some actions. On my path i have configured a FOR EACH on my item list which is creating/composing JSON payload for my REST. (rows) However, I am encountering an InternalServerError (500) when attempting to save this data using REST service on path for my current instance. PATCH: api/data/v5.0/db/#{DBID}#/elements/#{WFD_ID}# { "workflow": { "id": "#{WF:123}#" }, "formType": { "guid": "96 (...)
Hi everyone, I'm currently working with a popup search field that retrieves data from a REST web service. My challenge is that I need the ID to also be the value for the field. Essentially, when initializing the field, I need to set both the ID and the Name for the same field. However, when I attempt to do this, I encounter an error. Has anyone else faced this issue or found a workaround to handle this situation? Thanks in advance!
Hi guys, Is there an easy way to copy content from one process to another, e.g. using the WFDID? For example, to copy the content of a text field from process 1 to a text field in process 2 using an action. Our users would like to have a feature to copy content from older processes to current ones if it is similar content. A kind of "copy template".
Hello, I have a form field - multiple lines of text (rich). When i send an e-mail, i set my form field - last entry text. If i write a text and add a new line, it multiples the number of lines in e-mail...as you can see in the attached screenshots. Do you know why is it happening? And what is there to do? Thank you.
Hi there, I have following idea and search for a solution: I have an items list; now in case a certain field is changed, I want to write the "old" value before the change into a different column of this itemlist row. Any ideas? Kind regards, Klaus
+48 12 443 13 90