Jacques TUR's Profile | Ninox community

Badges

Latest Posts

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
Re: Using a button to export multiple records
@Jan Inge Iversen Is juste one free extension for Ninox. See here about NativeJS : https://forum.ninox.com/t/g9h7l3a/ninext-native-javascript NativeJS is part of Ninext project : https://forum.ninox.…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 2
- Get help
- Reported - view
Re: Using a button to export multiple records
@Jan Inge Iversen Do you have NativeJS installed?
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: Special syntax of the for loop
By adding some NativeJS (line 2) to convert a record to JSON, it is possible to retrieve all the fields of a record and its values : var rec := (first(select Customer)); var config := #{:…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view
Special syntax of the for loop

Hello to all, this morning I discovered a new type of use of the for loop. My first exploration leads me to think that it is a possibility to enumerate a JSON structure (complex).…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 1reply
- 263
- 3
- Learn and share
Re: Numeric array variable initialization
@Javier The exact syntax to create one typed empty array is : let numberArray := [0][false]; let textArray := [""][false]; let JSONArray := [{}][false]; let recordArray := select myTable[false];…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 2
- Get help
- Reported - view
Re: Numeric array variable initialization
@Javier See also this post about filtering arrays : https://forum.ninox.com/t/y4hbx90/acces-to-array-items-like-with-where-fonction And this about kind of array types possible with record id : https:…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view

1 21 22 23 24 25 37

Welcome to the Ninox community

Jacques TUR

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

Re: Using a button to export multiple records

Re: Using a button to export multiple records

Re: Special syntax of the for loop

Re: Numeric array variable initialization

Re: Numeric array variable initialization

Overview