Jacques TUR's Profile | Ninox Community

Latest Posts

Re: A major step forward.
This is a very good idea Kim. Ideally, we should be able to link external tables, whether they come from Ninox or not. This would allow you to link external data such as MySQL, google sheet,…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view
Re: Suggestion List from first crack at Ninox
Thank you Drew for this already complete list. I already had in mind to develop a part of it because, like you, I find that Ninox lacks maintenance tools.…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view
Re: Problem with radio Botton on Web version
I sent an email to the technical support last week. They already knew about it. They will fix it soon. In the meantime, you can fix it by adding a formula with the code below on the first window…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: Switch Case statement in Ninox
Thank you Maja. In addition, here is an advanced use of the Switch statement : https://forum.ninox.com/t/p8hdmy1
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view
Re: add onselect event for view field
Hello everyone, I made an update with two additions: V1.05 : 12/05/2022 if onclick return true, the default event is fire. In this case, if line is newly selected,…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view
Re: Set auto completion on Ninox editor
@Fred Now this part of the code remains compatible. It's not a problem, but it's no longer needed. You can remove only this option by putting false on the completion line, as below :…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view
Re: New 3.6 Script Editor
In a normal code editor, if text is already attached to the cursor, then only one quote is inserted. For braces, only opening braces that have no text to their right cause the closing brace to be…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: All I want for Christmas!
@Sean 😂
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: All I want for Christmas!
For Christmas, I would love to be able to sort my tables in descending order (select ... order by desc) and not have to do complicated functions that reverse text or return arrays to do this 🤩 !
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Expression to place non-printing ascii codes into text
Thank you for this question @Captain Quint , I would like to have the answer as I would need it to sort the descending text.
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: Weird switch issue
@Mike I can understand your point of view 😄 The idea here is not to bypass, but to fully use the capabilities of Ninox script. The fact that you can put code in the "Cases" gives a new flexibility.…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Weird switch issue
And it allows you to do more complex Switch Cases such as testing whether Number is part of a given set of numbers: var n := Number; switch true do case [1, 3][= n] > 0: "option A" case [2, 4,…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 2
- Get help
- Reported - view
Re: Weird switch issue
Thanks a lot for sharing Fred, I was looking for a way to do this yesterday! I hadn't thought of putting a boolean value in the Switch, that's just great.…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: Improve performance: Count records from subtable WITHOUT select statement
@John Halls In fact, the array of links that allows to find all the Invoices that point to the Customer records and that are stored in each record of the Customer table (Customer.…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 2
- Learn and share
- Reported - view
Re: Improve performance: Count records from subtable WITHOUT select statement
@John Halls It is true that this method is even faster for searches. On the other hand, it means creating calculation "duplicates" and therefore monitoring the validity of these duplicates in one…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view
Re: Improve performance: Count records from subtable WITHOUT select statement
This performance point is really important. Thank you Maria. Let's say we have 100 customers and for each customer, about 5 invoices. Using the Select function to find the invoices,…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view
Re: acces to array items like with Where fonction
@Fred I copied your code and it works fine. If allhito1 contains the records : A1,A3,A4,A5,A6,A8,A10,A12,A13, and allhito2 contains : A4,A10,A11,A13, the result is: A1,A3,A5,A6,A8,A12.…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view
Re: acces to array items like with Where fonction
@Fred It works on the mac application if you put this code : let array1 := [1, 2, 3, 4, 5]; let x := [1, 3]; array1[var v := this; count(x[= v]) = 0]
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view
Re: acces to array items like with Where fonction
@Fred It work on web, but not on mac application !!! Of course, you can send one email to Ninox.
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view
Re: acces to array items like with Where fonction
@Fred I copied and pasted this code and it works fine for me. Are there other people who have a problem with this code?
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view
Re: acces to array items like with Where fonction
@Fred It's exactly the same code as this one, but with a For loop it's perhaps easier to understand. let array1 := [1, 2, 3, 4, 5]; let x := [1, 3]; for t in array1 do var v := t;…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view
Re: acces to array items like with Where fonction
@Fred You could try it : array1[(var v := this; not x[= v])]
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view
Re: Set auto completion on Ninox editor
@Gianluca Yes, you can add a script in the trigger Trigger after opening that opens the form on which there is the initialization formula: And in the formula of the Initialization form,…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 1
- Learn and share
- Reported - view
Re: Set auto completion on Ninox editor
@Gianluca I'm not sure I understand. Does auto-complete work on some tables and not on others? Normally, you only need to initialize it once for it to work until the database is closed (Mac app) or…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 1
- Learn and share
- Reported - view
Re: Creative community and javascript
Following @Alan Cooke request, I made this JavaScript code which allows you to print several records. It is the equivalent of printRecord. And here is how to insert the JavaScript code into a global…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view

1 27 28 29 30 31 35

Welcome to the Ninox community

Jacques TUR

Re: A major step forward.

Re: Suggestion List from first crack at Ninox

Re: Problem with radio Botton on Web version

Re: Switch Case statement in Ninox

Re: add onselect event for view field

Re: Set auto completion on Ninox editor

Re: New 3.6 Script Editor

Re: All I want for Christmas!

Re: All I want for Christmas!

Re: Expression to place non-printing ascii codes into text

Re: Weird switch issue

Re: Weird switch issue

Re: Weird switch issue

Re: Improve performance: Count records from subtable WITHOUT select statement

Re: Improve performance: Count records from subtable WITHOUT select statement

Re: Improve performance: Count records from subtable WITHOUT select statement

Re: acces to array items like with Where fonction

Re: acces to array items like with Where fonction

Re: acces to array items like with Where fonction

Re: acces to array items like with Where fonction

Re: acces to array items like with Where fonction

Re: acces to array items like with Where fonction

Re: Set auto completion on Ninox editor

Re: Set auto completion on Ninox editor

Re: Creative community and javascript

Overview