Solved

I am looking for a way to simulate the Export functionality that is an option in the GUI, but turn it into a process flow so I can run it as a background task. Also prevent a user having to make certain choices on what to columns to export and to what file format it will be.Certain customers desire large data exports and the .xlsx option will cause OutOfMemoryExceptionOut, but .csv seems to succeed. This process takes quite a while to complete, even though the view itself has the data selected in less than 10 seconds. All this is reason we want to take away the options for customers and put the wait as a background process.What are my options in this case?

Hi, Is it save to assume that icons that cannot be updated with this feature are not used in the model? And can be removed without issue.If so, would it be an option to create a prefilter/(or task) ‘Unused icons’ - similar to whats available on the Domains-tab. Blommetje

I have some big files to upload to Drive/Sharepoint via Graph. How do I model this scenario in Thinkwise?Steps to Upload a Large File Using Resumable Upload Session Create an Upload Session Use the /drive/items/{parent-id}:/{filename}:/createUploadSession endpoint to initiate the upload process. Request: POST https://graph.microsoft.com/v1.0/me/drive/items/{parent-id}:/{filename}:/createUploadSession Authorization: Bearer <access_token> Content-Type: application/json Body (Optional): { "item": { "@microsoft.graph.conflictBehavior": "rename", "name": "your-backup-file.bak" } } Response: The response contains an uploadUrl that you use to upload the file in chunks. Example Response: { "uploadUrl": "https://upload.url.for.your.session", "expirationDateTime": "2024-11-16T23:59:00Z" } Upload the File in Chunks Divide your file into chunks and upload each chunk using a PUT request to the uploadUrl. Chunk Size: Recommended size: 10 MB (10,485,760 bytes). Maximum size: 60 MB (62,914,

Is it possible to automatically refresh visible detail tabs when a field is changed and auto-commit is enabled? 

We have a process flow which will be started by a task. It wil open a document in popup, and after selecting a record in that document, we need to continue the process flow with this selected record. We want to prevent building two process flows, as it will be difficult to save the selected row in one process flow and pass it to the next one. Now i know there is a process step called Manual. First question is: What does this process step do? The documentation is not very elaborate on this. Second question, can we use this manual process step after opening a document, to wait for user input, and continue after a new task was clicked in this same window?

 How can I add extra separate attachments in the process flow from the project folder ?

Hi!We have for now some places in app where we do want some precision for our fields, usually we use type numeric with different specifications depending on the needs.The problem that we have is that we don't always want to show all the decimals, we need them for some calculations still.It is already something to do that and we just didn't find out what? Is weird to display that many decimals if the user doesn't need them but for background calculations are needed. (This example maybe is a bit to much, but for 6,8,10 decimals can be some situations and still are a lot to display)If not, we don't want to fake with with a field of another type with some format and so, maybe we can have another setting on the domain for this situations where we can specify display decimals. (other cases can be for description fields for example if you want just a preview of description and maybe more uses).

 Hi!We have quite a few dropdowns which are pointing to variants and seems like for all of them once a few weeks we get them stuck on this "Loading...”.The strange part is that if you let it open and wait to dissappear, click again on the dropdown, the results are there.Do you have any idea what is going wrong? Is not for a specific table and some variants don't have anything fancy, just some prefilters. If we try directly with the table/view, the problem does not persist. 

Hi, im trying to retrieve the parent_row_id from a newly added row. However @ and T1 both dont work. Anyone knows how I should fix this?select top 1 step_nr + 1from calculation_step--where calculation_method_id = t1.calculation_method_id «order by step_nr desc  

I am trying to do something like this; According to the documentation change filters should not start an Universal flow, but it should start a system flow, and how else then a user changing the filters could a flow be started? So, what I try to do is not to use the step to change the filters but to get the result of the user doing so, but nothing happens.Am I missing something or is this just not possible?What I want is to know the selection so that I can apply the same selection to a report on the page, while the page is based on another Query.I’m also wondering if the report would be filtered when based on the same subject / table as the user is viewing?Being able to run a task on all the rows within the current selection ( not those selected by the user could also help ), as I manage to only output the report based on the users selection in the grid, but I would also like to create and option comparable to the export option; Daan  

Hi,I am trying to enable 2FA bij selecting the login verification option “Password and TOTP token” in IAM. When I try to login with that account for the first time a dialog is shown with a QR-code to register. After scanning the QR-code from the authenticator, the App is registered and a TOTP token is provided. However no validation token is provided, which has to be entered next. I have tried this with Google Authenticator and Microsoft Authenticator with the same result. I have entered an existing e-mailaddress at the user level, but to no avail.Did I miss something that needs to be configured or has someone encountered the same issue and can provide me with a solution?I am using 2024.1

Hello! In our project we have a task with some parameters that are completed by the user from the pop up. We put that task into a process flow, it’s the third step in the process, and when the pop up appears the fields that are references to another table are not loading any data. And also if you click on the look up icon is not loading any data even if in the table there are records.Do you have any idee what this can cause this problem? because when we are running the task from the table is not having any issues.

Hi we have a table for invoices, and another table underneath it for the invoice lines. When we add an invoice line and press ctrl + enter, the sum of the invoice is updated. However, when we press ctrl + + the sum is not updated.So, the sum is only calculated after saving an item, but not when adding a new item. How can we make this work?

When I try to execute a task on an empty detail screen as per the odata manual at OData API | Thinkwise Documentation (thinkwisesoftware.com) i get a 500 error. The Error in the live log is not very useful unfortunately and we are completely stuck on this. Any help would be welcome.The api call:{baseurl}/order_vbs(order_nr='1015007')/empty_detail_ref_order_vbs_kwartaal_gegevens_order/task_herrekenen_kwartaal_gegevensWe are not passing any parameters in the data json as they are not required for the execution of this taskI have checked (and double checked) the table names, reference, task name and PK ;)The line in the live error log:  

Hello everyone!We encountered a problem with the PDF viewer on Android's Chrome browser. It does not display the PDF-viewer, and we tested this on a more recent version of Android, and an older version of Android:Now this is what we get when we open it on Chrome. When we open it on a browser like FireFox, or Microsoft Edge, we get exactly the PDF we ask for. It shows the PDF viewer, on the newer Android and older Android versions. In the following release notes this should have been fixed: We have our web server settings set correctly as far as I know. So why would it still fail to show on Chrome? It does work on Firefox and Microsoft Edge. This is already good news, but we cannot predict what kind of browsers our end users will use.

I want the message to abort so i added the '1’When using '0’ it warns and everything is ok See also live error log Is this a bug?

In the windows GUI, the pie chart "works”, but in the universal GUI it results in an error. I also tried to change the order & colors using conditional format. Without success. Is that not possible?   

Hi,I have a table named 'Activity' that includes a lookup to an 'activity_type'. Depending on the selected activity type, I modify the layout to ensure users input the correct values.Additionally, there is a lookup to a 'Carriage' table. Based on the activity type, I need to display either incoming or outgoing carriages, and filter these carriages to match the same origin and destination values, which are also fields in the 'Activity' table.Previously, I managed this by duplicating the 'carriage_id' field and displaying a different field based on the selected values. I then used a trigger to populate the original 'carriage_id' to ensure it is always set.This approach feels complex and cumbersome.Are there any more efficient methods to achieve this?Thank you.Blommetje

Hi, For several screens I want to Implement the max no of rows. Say my Accounts table, ordered alphabetically from A to Z. When I add a new account with name AAAAAA, it surely displayed on the screen. However, when adding company ZZZZ it’s not displayed, resulting in the The saved data can not be displayed on this screen. SHOW -- snackbar message. What options do I have to work around this? A process flow with a Go to Row comes to mind.. But perhaps there is a more general solution for this? Kind regards, Blommetje 

We need a simple solution to show text files in the preview better than below.In dark mode the back ground color should be white or the text colors inverted.And is there any possibility to wrap the contents of a text file in the previewer? Any suggestions?

We are running [indicium] in containers and I have a question on the database connector. What are the available ODBC drivers? We need SQL server (obviously) and PostgreSQL And in the (near) future perhaps also Oracle. https://docs.thinkwisesoftware.com/docs/sf/process_flows_connectors#database-connector

Hello everyone, I have a task which needs to be able to update multiple rows in succession, in this case, the pop up for each row is the best option that gives the most readable code. Seeming in this screen, no large chunks of data needs to be processed at once. But I ran in a problem: when I select multiple rows and and this execute this task, it only updates one row. This task only contains one field to make sure we target the correct row in the database. Normally it is hidden, but I set it to read only to see how it would behave. This is how the task is set up: Await result was set to Yes (no progress bar) after this screenshot was takenWhen I execute the task in the situation intended for our end users, it behaves like the following:I select multiple rows on which I want to set the slider to the off positon via the task. But instead of updating multiple rows in succession, it only updates one row at a time, the first one I selected during that multiselect.When I set the field which

Hi, I'm seeking assistance regarding an issue I encountered during the creation process in Thinkwise Software Factory (SF) while executing source code. The error message I received is as follows:An unknown error occurred while executing '/* Rename changed datatype image */exec sp_rename 'image', '__image__', 'userdatatype''.Error: 'This action cannot be performed on a system type.'.It seems that the error is related to attempting to rename a system-defined datatype, which isn't allowed in SQL Server. This occurred specifically in the "Creation Process" under "Execute Source Code."Could you please provide guidance on how to resolve this issue and ensure that the creation process can be completed successfully?Thank you for your support and assistance.

Having worked several years with the Windows GUI, I have gotten quite accustomed to the use of the “Filter expression” for certain cases. For the customer product it was not a standard option I would have explained to my users, but they did solve certain search situations for the more advanced. A very powerful tool actually.What is the likeliness this feature will find its return in the Universal GUI?Mainly also as the route for the SF is to be the Universal GUI and not the Windicium GUI that was mentioned several years ago. The reason I was not asking before as I was awaiting that last to make its appearance. Pressing the little arrow down made it availablePossible to filter several conditions like a Boolean function Able to also input it as a text (which you could use to recreate the filter as it never got a feature to save these). 

Is it already possible to start a process flow when leaving a field a form in edit mode and auto-commit enabled?I searched in documentation for this and did not find anything.