search results

(...) ntry vs national holidays in the country? Like having the calendars for Portugal Holidays, Spain, etc I know that we have to manually insert the holidays in the System configuration for calendar's table but in this case, the idea is, if I'm abroad and inserting extra hours, by defining where I am, the system could check if it's an holiday or not. Thanks!

(...) Hello, I have a short question. I want to generate an Excel file with my data from the BPS datasource. I created an Excel template with a worksheet(test) and a table (mytable ) and a action create excel. I write the assignment like this: test!mytable and my data to the right cell. But I always get an error. (Invalid cell name) If I just want one data set and just write the cell names for each l (...)

(...) Hi everyone, I wanted to ask if anyone knows where or in which table the "Fixed values list" are stored. I am using a "Start a subworkflow (SQL)" to migrate data from our old sharepoint workflow tool to Webcon. Unfortunately, it seems that Webcon has decided that 'Choice fields' always require a GUID#Name to be populated. (Without this format I get an error and the subworkflow does not run). N (...)

(...) Has anybody an idea if and how it is possible to create a data source from two different data connections? I.e. I have a database (MS SQL) with visitor data and the CacheOrganizationStructure table in the webcon content DB (MS SQL, too). Now I want to create a datasource for a Choice field, where I could query for names in both table s. It is purely for reading data. Kind regards Klaus

(...) Hi everyone, I've been working on a "to do" app and I thought that a calendar report view showing the tasks to be dane with their date would be perfect. In the calculated columns of my standard table report I have a calculated column with a red square for an overdue task and green for all the "to be done n the future" ones. Works great. I created the same for the calendar report and there is a problem (...)

(...) ataAttachmets and [BPS_Content_Att].dbo.WFAttachmentFiles When im trying to add attachment like always going step by step in my workflow everything is ok - attachment is being added in both table s. But i also have a button making me back to previous step ( i am using Start Element()) and then when i try to add attachment it is going to be added only in table [BPS_Content].dbo.WFDataAttachme (...)

(...) Hi, in an Azure Active Directory environment it would be great to add an option to the people field which would configure it, whether external /guest users are selectable at all. Default value should be false. A customer worked around this by limiting the selection to a BPS group and adding AAD Groups as members of the group. No external user was a member of the AAD group. Technically this w (...)

(...) ike to bring in a specific report. I've checked how to do this and I came up with this query using the GET /services/data/v52.0/analytics/reportTypes/Opportunity But when I use the field as a Data table in order to check the information, the list comes empty. Anyone tried this? Do you know how to bring reports instead of using SQOL queries? Thank you!

(...) Hello, I try to render values from a rich text editor (multiple lines of text; Mode: Rich) as a column of a table on a Word-Document. But after the Wordfile generation the formatting is lost. In the database the value is stored as: X2OTestBla  Is it possible to generate the Wordfile with the given formatting? Thanks in advance. 1st Image: Value in the Rich-Text-Editor 2nd Image: Re (...)

(...) Hello, we use the actions "Convert word to PDF" and "Generate/Update a word file" and we assign the documents to a dynamic category. The category is not saved to the table WFDataAttachmets, the field (ATT_Attribute1) stays empty. in version 2021.1.4.55 it did work fine. Thank you! Balint

(...) Hi, how to set a filter in the data source for a data table so that search-filtering by date works. The usual filtering according to the scheme does not work: 1. "some date (iso or browser settings)" = "field in the data table with a date" (like attachment) 2. "some date (iso or browser settings)" like "field in the data table with a date"

(...) hello, I need to migrate local groups from production to dev environment, do you know database table or do you have sql that will show me all local grups, even empty one ? thanks in advance.

(...) 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 Pete (...)

(...) I have a problem with a report (simple display of a table with objects) for a process into which about 150,000 objects have been imported using the API. After opening the report, a long loading bar appears and then the message "Failed with unknown exception" and to check the calculated columns. There are no calculated columns in the report. There are no such problems for the previous case of 20,000 lo (...)

(...) the Aspose library which supports a template syntax. This allows to write code inside the word document to generate more sophisticated documents. Examples: - Instead of rendering item list/ data table s as table s in word we could generate "chapters" - Chapters could contain other chapters - Displaying multi line fields with rich text - Displaying pictures from attachments inside the document (...)

(...) me knowledge base articles where figures are not correctly displayed e.g. https://community.webcon.com/posts/post/the-picture-form-field/32 https://community.webcon.com/posts/post/wfelementdetails-table -description/34 and more. Could you please correct it? I tried various browsers, the results have been the same.

(...) hi I have datetime type fields i.e From and To , i want to check in current db table (WFElements), if datetime exist or not between two dates validating on form submit path using sql query. Issue: all the time showing validation error message , My validation Sample below: select case when ( SELECT count(*) FROM [BPS_Content_Prod].[dbo].[WFElements] where wfd_attchoose1='{1189}' (...)

(...) Hello. Is it generally impossible to use the above action type to create a new workflow item with a "filled" item list or do I have a mistake in my doing? I have a table (item list) where I want to start subworkflows from (depending on field value) where this line of the item list is "copied" to the new workflow. Creating the WF item is easy, but the table stays empty. Is this a bug in my qu (...)

(...) like that the system would allow choosing various options and populating the item list with the information. I know I can accomplish this with a choice field and then showing the details on a data table view. Thanks

(...) . Business wants to perform the following scenario. Batch of barcode lables from paper documents are to be scanned with hendheld scanner. Each scanned id is to be inserted into ID column of item list table . Based on the ID some additiona data are to displayed in other columns. What I have already done is the form rule that ADDs NEW ROW every time the value of ID item list column is changed. It works o (...)