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?

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

Búsqueda entre bases de datos

Buenas tardes, estoy tratando de hacer desde mi base de datos Gestión una llamada a otra base de datos llamada Horas, para traerme algunos campos pero no consigo poder traerme los datos,…

• Answered

how can I write the latitude and longitude information obtained from the map into the X and Y fields of a database?

Hello everyone, how can I write the latitude and longitude information obtained from the map into the X and Y fields of a database? Thank you for your help.

Find Latest Value from Subtable

I have a table called Hydrants and I have a subtable for Hydrants called Static Tests. In the Static Tests subtable, I have a numeric field called Static PSI and I have a date field called Test Date.…

How to remove unnecessary tabs in the Page view?

Hello there! Is there a way to remove the "white" tabs bar at the top of a "Page" view? As you can see in the screenshot below, I only have one tab in this view and it's redundant with the "blue"…

How to get a specific value in another table

Hello everyone, I hope you can help me a bit with my project! I have a table called "Saisons" with some basic information. Then, I have a Dashboard (= a page using the view function with some data…

• Answered

CANT IMPORT - API POST PYTHON SCRIPT

Hey guys, a newbie talking. I'm creating a python Script to import my data but can't do it, I dunno whats missing but I keep getting Internal Error because of the Timeout,…

How Can I password protect my database or page?

How can I password protect my page in a way that nobody can access adminmode without the password?

Substitutions for ui.popupRecord

Hi all - What are the other solutions to ui.popupRecord? Ninox said back in v3.8 that it, and a bunch of other commands, are being depreciated. Though it hasn't yet.…

• Answered

Is there a more handy way to convert a text with special characters to be safe to be used as a filename?

I have done the code like that, but i think there is probably a more clean solution. "--- Variablen ---"; let KundeConverted := Kunde.'Firma oder Nachname'; let KundeConverted :…

I can make the table headers sticky on scroll.

@MZ Can I make the table headers sticky on scroll. let leads := ((select Albums where Format = 1 or Format = 2 or Format = 3 or Format = 4 or Format = 5) order by Name); html("<!…

• Answered

Exporting all data

I have a table with a lot of columns and i want to export it to CSV. I can only export visible data, is it possible to export all columns (visible and hidden) or any way to make all columns visible…

HTML and Ninox

So I'm trying to understand the difference between using double quotes ( " ) and --- when creating HTML code. I have the following code: let tbleHead := " <thead class='tableFixHead'> <tr>…

• Answered

Calculate opening days for a short time & CSV import problem

Hi there, We use Ninox database to manage temporary items. Each day we received parcels (like undelivered UPS or FedEx parcels), and head company ask us to keep them 5 opening days for customers…

Keep rID information in a JSON?

I have created a JSON object let t := this; let xPart := unique(Results.Partners); let xNewData := xPart.{ Name: Horse.'Horse Name', rID: Horse.Id, Atm: switch t.…

• Answered