Jacques TUR's Profile | Ninox Community

Badges

Latest Posts

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
- 253
- 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
- 1
- 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
Re: Numeric array variable initialization
@Javier Another solution is to initialize array of number filtered with no result (an impossible result) : let xListaMonedas := let myArray := [0][ = 1]; like this exemple : let myArray := [0][ = 1];…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Numeric array variable initialization
@Javier Try this code : let xItinerario := Itinerario; let xCircuitos := ((select Itinerario_Circuitos where Itinerario = xItinerario) order by Orden); "// create empty array of record";…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: Numeric array variable initialization
Ninox needs to know the exact type of variable to set it. You cannot create a variable with an unknown type as JavaScript. About your code, you can simplify it,…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: Using a button to export multiple records
Do you just want to open the export interface with a button? If so, you put this code on your button (need to use NativeJS) #{ ui.currentView.table.menuExportData() }# If you want to execute the…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 1
- Get help
- Reported - view
Generate QRCode to File or Image field

Following a discussion with @CISOFT Sàrl ,I embedded Sangmin Shim's code in a Ninext function to generate a QRCode on Ninox. The QRCode generates a file on the attached files or in the Image field.…
- Ninox developper
- Jacques_TUR
- updated 3 yrs ago
- 19replies
- 1323
- 1
- Learn and share
Re: add onselect event for view field
@Maurice switch function seem work fine on my database : function onclick(event : any) do 'selected Customer' := first(select Customer where Id = event.targetID); switch true do case event.…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view
Re: add onselect event for view field
@Maurice thank you for your feedback 🙏. On the form of your "RuR Kolloquien", put the code like this (to adjust with your data) : function onclick(event :…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view

1 21 22 23 24 25 36

Welcome to the Ninox community

Jacques TUR

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

Re: Numeric array variable initialization

Re: Numeric array variable initialization

Re: Numeric array variable initialization

Re: Using a button to export multiple records

Re: add onselect event for view field

Re: add onselect event for view field

Overview