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

recurring events in calendar

Hi there I have been told that one can make a script in Ninox for creating recurring events. Can anybody give me an example for a script to create recurring events ?

List of New Icons

Does anyone have an updated database of Ninox's new 3000+ icons and the internal names?

Making a field writable based on a condition

Hello Friends, I am not able to wrap my head around this thing. I want to make the "To Address" text field writable if the selection in the choice field is "OTHER".…

• Answered

Ninox public cloud down?

Haven't been able to create or modify records, use make.com integrations, or save code changes since Feb 18. Anyone else having this issue. No communication from the ninox team, and no place,…

• Answered

API: Sort order not working when combined with filters

Hello! I use Ninox to maintain my collection. I want to display my most recent purchases on a website using the API. This works great as long as I do not apply any constraints through filters: https:…

Private clouds unavailable

I wonder if the previous message: "Due to a temporary outage at our hosting provider, some Private Clouds are currently unavailable. The service provider is already working to rectify this.…

Creative Suggestions Needed for styled() within a Formula

I plan to utilize the styled() function within a Formula for user alerts, messages, and details. The only way I know to achieve this is to create a separate Formula for each alert,…

Problem to add sign + and -

let mySelect := (select Expenses where Year = 2025 and month('Expenses Date') = month(today())); let mySelect2 := (select Expenses where Year = 2025 and month('Expenses Date') = month(today()) - 1);…

• Answered

Use Ninox as a backend with an online ordering system

Hello friends, My office is planning to implement an online ordering system instead of taking orders on phone/whatsapp. Is it possible to use Ninox as a backend for an online ordering system on a…

• Answered

Inconsistency with 'Readable If' and 'Writable If'

I wrote a comprehensive user permissions application that validates user permissions based on: Entity > Location > Permission Using a Global Function, I wrote this:…

How to use setItem in a button?

I'm having difficulty using setItem to modify a JSON in a text field with a button. I have a text field called json. It has a simple json object which is created with another button.…

• Answered

Error -> Delete a file in an image field

Environment: Ninox App for Mac version 3.14.3: Local Error message: "TypeError: i is not a function. (In 'i()', 'i' is undefined)" TestImage_Local https://youtu.…

do as deferred

@Fred Hi Fred, Isaw that. For those looking for solutions. If you work with Dashboards on the Main screen you can apply something like "Calculate my Stats but do it in the background" and then refer…

Sort by Nb Numerical Size

let data := [ "{'food': 'bread', 'Nb': 3} {'food': 'apple', 'Nb': 7} {'food': 'rice', 'Nb': 1} {'food': 'banana', 'Nb': 5} {'food': 'milk', 'Nb': 9} " ]; let sortedData := (data) order by Nb;…

• Answered

Field from newest (sub)record

Dear experts Can anyone help me? I am trying to budget and plan my revenue and have a table "Customers" and a sub-table "Years" in the sub-table Years I have a field "Total revenue" of this customer…

• Answered