Jacques TUR's Profile | Ninox Community

Latest Posts

Server slowdowns !?

Am I the only one with big server slowdowns this morning ?
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 4replies
- 47
- Get help
Re: How to get filtering to work in a reference field that is set to popup and has columns from linked tables.
I had exactly the same problem and searched the code a bit. For some reason, when you type a search keyword in a popup, Ninox calls the server and it only searches the fields in the main table of the…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 1
- Learn and share
- Reported - view
Re: Parameters it is possible to pass to a function
@support The best code is this one with you feel comfortable👍 You can simplify like this : let t := this; if Channel like "abc" then (select table1 where 'order-id' = t.'Channel reference').…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Extract certain variable numbers from attached file title
@thomas Because the year at the end is each time with 4 digits, and in case the file name contains the number, you could use this RegExp. I modified it so that it returns all parts of the complete…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Extract certain variable numbers from attached file title
@thomas -[^0-9]*(\d+)[^1-9]*(\d+,?\d*)x[^1-9]*(\d+,?\d*)cm-[^1-9]+(\d+)-?(\d+)? It works for all files. I invite you to try it with this site https://regex101.com/r/Tyz1yY/2. This example is recorded.…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Extract certain variable numbers from attached file title
@thomas I think this RegExp should recover all cases. Try it with different representative file names -[^0-9]*(\d+)[^1-9]*(\d+,?\d*)x[^1-9]*(\d+,\d*)cm-[\w]*-(\d+)-?(\w+)?
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Extract certain variable numbers from attached file title
@thomasJust add (\d+) at the end of RegExp. But with this new file name example, you have another problem: the file name contains a number and the formula is disturbed.…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: For loop for accessing different fields
@Fred Yes, there are two undocumented functions in Ninox for manipulating fields: get(record, fieldName): returns the value of the fieldName passed for the record ; var rec := first(select Customer);…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 1
- Learn and share
- Reported - view
Re: Line feed/Carriage return in an Alert
You can use also the ASCII code 13 + 10 (Carriage Return + Line Feed) with this code : var CRLF := urlDecode("%0D%0A"); alert("coucou"+CRLF+"les amis"); In line 1,…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 3
- Get help
- Reported - view
Re: Extract certain variable numbers from attached file title
@Fred It to convert string number to JSON number... extractx("NOM-Nr001-200x400cm-Backlight-2021", "(\d+)[^0-9]+(\d+)[^0-9]+(\d+)", "", "{""Numero intero"":$1}"), return {"Numero intero":001}.…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Extract certain variable numbers from attached file title
@thomas try it : [^1-9]+(\d+,?\d+)[^1-9]+(\d+,?\d+)[^1-9]+(\d+,?\d+)
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 2
- Get help
- Reported - view
Re: Extract certain variable numbers from attached file title
@Fred of course, you're right is better to stay away "-" and "x" 👍. Also, if you replace [^0-9]+ by ^[1-9]+, it's replace my (0*) and it stay only 3 groups (not 6) :…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Extract certain variable numbers from attached file title
@Fred good job !!! I just add 3 groups to remove the 0 before the significant digit. I also replaced the "[^0-9]+" by "-" and "+" which are signs directly present in the filename structure :…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Third party formula editor?
@Javier don't know of any such editor because the Ninox language only exists on Ninox. But I think you can set VisualStudioCode to do it : https://learn.microsoft.…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view
Re: Is there a 'command' to delete an attachment?
You can also rename a file with similar NativeJS code : var file := file(this, "myFileName.pdf"); "// put here your old file name"; var newFileName := "myNewFileName.…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: Third party formula editor?
Otherwise, I'm not sure I understand what you're looking for? Another script editor that can recognize Ninox syntax, right?
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view
Re: Third party formula editor?
@Javier said: I'm using functions when possible (they only accept text or number parameters, so not as easy as it could be) There are many more possible types for function parameters.…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view
Re: Third party formula editor?
I think Visual Studio Code is a good choice. But when the function grows "too much", the right question is why it is so complex and long and how to reduce it into several simple and easy to…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view
Re: Is there a 'command' to delete an attachment?
You can use API to delete a file : https://docs.ninox.com/en/api/public-cloud-apis#delete-a-single-file You can also do it with JavaScript on HTML or NativeJS : var file := first(files(this));…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: Parameters it is possible to pass to a function
Why create two tables with the same structure and different data? Perhaps the best solution is to merge the two tables and differentiate them by a field named 'data type'.…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: Parameters it is possible to pass to a function
You cannot pass the table name to the select statement because the Ninox language is pre-compiled and does not support dynamic types like JavaScript. But you can pass your current record (this) to a…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: Function parameters - which types are possible
@support Hello, I think there are many possible answers. But before that, could you create a new post about it? This post is about what kind of parameters it is possible to pass to a function and to…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: Array to records in a table
@Fred In JavaScript, \ is an escape character that indicates that the next character is not a marker and should be inserted into the string and not interpreted.…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: Wish List or can the great Jacques pull one out of the hat
@Patrick W. I tried, but it creates a downward shift in the text. I think it would be better to harmonize the background and text colors when the tabs are selected or not.…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view
Re: Using a button to export multiple records
@Jan Inge Iversen You need to install the Ninext project. It is explained here : https://forum.ninox.com/t/p8h78zv/ninext-project In the NativeJS post, there is an app attached with an example of how…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 2
- Get help
- Reported - view

1 19 20 21 22 23 35

Welcome to the Ninox community

Jacques TUR

Server slowdowns !?

Re: How to get filtering to work in a reference field that is set to popup and has columns from linked tables.

Re: Parameters it is possible to pass to a function

Re: Extract certain variable numbers from attached file title

Re: Extract certain variable numbers from attached file title

Re: Extract certain variable numbers from attached file title

Re: Extract certain variable numbers from attached file title

Re: For loop for accessing different fields

Re: Line feed/Carriage return in an Alert

Re: Extract certain variable numbers from attached file title

Re: Extract certain variable numbers from attached file title

Re: Extract certain variable numbers from attached file title

Re: Extract certain variable numbers from attached file title

Re: Third party formula editor?

Re: Is there a 'command' to delete an attachment?

Re: Third party formula editor?

Re: Third party formula editor?

Re: Third party formula editor?

Re: Is there a 'command' to delete an attachment?

Re: Parameters it is possible to pass to a function

Re: Parameters it is possible to pass to a function

Re: Function parameters - which types are possible

Re: Array to records in a table

Re: Wish List or can the great Jacques pull one out of the hat

Re: Using a button to export multiple records

Overview