Skip to main content

Questions & Conversations

Ask a question or have a conversation about the Thinkwise Platform

  • 3,024 Topics
  • 10,426 Replies
3024 Topics
mperrott
Hero
mperrottHero
asked in Questions & Conversations
Azure SQL Database for Software Factory

Wanted to ask if there is currently in the plans, or if it is working already to have the Database of the SF in Azure SQL ? A Goal we want to achieve, is to move everything to Azure, and as a first step just wanted to know from DB POV.From GUI POV I suppose an on-premise machine or Azure VM is still needed and required.

843
V
Moderator
R
Sidekick
Ramon
asked in Questions & Conversations
Auto refresh table variant in Universal

Is it possible to use a scheduled process flow in Universal to refresh a table variant? I want to auto refresh a table variant using an interval, but i can't get this working. The "Auto refresh” functionality on the subject is also not working. That should be the normal way to do this, but i think this isn't implemented in Universal yet?I'm using Universal 2021.1.10.0.

1262
V
Moderator
R
Sidekick
Ramon
asked in Questions & Conversations
Order "Searching in" columns in Universal

I want to order the columns in the "Searching in” section when using the search bar in Universal. How can i achieve this? It is possible to order columns in the data model, but primary key columns must stay at the top of the table. So i can't order the columns as i want.Search bar with "Searching in” section 

663
Erik Brink
Moderator
Arjan Sollie
Thinkwise blogger
Arjan SollieThinkwise blogger
posted in Questions & Conversations
Email queue with email attachments

This is an Archived topic. The solution is available in the Thinkstore inside the Software Factory.GoalSending emails from within your application is a common feature and can be implemented in many ways. However the traceability of sending emails from your application is often difficult. Therefor it is very usefully to gain some insights into which emails have been sent to whom and whether the email has exactly been sent. This topic demonstrates a basic setup for gaining insight into your email traffic. SolutionFirst of you will have to set up some tables. This example will also contain tables used by the Thinkwise Reporting Service. This topic will allow you to email attachments created by the Thinkwise Reporting Service. This topic will not explain how the configure sending emails with a template. If you would to know how to do that, look at this topic: Example email module. Create the following tables (if you do not use the Thinkwise Reporting Service, ignore the reporting_service_r

4051
Robert Jan de Nie
Thinkwise blogger
Blommetje
BlommetjePartner
asked in Questions & Conversations
Dynamic tab page titles

Hi all,Is it possible to set a tab page title based on context?  Example; Open Table Account - Select Account.  The tab shows the account name.  So what I currrently display on the red line - I want to display this on the green line.   I thought i saw this somewhere, but now.. I cannot find it. 

602
Blommetje
A
Captain
Andre te RaaCaptain
asked in Questions & Conversations
What are the rules for conditional layouts in a cube view?

The documentation is not very clear about conditional layouts in a cube view. I added a special column ‘conditional_layout_ind’ in a view for conditional formatting. The values of this column can be 1, 2 or 3. For the cube field of this column, I specified summary type ‘Minimum’. Now I want to have a conditional layout on the cube field ‘quantity’ based on the (minimum) value of cube field ‘conditional_layout_ind’ (e.g. Equal to 1).This does not always work well and I don't know why. But if I drag the cube field ‘conditonal_layout_ind’ into the values area, I get more cells colored.The problem is, I don't want to have the ‘conditional_layout_ind’ in the cube view.How can I achieve conditonal formatting for this cube view?    

1062
A
Captain
R
Rookie
Romario DindajalRookie
posted in Questions & Conversations
Universal gui 2021.1.0 POST METHOD 500

Dear Thinkwise,I succesfully did the upgrade to the newest universal gui 2021.1.10 on my azure web app. I checked if there where some hotfixes for the IAM or the SF fortunaly there where none. I am just trying to add a new record so i am doing a post request and I get an internal server error (500). This is the error that i get: Internal server errorThe get methods works fine.I synced my SF to the IAM this was also succesful and on the windows enviroment connected to the sf or IAM database it works how its supposed to be .I hope u can help me for a solution.Kind regards,Romario

631
V
Moderator
R
Superhero
René WSuperhero
posted in Questions & Conversations
Limit integer field length or replace with numeric(n,0)?

 I’ve got some fields indicating an integer “Quantity”, and they have a min/max value to prevent excessive user input. For example a purchase order line quantity or a stock / inventory quantity.The problem is the following (animated gif):There is not really a restriction on the integer field, in contradiction to the numeric field. If you press and hold “9” for a while it will fill up and when tabbing to the next field it's cleared (unless it's lower than int.maxvalue).If you do the same in a numeric(4,0) field it stops after 4 times 9. In a user point of view this is more friendly: The user knows exactly what the limit is, therefore developing a default / layout concept is not necessary.If you do develop a default for the integer field, it won't be executed when the value is passed int.maxvalue. That is unclear for our users if you want to warn them about the excessive number.Thing is we don't want to bother our end users with a ‘random’ clear of a field value. We could solve this by r

692
R
Superhero
Blommetje
BlommetjePartner
posted in Questions & Conversations
Proces flow - open screen after set time or event

Hi all,I have set up the report generator, which is great. I also have an upload to Azure (developed outside of SF) which updates my Db with an online path to the file in the cloud. All is good. When a client creates a pdf (e.g. an invoice) with a task.The following happens; click task → insert in Table Rpt_queue → file is made. → File is pickup by magic → uploaded to Azure → File path is inserted in an extra column in the rpt_queue. An update trigger fires and send the file back to the source table (e.g. invoices) AND to a table 'Document Pool’. The document pool is where we collect ALL files on this account. Invoices, reports, bills, contract, etc.  Anything generated?  → boom, in the document pool. So, after the task has fired, we use a process flow to open this document pool in a new tab. All good. HOWEVER, due to the time it takes to generate and handle the file, the doc.pool is not updated yet. This takes on avarage 20secs. Is it possible to either delay to process flow with 20se

973
Mark Jongeling
Administrator
E
Sidekick
Edwin SaanSidekick
posted in Questions & Conversations
Menu items not translated (After upgrading to 2020.2 version)

I can’t figure out what’s going on here, but the tile menu items are indicated as not translated, while they are translated for sure. For the subjects the translations are given correctly..The first screenshot is the menu. The second screenshot is when opening [werk_rapport]. There you see in the top of the figure the translated words ‘werkrapport’ ‘werkrapporten’ ‘alles van datum’ etc. No [ … ] term to see. But on the menu they are all in [...]. We use this menu for about 2 years now so all terms are translated. But after upgrading to the 2020.2 SF I see this behaviour. I tried several things in the application but was not able to fix this. Anyone an idea?   

332
E
Sidekick
E
Sidekick
Edwin SaanSidekick
posted in Questions & Conversations
Using SVG icon on a task variant

Has anyone seen this when setting an svg file as Tile image OR as icon. I want to show a SVG icon ina task in a (mobile) Tile menu but then this happens.I have changed all the other icons to SVG and that works fine. (However I did not figure out how to change the color)But when stting an icon on a task the file content is shown in the APP. Not the icon??  

744
E
Sidekick
M
Captain
Marc FerketCaptain
asked in Questions & Conversations
Bug Universal 1.8 with number of columns in task-form?

In the blog  “New in Universal (dec 2020): More process flows actions, install as PWA, form column settings and more improvements” Erik mentioned “The form in task and report popups listens to the SF setting for Number of cols in form”. Looks like we’re experiencing some sort of bug, because using Universal 1.8 we only get all the fields in 1 column….Changing the setting to 2 gives an expected result in the Windows GUI, but Universal keeps using only 1 column…When the number is set to 2 it looks like the form starts with 2 columns and then switches back to 1 column (in a split second).I've tested this situation (and experienced the problem) using Edge and Chrome.

702
Arie V
Community Manager
Hugo Nienhuis
Superhero
Hugo NienhuisSuperhero
asked in Questions & Conversations
Limited number of applications per IAM

I am wondering whether there is a limit to the number of applications per IAM? 

251
Mark Jongeling
Administrator
R
Superhero
René WSuperhero
asked in Questions & Conversations
Unable to execute the AutoML get training options connector. The AutoML service URL is missing.

I've noticed the following ‘error’ in the Indicium logs (2021.1.10, but also older versions);2020-12-29T09:11:01.7549972+01:00  [ERR] Unable to execute the AutoML get training options connector. The AutoML service URL is missing.We don't use AutoML and can't remember we've configured or touched something in the SF. Why is it filling the log files with such lines? What can we do to solve this error? I want the log files to be clean.

661
Mark Jongeling
Administrator
R
Captain
Roy van UffelenCaptain
asked in Questions & Conversations
Start process flow on key press

I created a process flow and have tested this with an initial task. This initial task doesn't have any code attached to it. Starting this process through this task works.Now I want to start this process flow by pressing a key-combination.After updating the model (from within the windows desktop application), this key-combination does not seem to work. Also tried Ctrs-Shift-Alt-H combination with the same result.Is there something else that I should be doing in order to start this process flow?

1192
R
Captain
R
Captain
Roy van UffelenCaptain
asked in Questions & Conversations
Error during deployment at smart source code generation

First time I have need for a deployment after upgrading to 2021.1.During smart generation of the source code, there is a problem with writing Groups to disk. I get the following error-message:The Program objects are written to their usual place (D:\thinkwise\projects\<project-name>\<version>\Source_code\Program_objects.Have already created an issue at tcp.Any ideas that help me continue this deployment are welcome. Want to add at least a new domain and column.

993
Mark Jongeling
Administrator
R
Captain
Roy van UffelenCaptain
posted in Questions & Conversations
Store sensitive data

There are multiple connectors that require authentication either bij username-password or apikey. Since these are sensitive data I want these to be encrypted.These values can also change between deployments, as production connections are different than in development.Questions:What are the options to encrypt these data and are the advantages/disadvantages of these methods?What is preferred method with Thinkwise?

1694
R
Captain
Jaap van Beusekom
Vanguard
Jaap van BeusekomVanguard
posted in Questions & Conversations
Universal - Where or when export function

Hi,When is “export to Excel” functionality available in the Universal GUI?Is detailed roadmap information for Universal GUI general available here @ community. It’s easy to look at it before I have to ask it here :-)Jaap

591
Mark Jongeling
Administrator
O
Vanguard
Onno SpoorVanguard
asked in Questions & Conversations
No new version Indicium (Basic) 2021.1?

Am I correct, to believe that there will be no new version of Indicium (Basic), but use the Indicium (Universal) instead as only Indicium?

622
V
Moderator
Blommetje
BlommetjePartner
asked in Questions & Conversations
No ... after text for a task

When you create a Task and set the vars to hidden, the name of the Task is fixed. When you set the Vars to Read-Only of Editable, you suddenly get … after the name of the task. See, BL… (with var to Read-Only)  And with Hidden var.  This look way nicer and less confusing. I cannot seem to change this. Anyone out there that knows if this can be done?  

341
E
Moderator
R
Captain
Roy van UffelenCaptain
asked in Questions & Conversations
How does Conditional layout actually work?

Within Conditional layout you can have multiple instances. I get the impression that only one at any time will be chosen, even when one changes the font and another the background. It seems that there is an order in which the conditions are checked and implemented.I'd like to know the order in which the conditional layout are checked, whether the first match terminates further checks, how I may influence the order and how I can combine checks.Also I'd like to know how multiple conditions on a single conditional layout are combined. Do you have to match all conditions, or one of the conditions, or maybe something else.For instance I have two conditional layouts, one for font and another for background with different conditions. How can I combine these without having to implement a combined conditional layout.

1331
E
Moderator
R
Rookie
Romario DindajalRookie
asked in Questions & Conversations
A server error occurred universal login

I got my environment setup in azure and the universal login screen is approachable from every IP, the way it should work.The problem is when i want to login. From my home network is working just fine i can login and nothing happens. If I login from my work network then I get the message 'A server error occurred’. This also ocurred when a partner from his home try to login with the same user.I hope someone knows why this happens and how to fix this!

1493
Anne Buit
Community Manager
Blommetje
BlommetjePartner
posted in Questions & Conversations
Set max number of lines in form field

Is it possible to set an max number of lines a user can enter in a field? I have some address fields that I want to cap on 8 lines max (or the print pdf won’t look good). I can only find how large the field is (looks) and a max number of chars. But not lines. Anyone? 

361
Mark Jongeling
Administrator
R
Captain
Roy van UffelenCaptain
asked in Questions & Conversations
Triggers vs Process flows

On the one hand you can use a triggers control procedure for performing extra actions. On the other hand you can also accomplish this by using process flows.I'm curious to find out reasons for using one over the other. Are the Trigger-procedures old functionality that will be deprecated soon? Or are Trigger-procedures the way to go?When do you use one over the other and why?

2872
V
Moderator
B
Captain
Boudewijn
asked in Questions & Conversations
SF - add 'tables' entry to data menu (skipping 'data model'-diagram-listing)

12 out of 13 times I click on the ‘data model’-entry under data, that is so that I can get to the table listing.Could an entry for tables be added directly to the data-menu? Or switch the order of tabs, so that when clicking ‘data model’ the tables-tab would be foremost, having diagrams based on those tables behind it (and perhaps only as a detail of those diagrams, the tables that are visible in the diagram).

445
B
Captain

Badges

Show all badges
Terms & ConditionsCookie settings