How I write long blocks of code

Another one of my DB redesign led me to create a button that: 1) has 310 lines of code 2) has 24 loops 3) writes to 6 different tables Trying to keep track of the ends of segments of code this long…

News on 3.13 Ninox

Input trigger discrepancy

Hi Again Ninox Brain Trust, Attached will be found a small database that shows a discrepancy for an input to a dynamic choice field. Notice that when the reference field item is chosen the trigger…

A consequence of proper DB design...

As you know I've been updating my DB structure, which means I'm creating more records. Well, by creating more records mean that I am now over my 50,000 record limit of the starter level.…

playing with arrays

How can you do that ?

Display extensive datasets via a custom HTML table.

Hello everyone, Following up on my previous post, I am happy to share the lessons I have learned working with an extended dataset. Although Ninox offers many ways to present data,…

Dynamic and mobile optimized Image Slider

Dear Ninox community, We recently received the following request: A customer of ours wanted to integrate a dynamic image slider into Ninox. The requirement was that you could switch through the…

Ordered, filtered list of attachments and images of a metadata table

Order by -size and filter is size > 100kB - can canged. Table name must be changed. Is from my post from the German forum. Maybe someone here can use it.…

Light hearted UI - any takers?

98.css - A design system for building faithful recreations of old UIs (jdan.github.io)

Time to create more work for myself...

Never to leave a functional DB alone, I decide to correct some poor DB design. As you can see in the picture, I break the tenant of not creating multiple fields that store the same type of data.…

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…

Cloud users - create an APP of your database via browser

2024-06-18_16-41-46 Quick video on how to create an app of your Cloud based Ninox database.

Did you know that there is a better calendar for Ninox Users… Calendar-Plus Version 3

Did you know that there is a better calendar for Ninox Users? Join the Ninox Learning Lab this Thursday, June 13th at 12:00pm EDT/ 5pm BST/ 6pm CET for a demonstration of the NEW Calendar-Plus…

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.…

Analysis of your database structure with Ninext

Here's a JavaScript code snippet for analyzing the contents of your database. This code can be run from the Ninox console when Ninext is installed : #{ let tables = Object.values(database.schema.…

Moving images from one table to another solved

Dear all, have after reading a lot about this problem in the forum, reached out to support, and done a lot of trial and error. I have now found a solution which works,…

createXLSX: format column as currency

Hi, how can I format a column as currency with the new function createXLSX? Thanks in advance.

Evaluating display of larger amounts of data

Actually, I just wanted to fix an old script of mine, because Ninox apparently changed something with the eval() function and it didn't work for me anymore.…

Free Dynamic Export Engines Webinar May 23, 2024 at 12pm EDT

Let’s demonstrate Dynamic Export Engines at the Ninox Learning Lab Thursday, 23rd of May at 12pm EDT/ 5pm BST/ 6pm CET Join the party for free: https://us02web.zoom.…

exportXLSX Training Videos

Four-part training class demonstrating how to use the new exportXLSX command now available. Part 1 - Simple Export Part 2 - Compound Export Part 3 - Formatted Export Part 4 - Export Engine

How can you call an Apple Shortcut from the Ninox iPad app? Found the answer

Can be easily achieved using a formula to generate a url. Here is an example... url(“shortcuts://run-shortcut?name=Open FitFile&input=text&text=” + FDate + “.…

Always have a backup in two different places

A worst case scenario happened. Luckily someone decided not to put all their eggs in one basket. Just a reminder to never trust one provider.

Announcing a new Template 'Store' for Ninox Templates

Like many others, I've created some Ninox apps for others to use but have been frustrated by the lack of a site through which to publicise them. For that reason,…

This is how I run ChatGPT in Ninox app

Hello friends :) Please find code below, allows to run OpenAI ChatGPT in your Ninox apps. It is connected to button OpenAi. After click it sends content of yourPrompt to ChatGPT and display raw…

HTML Pivot Table

Hello everyone, In my application, time series data (screenshot 1) are often needed to be managed and presented in a practical way. Since Ninox does not yet allow us to insert a pivot table view into…