-
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,…
-
Ninox Products - App vs. Cloud
Before diving into the Ninox world please read this article about our two product lines - Ninox App and Ninox Cloud! The image below shows our two products side by side in a sample database from the…
-
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,…
-
Learning Sources for Ninox Newbies
Welcome to Ninox! Here is a list of learning source material: Manual on Ninox.com activate our amazing TOURS and create your first database in a matter of minutes Video Tutorials join our Webinars…
-
Ninox REST API for Javascript
Hey Guys, long time lurker. I have written this little javascript wrapper for the REST API for Ninox. I personally didn't like using Letters and hashes to address my tables,…
-
Operators for searching one/several texts in the field filter (Boolean)
From time to time you need to search for several texts in a table column at the same time or you want to exclude certain texts from the search. To do this,…
-
Exporting Images from Ninox
After exporting your database as a .csv file you might be wondering why your images are not there! The reason behind is that a .csv cannot export images. Here is a small workaround.…
-
Download file and JavaScript calling
Hello everyone, Recently, I responded to a request from someone who wanted to be able to download a file without encountering a blank window. This required the use of JavaScript,…
-
Interesting HTML formatting
Hi all - I've been adding HTML tables to my dashboards as they make things prettier and compact. So I found when you have multiple HTML formula fields, you can't change the color of only 1 of them.…
-
Ninox script to work with csv files
Ninox has a convenient wizard for importing (.csv) data which is well featured and easy to use. If you regularly work with data contained in csv files, you may be keen to to avoid retracing your…
-
Send Emails with pictures in the body and also with attachments of your choice .
Since there is a lot of demand for sending emails with images in the body, I created an extended email database for the community. Using colors in the body is also possible.…
-
Track selection of Dynamic Multiple Choice field
Hi all - Here is one possible solution if you want to track the selection of choices in a dynamic multiple choice (dMC) field. In my test DB I have Table2 as my working table.…
-
Multi selection/paste in Code Editor
Just came across this nifty feature of the code editor. You can place multiple flashing cursors by holding down the Ctrl key and clicking in different areas of the code, see video.…
-
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,…
-
Connecting to external REST API (complete example)
Hi, In the last several days, I was able to integrate the ICD 11 coding tool, which is based on a REST API using OAUTH2 authentication, into my EMR Ninox database.…
-
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:…
-
Ninox backend and its companion front end
For quite some time I slowly built an audio visual integration management suite. You can see the main menu of the backend on the left. But because AV Integrators primarily use mobile phones when…
-
UNICODE Progress bar for alert window, indicating progress of loop function
To indicate progress of scripts that use a loop function, I found it practical to give a visual indication of the progress using an alert window. However,…
-
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.…
-
Warning of dynamic multi choice bug
Hi all - I reported an issue to Ninox where the data in a dynamic multi choice (dMC) field got corrupted. It affected over half of my 1000 records that had data in this field.…
-
Function parameters - which types are possible
I've found this old post https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/types-of-parameters-for-a-private-function-5c0962c08d9fa6683abafc7d And not really any docs on the topic.…
-
Do you want to auto print a page. This works in Firefox after your turn printAlwaysSilent to true and and chrome you will have to config run chrome silent printing on mode --kiosk-printing edit target on chrome shortcut properties Ex:"C:\Program Files (x86)\Google\Chrome\Application\chrome.exe" --kiosk-printing "http://localhost:8080/this"
let myPdf := printAndSaveRecord(this, "HTML Ticket");let x := substring(myPdf, 28, 200);html("<html><head> <style> .button{} .button1 {font-size: 90px;border-radius:…
-
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).…