Questions & Conversations

 Hi,We are trying to show the graphical representation in universal GUI with different departments and its employees.Steps followed:Created Cube view  Added Cube Field Added Conditional Layout with condition “department : is not emptyThrough GUI we were able to see the Pie chart but in Universal it was showing the blank screen with “This pivot type is not supported”.We could not find much in documentation or community about Chart and Cube.Is it possible to get fields from multiple tables to show them in one Chart?Could someone help us how to show it in universal ?Attaching the screens...

I can no longer navigate to my local indicium instance. It's giving me a 500 error and the log shows this error: 2022-12-05T13:46:28.4343183+01:00 8000000b-0009-ff00-b63f-84710c7967bb [ERR] An unhandled exception occurred while processing the request. (ffba027a)System.InvalidOperationException: The MetadataAddress or Authority must use HTTPS unless disabled for development by setting RequireHttpsMetadata=false.Where do I set this setting? I can't find any documentation on this. Do I set it in the appsettings or web config? And in what section does this need to be added?

Hello, is there any idea when we can expect the domain control ‘Sqleditor’ to be implemented in Universal?We would like some endusers to be able to create their own validations in the end product, so an sqleditor would be ideal to implement that. Thanks in advance,Bram

Normally when I press the ‘Add’ button, the cursor is located at the first column in the form (or the @cursur_to_col_id). This doesn't happen when I start ‘Add row’ from a process flow. How can I get the same result? 

We are pointing with a (generated) deeplink in e-mails to our customers and suppliers. These pointers refer to our good old WebGUI portal.I really love the universal GUI and I would like to generate these deeplinks to Universal for a faster acceptation of Universal (and close the old WebGui portal)Is deep linking already possible in Universal or planned? 

Hi, We are using the Univeral GUI on Android tablets for scanning barcode on products. We have noticed that often the barcode scanner has trouble to scan the barcode. In the Mobile GUI the scanner works better and faster, because there is a red line where you can put the barcode on the camera. Is there any way to improve scanning using the Universal GUI? 

Hi,After I upload a file I am getting “:443” in the upload link. Which means I can't access it via external app with the preview link.Link after file upload:But if the document is generated it doesn’t get “:443” in the link.What is causing this? And how to fix it?    

Hi, Sometime I see this; Why, how, and who gets to see this? I don't want any end users to see this. Is it because I am admin? Or.. something else. Thanks! Alex  

Why is it still not possible to align numbers also in grid views left?In some cases, this is desirable, especially when a ID field, for example an invoice number which is an integer (eg. 20220014).I know, there are tricks to get it done, but we don't like to use expression fields for this. 

Hi, In our application we have some expression fields in a form which has auto-edit enabled. When auto-edit is enabled the text in this field gets greyed out like this:We want this text to be black eventhough auto-edit is enabled. I've tried doing this with a conditional layout specifically set for this field, but even then the color gets overwritten somehow. So the next step is doing this by changing the css values.I've checked which element and  css class I need to edit the color, which are the following:I've changed the alpha channel from 0.38 to 1 and the text color changes to black:So I took the css class and made the change in my custom.css file. Restarted my application. But nothing's changed. Anyone know what I'm missing? Thanks!

Using the dbo.tsf_user() in a default value expression (see image below) leads to an error in execution of a model (after an upgrade from SF2021.2 to SF2022.2) We experience the following error during execution of the source code:  Error: 'Column "dbo" is not allowed in this context, and the user-defined function or aggregate "dbo.tsf_user" could not be found.'.Any ideas?

One of the major trends in IT is the tighter integration of Communication, Collaboration and Core System tools. Microsoft Teams and Slack are communication channels that not only replace email for many conversations and notifications, but also provide great added value for collaboration. Microsoft Teams far outperforms any of their competitors on collaboration, thanks to being embedded in Office/Dynamics 365 and allowing for custom in-Teams apps, integrations, etc. Slack has been acquired by SalesForce recently with the same purpose of tightly integrating a collaboration tool with a Core (CRM) System:Together, Salesforce and Slack will deliver the Slack-first Customer 360 that gives companies a single source of truth for their business, and a single platform for connecting employees, customers, and partners with each other and the apps they use every day, all within their existing workflows.In light of these trends and the high adoption rates of tools like Teams and Slack, I am surpris

Hi all,I have a requirement for which I need to encrypt and decrypt column data for a specific table or view. The application is on Universal GUI.The user needs to click a task button provide the password save it in the session cookie. When the user will want to see the decrypted information of the specific encrypted related View. A function will need to have access to the session cookie to retrieve the entered password of the user. This view will utilize the function to decrypt the column values upon refreshing the document. If No Password OR Wrong password was entered the view will show the encrypted information.  Any other idea how to implement something like this differently would be useful. *Note: The database is already encrypted and that protects the data from outside theft, however it does not protect the data from Administrators within the company or people that have dattabase access. This solution is for covering the later part.Edit:Below functionality of Azure SQL will b

Any community suggestions how to consult an API (via flow I guess) when adding/editing a record. If a user exits a column in a form (and it is filled) I want to check its value through an API. 

Hi all, The import function has the option to turn on ‘updat existing rows’. In our project, the users want the checkbox to be turned on by default. Would it be possible to set the ‘update existing rows’ to be turned on by default?  Kind regards, Mark Leunissen

When I open a screen (in windows GUI 2021.1.17) a subject that has the option "Hide breadcrumb (main scr.)" checked by screen type, the breadcrumb is still displayed. Am I doing something wrong?

Here’s a very simple question I somehow cannot figure out. How does one authenticate a connection to an off-premise SQL Server instance such as Azure in software factory? I’ve added a runtime configuration for the Azure database but there is no means here to store a username and password.I assume the current runtime configurations pick up the domain user credentials to connect to on-premise databases but this obviously doesn’t work with Azure databases.

What settings steer the functionality of filtering in the grid? I have 4 similar lookup fields,  ID with lookup to base table..  and as far as I can see 2 have a filter option like below and 2 don't..  what setting causes this difference?  I want all fields to have a similar filter option.   

So, Currently i`m using a 3rd party api. This one is currently divided by 2 parts. 1 where we call an api endpoint to retrieve a list of objects. From there we scrape them one by one and push them to our database.Part 2 is where we select every row where a certain status = 0. Now here comes the weird part. Due that the api endpoint has a need for a certain id. So the most smartest decision would be :  SET @url = CONCAT('<secret_api_endpoint>/', @documentId)Sadly enough the last part where we insert the information to the database hasnt even reached. So something went wrong when calling for the api endpoint

When the application is started for the first time, the reports are stored locally in the "C:\Users\UserName\AppData\Local\ThinkwiseSoftware\GUI\GUI\Cache\Images\NIVERPLAST_4.50\Report" folder. With the release of a new GUI, I understand that the system will replace the local GUI folder and it will also take a little longer. However, how can the performance be improved for the daily start-up of the Windows GUI without any changes having taken place. For example, is it really necessary that the reports are replaced in the ..\Cache\Images\NIVERPLAST_4.50\Report" folder every time? First start-up of the applicationIsn't it possible to a verify or the application if a report has been modified within a project version and only updates the report then?   ←  Left| First start-up / Start-up when local folder incl. files are already exist | Right →  

It is very unfortunate that the 'Manual' option is no longer available.We used this option very often to have more control over the scripts that are run on the database. For example, it is not always desirable to perform the Checks and Indexes scripts, especially with larger databases.I would appreciate it if this option comes back in the platform.The Release plan blog mentioned that the creation process has been simplified, in my opinion it is not.

Hi Everyone,We're populating a table with over 9 million addresses. These addresses serve an auto-complete lookup. Whenever a user starts typing, the lookup displays results that match what the user typed thusfar. This worked great when we had 10 addresses in the database. Now that the database is filled with over a million addresses, the lookup grinds to a halt whenever the user starts to type, uses the caret or clicks the looking glass to open the selection form. How do we handle tables containing a large amount of records with an auto-complete lookup?The database is still getting filled. Once filled, we'll create an index on the table. This will speed it up. What other things can we do to keep the UI user-friendly and responsive? Can the looking glass and/or the caret be removed from the field, for instance?We're using Universal, but the Windows GUI suffers from the same lag. Our database is an Azure hosted database.Thanks,- Alex.

Hi, in our application we create users and with the API endpoints mentioned in the topic below we also create and maintain them in IAM.Intelligent Application Manager - API on UserIn some cases it is necessaryto rename the user id and for that I want to use the task “rename_usr_general” in IAM. Is there a way to use this task as a API endpoint or is there a complete list of all the endpoints Indicium offers?

Hi, For our application, we are facing on several screens performance issues since we are in production and the set of data is growing.Some examples:For a table we moved some big fields containing json content already to a separate table, and made them visible in a form tab. But when click on the form tab, it still will take > 30 sec before it is loaded. It looks like the full table is loading before the related record is shown. For a screen we have defined a form layout to show (summary) details of related child records. This is currently build in a view, but when loading that tab it will take some time before the (filtered) data is shown. For a table we are showing lot of extra data with expression fields as the base data is not stored in that table, but in related tables. It is not preferred to have that data stored twice, als in the ‘header’ table to reduce the number of expression fields.Are there suggestions to improve the performance for loading the data in a form detail?

 Hi! I have put speciifc label for each group of columns as you can see below .I did this from subjects->compomontes>grid->group label .I want this label to be automatically generated based on the current month as the data is now hard coded .It there any possibility to do that with a layout or maybe other procedure?