N:1 Filter

Hi guys, I am looking for some help. Maybe you have an idea. I have a table which is called QR_Code. Inside of the table is a Callum with the title "QR" where I have 100 codes.…

length('FIELD_NAME') = 0 vs 'FIELD_NAME' = null

Hi, in the latest 3.15.2 Ninox version an important issue fixed: "Previously, empty field values were interpreted differently on the server and client. The client recognized empty fields as…

• Answered

Edit PDF -> file forever stuck in the editor

The following is only concerning the Ninox app (on macOS) v3.15. We are barely ever using the browser version. We have PDF files in "image" fields. When we click on that image field that shows a…

How do you distribute changes to a database to other users

if i provide my database to another user and then later I update that database with new functionality how can I send the other user the updated database so that they can update their copy easily and…

Values from previous record by date

Hi Ninox Experts I am very often struggeling with the same simple problem and need your help. I concerns getting data from a previous record (I mean previous by date not by ID,…

• Answered

Dynamically Expand Formula Field

I know Ninox can be manipulated with JavaScript, HTML, and CSS. I intend to create a formula field that will display multiple styled() alerts. I would prefer each alert to be on a single line,…

Display a text sequence in html format

Hello, I would like to find a formula that allows me to display in a formula field the content of several other formula fields whose content is html() Here is an example of a formula that I would…

• Answered

Trigger on Open....

Is there any way to trigger actions on open a record? (there are on create and on update) Background: I am implementing a "cancel / undo" option where I want to rollback the values in case of…

Does a programming tutorial exist?

I would like to write my own macros or programs to optimize my databases for select applications. Does a tutorial exist with all of the instruction sets, syntax,…

Workspaces gone

Hello, Two of my Workspaces are not listed in the workspace dropdown anymore, what can I do?

How to set a default value for dynamic fields?

I'm using a dynamic field in a page view and I need to specify a default value for this dynamic field (Choice-dynamic) but I don't have this option... any idea how to do it?…

• Answered

Select only hosts not working on a certain date from joined table.

We host events. Each event has a host. The host data is stored in a Host table. It is tied to the Event Details table via (N:1). What would the query be to populate a view of all hosts from Host…

How do I show only records for staff not already working on a specific date?

I have a Page where I want to show any staff not scheduled to work one of our events on a specific date. We have multiple events on a single date. - User selects a date - View would then show any…

An easy? help request

Hello, I am quite new to Ninox and am trying to create a fairly simple database. I will simplify it even further for this question. I have xxx tables Table Field(s)/datatype Companies CompanyName…

• Answered

Hide view tables when empty

Hello, I would like to know if there is a way to hide view tables when they are empty? Thanks for your help

• Answered

Issues with 3.15.1

Is something strange happening today? I have issues with Select statements when filtering on dates. Also, on some Views column filtering is not working unless multiple filter options are applied.…

MacOS Safari not compatible anymore?

With the last releases, I've found that Safari for MacOS (Sequoia version) has some trouble with the app, and it hangs often when executing some "complex" queries.…

How can I filter a column to show only rows containing 'Seed Packs' but exclude rows that contain 'Bulk Seed Packs'?

Is there a simple way to do this in the generic filter field that i'm not aware of? I have tried =Seed Packs and "Seed Packs" but they don't work. I know there are workarounds to do this by creating…

• Answered

Sending mail with Ninox Professional

Dear Reader, Could you help us with a robust solution for sending email messages to our customers? Unfortunately, your internal function is not suitable,…