-
Set auto completion on Ninox editor
Hello everyone, I was fed up with always having to close the code editor to fetch the name of a field or table, so I set up the Ninox code editor to have an auto-completion function :…
-
acces to array items like with Where fonction
Hello to all, This new forum made me want to share something with you
. I chose this code which allows to find elements in a table by filtering as we would do with the Where function of Select.… -
Creative community and javascript
Hello everyone, For more than a year I have been exploring the Ninox code to better understand how it works. Initially driven by the lack of documentation and the frustration of some limitations,…
-
Custom HTML Dashboard
Hello, i was looking to create a custom Dashboard in Ninox to have a clear overview over some important KPIs and also allow controllers to get a quick view at key data.…
-
New functions
Hello everyone, I put up this post to list all the new undocumented features of Ninox. I started a post here (https://forum.ninox.com/t/g9hs0n7/v3-7-11-new-functions) but its title limits it to…
-
Improve performance: Count records from subtable WITHOUT select statement
If you are counting records from a subtable, you can avoid using the 'select' statements... For example: Instead of using the code: let t := this; count(select Invoice where Customer = t and Status…
-
import an Image from WEB
This procedure allows you to download an image from a public website and display it in an Image field: Usually, I go through the following steps: Image Field text field labelled in this example…
-
Put comments in the scripts
I discovered that it is possible to easily metre comments in scripts with a notation that was not documented: #{here I can put any text}#; var y := year('Start date'); var m := month('Start date');…
-
New 3.6 Script Editor
Is there a way of turning off the auto-complete function in the new 3.6 script editor? If I want 2x " (double-quotes) or a pair of braces () or {} then it assumes I always want a pair.…
-
add onselect event for view field
In response to @Alain Fontaine & @Fred Christmas wish (https://forum.ninox.com/t/h7hbkmp?r=h7hbvzj), I have added a viewEvent function to Ninext project.…
-
Progress Stepper in HTML.
Ever wanted to create a step diagram to point users to the steps to follow in Ninox? Then this can be done with a choice field but a nicer representation is with HTML and some CSS.…
-
Extract color or icon from styled field/var
I needed to extract the icon and colour from a styled value. The color() and icon() functions work for the choice field, but not for styled. When I looked up how to do this,…
-
Ninext : Native JavaScript
I start here a new post about the Native JavaScrip to differentiate it from the EvalJS function in which I had previously put it... I discovered one weekago that it was possible to add comments in…
-
Customized button
Hello everybody, I added the buttonEvent to Ninext. This allows to dynamically change the caption, the color and the help title of a button. Just add the onUpdate function in the "Display field only,…
-
Multi language solutions best practices
Hi again. I don't know if this is the best place for this question, but I will try... Here in Spain, about 70% of our clients sell their products and services in at least 3 languages: Spanish,…
- Answered
-
Pass current viewing record Id to a view element column formula
Hi all - I have a table that has a view element. I'm trying to do formulas in the view element that requires data from the record I'm viewing. As we know,…
-
A new way to comment out code in the console
With my friend Jan, we discovered a new way to add comments in the Ninox console. Simply add /* before and after the text you want to comment out : var a := {lastName : "tur"}; /* var a := {firstName:…
-
Reverse Order by
Hi all - I was blown away by what a FB user posted in the Ninox English forum. I don't remember seeing this any where else. To do a reverse order by you can just put a "-" in front of the field name…
-
Ninext : Important information
This message is addressed to all those who use the Ninext project. I regret to announce that the Ninext project will be unusable on Ninox very soon. This should happen at the beginning of February.…
-
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).…
-
Passing data from a Text field or MultipleChoice field to a DynamicMultipleChoice field
If you have a MultipleChoice field, and want to pass the same chosen options to a DynamicMultipleChoice field, follow the steps below: - Create a new reference table with the options written exactly…
-
Switch Case statement in Ninox
Another great structure in Ninox that can help you in the automatization of your processes is a Switch Case statement. Simple syntax, fewer lines of code, and faster result in your app.…
-
Weird switch issue
I'm using the MacOS app, so if I put this in a formula field: switch Number do case Number < 5: 10 case Number > 5: 20 end with Number being a number field in the same table.…
-
Adding values between values in a (dynamic) choice field...
Ever wanted to add a value between values in a choice field? This is possible with a Dynamic Choice Field : >Formula in the MoveUp button: Number := Number - 1.…
-
A BIG thank you!!! - please add your show of appreciation.
@Jacques TUR - Thank you so much for all that you have accomplished with Ninext. I was motivated to post this morning due to the element copy and paste feature recently added.…