Skip to main content
Forum
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Plugins
Documentation
Setup
Databases
Automation
My account
Administration
Solutions
Webinars
Overview
Profile
Jacques TUR
Jacques_TUR
Ninox developper
France
www.umangenius.com
Follow
La perfection est atteinte, non pas lorsqu'il n'y a plus rien à ajouter, mais lorsqu'il n'y a plus rien à retirer.
Joined
Sat Nov 14 09:45:24 UTC 2020
912
posts
626
likes received
21
followers
Badges
Latest Posts
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 🤩 !
Jacques TUR
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.
Jacques TUR
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.…
Jacques TUR
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,…
Jacques TUR
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.…
Jacques TUR
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.…
Jacques TUR
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…
Jacques TUR
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,…
Jacques TUR
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.…
Jacques TUR
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]
Jacques TUR
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.
Jacques TUR
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?
Jacques TUR
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;…
Jacques TUR
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])]
Jacques TUR
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,…
Jacques TUR
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…
Jacques TUR
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…
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Learn and share
Reported - view
Re: add onselect event for view field
@Jacques TUR At @John Halls request, I have added an onclick event that is called even if the row is already selected (exViewEvent version 1.03 beta). function onclick(event :…
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Learn and share
Reported - view
Re: All I want for Christmas!
@RoSoft_Steven Rooryck What I would like for Christmas is a complete documentation that allows to see all the possibilities of Ninox Script 🤩. In Ninox,…
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
2
Get help
Reported - view
Re: add onselect event for view field
@John Halls yes, it is normal. the event fire when selected. if you want, I can add an onclick event that will fire on every click, whether the line is already selected or not.
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Learn and share
Reported - view
Re: Set auto completion on Ninox editor
@Fred I just made an update to viewEvent. Maybe it's because of this?
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Learn and share
Reported - view
Re: add onselect event for view field
I have just added the ability to update the view field when the record or some fields changes. Just add an onload() function in "Display field only, if:" : function onload() do 'selected Customer'.…
Attachment
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Learn and share
Reported - view
Re: add onselect event for view field
Thanks Sean. Indeed, to access the part of the code that handles the view selection, I have to pass through the field that displays it on the screen. So I set up a code that waits for a view field…
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
2
Learn and share
Reported - view
Re: add onselect event for view field
@Fred "Unless they pay you." : Good idea! 😂 Thank's for your message 🙏
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Learn and share
Reported - view
Re: add onselect event for view field
I don't understand why it doesn't work for you! I have tried on the online app and on the Mac and everything works. Can you try with the test application attached?
Attachment
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Learn and share
Reported - view
1
29
30
31
32
33
37
Ninox-Website
Overview
Learn and share
Get help
Service status
Plugins
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Plugins
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Private Cloud Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
View all topics
