(...) le to loop over all rows of an excel file? I have an excel file with employees information(say 50 rows of employees). I want to navigate through each row, read and populate data in my form from excel column s and then trigger a workflow for each employee.
(...) Hi. I'm looking for a solution to hide rows of a list element depending on the value of a list element column . I.e. for a task list I would like to have the row visible for everyone, until the checkbox "done" ist set "true". I tried with the "Acceptance" function (see Acceptance.png), but the issue is that I can make the column visible for a (single) defined user, but not for multiple users. Any ideas (...)
(...) EST Designer Studio. When you save a process using the REST designer studio unset translation of changed objects are saved as a blank string instead of null. This may lead to empty Step and Form Type column s in reports and other objects using internal views. If you are already affected by this you can decide whether to wait for a fix or update translates table. update [Translates] set TRANS_Name = nu (...)
(...) application, I will create a blog post for this. Source and exported application: https://github.com/Daniel-Krueger/webcon_reportSubscriptions Attachment: Because of sensitive information I blurred column s in the report screenshot and the table in the mail. Best regards, Daniel
(...) m/forum/thread/555/46 having been removed in 2021.1.3.143 (tested, worked fine), something similar is happening in 2021.1.3.163 when you use a picker field in an item list, and map it's data source-column s into other column s of the item list. It then throws: "b.map is not a function"-error, see attached screenshot. If I dont map data source column s to other column s it doesn't throw an error.
(...) I have the scenario, where i keep e-mail address and other informations in an itemlist. Now i need to send e-mails for each recipient in the itemlist. The e-mail contains informations from other column s in this list. By having three entries in the itemlist, there would be three e-mails with different content to be sent. Currently i'm thinking about creating a simple workflow to send an e-mail. The wo (...)
(...) urce configuration. After updating to version 2021 R3, all REST data sources configured in versions older than 2021 R1 will cease to function. Data sources configured in 2021 R1/R2 will only return column s from a collection that have been manually selected, whereas previously they would load all column s without needing to select them individually. For a data source to return column s from a collectio (...)
(...) Validation rule using SQL. I have an item list that is populated with lines if the user select a Sales Order in another field or manually filled if there is no information on the SO. There is a column that is mandatory to be filled whenever the item list has any rows and I tried many examples to construct a validation form rule in order to have information on that column . I was using a SQL quer (...)
(...) might be a controversial one when it comes to performance, but sometimes it could be quite useful to be able to bring that value in reports. Some of that sometimes could also be done with calculated column s in reports, but it could be easier I suppose.
(...) Hello all, Does anyone configured a calculated column in the reports to calculate the difference between current date and a date field from the form? I was trying days (getdate() - form field) but it's not accepting the days formula. Thank you!
(...) Hi all, I'm out of ideas... I've tried everything that came to my mind without achieving the desired result. Is it possible to have a hyperlink column in an Item List that shows the Preview and only after clicking on the little icon on the right (see attached image) it opens the full form?
(...) unity.webcon.com/posts/post/checking-user-and-group-privileges/258/3 So far, I'm able to check Applications and Processes privileges but when it comes to the Business Rules, I get an error for the column they use as Users (users . BRD_Users) : select users . BRD_ID , isnull ( DEF_Name, '' ) as DEF_Name , usage. BRD_Name , usage. BRD_Documentation from WFBusinessRuleDefinitions as users (...)
(...) Hello, I made a report in WEBCON Designer Studio and one of the column s is "Link". However, when I export that report to excel, that column is converted to a simple text (not a link). Can I in some way configure it to receive in the exported excel that column as link? Best regards, Vitalii Lukash
(...) the parent) and DET_WFCONID ={WFCON:3192} Second issue is that, even trying to save the ID from each subworkflow in the item list select {WFCONCOL:3301} as DET_ID, WFD_ID as {DCNCOL:493} (column in the item list) from wfelements where {WFCONCOL:3295} = {WFD_ID} (form field saving the Parent ID) and WFD_Dtypeid = {DT:120} and isnull({WFCONCOL:3301}, '') '' Third issue is that, if (...)
(...) Hi everyone, I would be glad if the following changes would be implemented: 1. Adding the new Input placeholder 2. In case of data tables the display name should be used instead of the column name. This is especially a problem if the data source is a BPS internal view. WFD_AttChoose1 isn't really helpful for translating. :) 3. There's a slight labeling issue. The PathAndTasks sheet doesn't contain the (...)
(...) i everyone, while designing a new Dashboard for my latest application, i am wondering wether it is possible to use the REPORT TILE logic in HTML, so i could optimize the free space usage (eg. a two column table for 2 report tiles instead of two seperate report tiles). Does anyone of you managed this already? Thanks for your help in advance, Bjoern Poller
(...) f, maybe, in further coming WEBCON versions there could be the possibility to add 2 more "section layouts" like i posted in the picture. Mostly the usefull one would be: half side left, and two small column s in the right half. With this layout options designing dashboards and grouping buttons would work much better. Thanks, Bjoern P.S.: Maybe i forgot the third version 25% - 50% - 25%, if someone wan (...)
(...) Hi, ver. 2021.1.3.205 I have a problem with reports. When I hide one of the column s and then I would like to change the position of the other column in the report and then I have an error... http://webcon.net/WEBCONBPS/db/1/app/21/element/1037860/form/view?returnurl=%2Fdb%2F1%2Fapp%2F21 url: https://webcon.net/WEBCONBPS/api/logger | action: ip: xxx | msg: "stack": "TypeError: Cannot read properties (...)
(...) I have a report that displays data from several processes. If I want to filter by a column which is a global or computed field, for example, the data is prompted only for those that have been loaded. if the data in the filter has been read to the value, e.g. 'o' trying to narrow down to a word that starts with the letter 'p' the search doesn't work. It works well if we filter by column , e.g. author, aft (...)
(...) I hope I can explain it right... I'm trying to add an autocomplete column to an item list that is filtered on a multi select column . So I have a projects dictionary, and want to select a project from that. Each project can have multiple employees working on it, therefore I created a multi-user selection in the project dictionary. When selecting the project I want to get all projects where my account is (...)