-
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.…
-
Duration in days, months and years
I'm fairly new at Ninox. I'm building a research database for history data in which we use a lot of dates, for ages, duration of events, etc. An easy readable display of duration would be great for…
-
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.…
-
Ninext : Debug Tracer
Hello everyone, For some time, I wanted to offer you a possibility to debug your programs. I am happy to present you a first debugging tool. It's simply a tracer to display the messages coming from…
-
Custom Widgets (Release 1.0)
Dear Ninox Community! Many of you have asked how you can easily and cost-effectively use our Custom Widgets in your Ninox databases. The time has finally come We have worked hard to find a…
-
html() function
I uploaded a database named HTML Tricks. So far it only has one example, but I've got some other ideas I've been playing with. If you are interested in a blinking formula field you should give this…
-
Create nested array in the form [[51.12344,34.876342],[26.987430,45.123459]]
Sometimes third-party programmes require data in the form of a nested array. Ninox is unfortunately not able to create these simply with the array function.…
-
chatGPT - Ninox code
Just for laughs I asked chatGPT to give me some sample code for Ninox. This was offered: Second request it offered Let in place of var
-
AWESOME response as always
@Jacques TUR How nice is this. Makes a huge difference....the snapshot speaks for itself!!!
-
How to create a unique list of records
Let us say I have a table, Table1, with records that store years in a field called Number. Now I want to create a dynamic Choice field in Table2 that shows the unique years that are in Table1.…
-
Improve performance: Save Calculated values in Static fields
Views of the tables can sometimes take longer to be displayed due to the functions which are calculating the values. Formula fields have to be calculated every time the view is opened.…
-
Display linked records within the according table view
If you have a main record with several linked records (e.g. record of a contact/customer with a list of linked invoices) and you want to access those directly in the according table view,…
-
CSS Framework & Ninox
Hello, I recently realized that Ninox allows us to use a CSS stylesheet file directly from a CDN link. I wanted to know if we could use a CSS Framework to design a Ninox page faster and more…
-
Where does the cat sleep (find the closest sentence)?
I had a somewhat unique case where I needed to import data with sentences indicating where to store them, but sometimes the sentences were not all spelled correctly.…
-
Hiding Icons HUD - choosing which to hide
I use this to hide ALL icons etc on forms. I have tried to show only the PRINT icon by removing 'none' in the relevant line but regardless of refreshing the page or toggling the HUD Y/N the print…
- Answered
-
Help with Changing Multiple If Statement to a Case Statement
I need help converting this multiple if statement to a case statement. Withdrawn and Graduated fields are yes/no. if Withdrawn = 0 and Graduated = 0 then let t := 'Enrolled Date';…
-
Known difficulties when using dynamic printing and their solutions
Since version 3.7, many users have reported success with dynamic printing through Carbone.io, as it enables customizations that are still missing in the Ninox print editor.…
-
Display and already uploaded attachment in an 'image field'
As a rule I try to avoid paperclip attachments or displaying large images in fields however on the odd occasion I would like to. Is there a way to display an attachment that has been uploaded in a…
-
Button for create a new record which has a connection to a record
I have a table, where in every record, i have a connection of records from a different table showing up. (1:N) when want to get a new record, normally click "+ Neuer Datensatz" at the 1:N,…
- Answered
-
LIVE clock script.
This came about because of a now 'answered' post. I asked ChatGPT to modify the script to add the AM/PM clock and Day/Month/Year. Hope it proves useful.…
-
Copy to Clipboard
Is there a Ninox function now? I was looking for a way to copy the content of a field and found this post from way back: html("<button onclick='copyToClipboard(""" + concat(SERIAL) + """)'>Copy to…
-
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.…
-
Conditional formula to calculate 'taxable' and 'non taxable' items...
Hello, I'm trying to figure out how to include two fields that calculate the sum of taxable and non-taxable items. If you look at the attached image, you'll see that there's a field for the base…