Replies posted by Harm Horstman

357 Replies

Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

Add row in grid, with process flow

Erik, Ok, I understand more ore less, but is there any way to achieve what I want? Or is it a bad idea? Best regards, Harm

3
Erik Brink
Moderator
4 years ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

Combined Filter Conditions

In my opinion it's a bug, but most users won't mention it, because it only is relavant for larger data sets.

4
Harm Horstman
Superhero
4 years ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

Combined Filter Conditions

Ok, I will do

4
Harm Horstman
Superhero
4 years ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

What happend with stored procedure post_sync in IAM?

Any progress on this topic?

4
Harm Horstman
Superhero
4 years ago
Harm Horstman
Superhero
Harm HorstmanSuperhero

New Process action - Extract plain text from PDF filesOpen

Yes, this is possible, but I a try to come to a scheduled, full automatic process flow for PDF documents. (e.g. Invoices)

2
Harm Horstman
Superhero
4 years ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

What happend with stored procedure post_sync in IAM?

This sounds like a perfect solutions 

4
Harm Horstman
Superhero
4 years ago
E
Moderator
Erwin EkkelModerator

Show the applied objects per Translation objectClosed

I like it, or even better, show all related objects in a detail tab

5
Mark Jongeling
Administrator
2 years ago
Harm Horstman
Superhero
Harm HorstmanSuperhero

Add OAuth 2.0 to HTTP connectorCompleted

Hello Jasper,  This idea was mentioned before, bij Vincent Doppenberg more than a year ago. I have tried this. Spend several days on it, also half a day with a Thinkwise senior specialist. Finally came to the conclusion that this is not possible.  There is one step in the authentication cycle, which cannot be taken inside the GUI.  Maybe I need more information about process flows and the HTTP connector.  Ideally, it should be as easy as how this is done in Postman. If you are sure, it is already possible in the SF, can you drop a step-by-step instruction in the portal?         

11
Harm Horstman
Superhero
2 years ago
B
Rookie
BarryRookie
published in News & Blogs

To the Cloud! Leveraging Microsoft Azure PaaSBlog

Thank you for the clear explanation of options within Azure. I would like to share our experience with those who find it interesting. We have quite a bit of experience with fully hosting applications for small work groups from the Azure cloud. The following configuration works well for us for a working group of up to 10 users: Azure VM (size = B2ms) for WebApplication + IndiciumAzure SQL for IAM and END databaseAzure FileStorage for storage of photos and other files One of the advantages of using Azure SQL database, is that backups, up to 30 days back, are already made automatically. But there are many more options. A considerable cost saving is possible by scaling down the databases outside working hours. During working hours the END database runs on S2 and the IAM database on S1. After working hours, both databases can be scaled back to 'Basic'. Scaling back to Basic is possible as long as the databases are no larger than 2 Gb. Scaling up and down the databases can be automated with

8052
Jasper
Administrator
4 years ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

Conditional formatting without specific column in forms

New functionality in an existing application, has a lot of code fields, for this we found out to that is good to make use of a Fixed Width (Consolas) font. Because with this font, for example, the difference between 0 (number zero) and O (letter O), is easier to read. We don’t want to change the default font and bother other users with this experiment. What we actually want, is the option to setup a default font for the grid an for the form per table.

9
Jasper
Administrator
4 years ago
Jasper
Administrator
JasperAdministrator
published in Questions & Conversations

Multirow task execution

Does this feature also work for reports?  I need to make a report with an output based on selected rows in a grid.   Does Multirow task execution still work from version 2020.1?

229836
A
Captain
1 month ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

Conditional formatting without specific column in forms

Ok, for the Universal UI, I can understand this.  

9
Jasper
Administrator
4 years ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

How to use cursor_to_col_id in Default procedures

Actually this is what I try to do now.: IF @cursor_from_col_id = 'document_number' AND @invoice_id IS NULL IF EXISTS (SELECT 1 FROM invoice WHERE document_number = @document_number) BEGIN EXEC dbo.tsf_send_message 'document_number_already_exists', NULL, 0 SET @document_number = NULL SET @cursor_to_col_id = 'document_number' RETURN END Whatever I try, it does not work. Even when I remove the tsf_send_message line. The model is in 2019.1, the GUI is Windows 2020.1.12 The output of the procedure, seems to be correct.

7
E
Sidekick
4 years ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

How to use cursor_to_col_id in Default procedures

Yes, only when using the Enter Key it works fine. Good to know this, but also the Tab key is often used by users. Is there any reason to not enable this option? In my example tsf_message, is triggered in any case (mouse, tab, enter) on wrong input  

7
E
Sidekick
4 years ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

Conditional formatting without specific column in forms

Perhaps that is a good solution, but I do not yet see how that will work

9
Jasper
Administrator
4 years ago
Jeroen van den Belt
Administrator
Jeroen van den BeltAdministrator

Save your own prefilter queries / filter expressionsOn the backlog

I like the idea and also the suggestion to share a filter with others. A nice addition to this would be the possiblity to save sort order and column settings. See my last post:https://community.thinkwisesoftware.com/ideas-18/save-your-own-filter-expression-sort-order-grid-column-settings-as-personal-variant-1026  

6
F
Rookie
1 year ago
Harm Horstman
Superhero
Harm HorstmanSuperhero

Add 'Execute Procedure' as process action type for Process FlowsOpen

Hello Mark, This sounds like the solution I am looking for. I will try it. Thanks for the suggestion! Best regards, Harm    

7
Mark Jongeling
Administrator
3 years ago
Harm Horstman
Superhero
Harm HorstmanSuperhero

Add 'Execute Procedure' as process action type for Process FlowsOpen

I would like to leave the connection string empty and the SQL command to be executed on the end database. With a Connection String containing username and password, we introduce a security issue.  Another challenge is to make connection strings flexible for multi tenant application scenarios.

7
Mark Jongeling
Administrator
3 years ago
Harm Horstman
Superhero
Harm HorstmanSuperhero

Add 'Execute Procedure' as process action type for Process FlowsOpen

The problem is, that trusted connections cannot be used on AzureSQL databases.  

7
Mark Jongeling
Administrator
3 years ago
Harm Horstman
Superhero
Harm HorstmanSuperhero

Multirow report executionOpen

Hi Bart, See Jasper's post Multirow task execution I'm using the function on a regular base to execute a task 1 time, while it affects all selected rows. This would be very useful for reports too.  BR, Harm

6
Erik Brink
Moderator
4 years ago
Harm Horstman
Superhero
Harm HorstmanSuperhero

Multirow report executionOpen

It will be used for analytical reports and overviews. For example, to make an overview of sales orders per employee, issues which belong to projects, etc.. The user should be able to select 1 or more rows in a screen/grid. And the where clause in the report can make use of the xml to filter the data related to the selected rows. With SQL Report builder, it wil be easy to achieve. Without multirow , it is difficult to create a single PDF report, for a selection of rows.

6
Erik Brink
Moderator
4 years ago
Mark Jongeling
Administrator
Mark JongelingCommunity manager

Widen the Query input field at Calculated field (Data model)Completed

There are several other fields for which I have the same wish. An option, 'Max width' (Y / N). To be able to use in the SF for user applications would also be very nice.

3
Mark Jongeling
Administrator
4 years ago
Mark Jongeling
Administrator
Mark JongelingCommunity manager

Creating reference task should automatically fill-in the target table from parentCompleted

No, what I meant to point out is that in the SF itself, the lookups prefer to run as suggestion instead of combo, because combo boxes are not user-friendly in case of long table and column names.

6
Harm Horstman
Superhero
4 years ago
Mark Jongeling
Administrator
Mark JongelingCommunity manager

Creating reference task should automatically fill-in the target table from parentCompleted

OK, that is a point, but developers should know the name of tables, columns, etc... At least a part of it. It will take some time before we start developing apps in Universal GUI.      

6
Harm Horstman
Superhero
4 years ago
Harm Horstman
Superhero
Harm HorstmanSuperhero

Add OAuth 2.0 to HTTP connectorCompleted

Thank you for the clear explanation in the Docs.  The scenario's we see most added value, are with access on behalf of end users. Once this becomes available, we can start the implementation of various outstanding ideas.      

11
Harm Horstman
Superhero
2 years ago

Badges

Show all badges
Terms & ConditionsCookie settings