Query Help - Count of records in joined table that meet X criteria

I have a tables called Staff and Event Details. There is a join table called event_staff_join to show what gigs they worked. The join is "Relationship from Staff to event_staff_join (1:…

I Need to update field in another table.

I Need to update field in another table. On Document I have te 'projCod' field and need to update on table 'Control Deliverables' on fleld 'projCod' only update no duplicate.

• Answered

Odd behavior / bugs with PAGES on macOS

I'm using Ninox on my mac and I'm experiencing some weird behavior when I try to use pages. I'm curious if anyone else is having this issue as well. First,…

View of contacts with large number of rows

Hi, I have a table (Contacts) with more than 600k rows. Every time when I open the table it takes quite a while to see the results. I would be gratefull if you could recomend a high perfomance…

• Answered

Display associated content with conditional constraints.

In table HOME, there is a record with "nb" as 1. I want it to display the associated content with table copy, but without showing duplicate names, similar to what is shown in "show" (but excluding…

• Answered

Move an image

Dear Forum has anybody tried to move images from one table to another ? I have this situation that I have a Photo table as child to the member parent table,…

Gantt view - how to setup?

Im looking for docs on how to setup a gantt view. I can easily add the view but I cant seem to find which fields i need to setup. By installing the Tasks template database I slowly found out that you…

Date format after upgrading to 3.12

Hi, after upgrading to 3.12, I noticed that the dates no longer format "DD/MM/YYYY" (local format) but instead as "MM/DD/YYYY." Do you know if they're going to fix that?

• Answered

Calender language changed with newest update

Hi, I've updated my Ninox app to 3.12.2. Now all the months in the database have changed to English (I had them all in Dutch up to 3.12.1). I need the Dutch months on my invoices to my all Dutch…

The issue concerns the search functionality across different software platforms.

The issue with my database is that when I search for data (N:1) using the Android app, it returns relevant search results from the same database and cloud service.…

• Answered

Duplicate record has stopped working

Hi, I created this code to duplicate a current record, remove information from specific fields and then open that new record. I have been using it successfully for the last 3 years but it has…

Professional help

Sorry if this topic has come up previously. I'm considering hiring someone to help me with my database. I need help creating a better version (version 2) of what I've already made.…

• Answered

Birding database

I have created a simple database on my iPad that contains a list of certain of my sightings of birds. Each sighting will have a Date and a Country as well as the species name.…

How to run chatgpt or Claude…

Hi is it possible? I’m not a programmer. I understand ninox script, I can write some simple things but still: it’s far from REAL PROGRAMMING :)) I want to achieve simple things,…

• Answered

Moving from mac app to Ninox cloud

Hello all, Been getting a white screen only on the Map App so decided to move my business database to the Ninox cloud. I signed up for a free trial of ninox cloud and uploaded my archive database.…

• Answered

How to send double quotes

This is a littlebit connected to question about ChatGPT. I'm searching, trying, fighting... Now the idea is, that I can't proper authorize wit OpenAI API.…

ninoxApp() returns "ipad" on an iPhone...

In an iCloud environment, the ninoxApp() command gives "ipad" as a result even though the device concerned is an iPhone SE 3rd generation... The master station is a Mac and receives the correct “mac”…

Some idea please

In this table I calculate all Earned Value KPI's for every CutOffDate (all Fridays). The next Friday 17/May the new values are calculate, but lost the past.…

can not open Excel file after creation?

I can see that the file is created in the Image field, but can not open it: I use the local Mac App. let columns := [{ header: "Navn", key: "Navn", width: 10 }, { header: "Adresse", key: "Adresse",…

Global Search not working... what could be the reason?

I have Global search enabled on both the table and fields of a database. Yet when i conduct searches, i find nothing. Search works fine on other databases i have,…

• Answered

Range Date between two dates 'Plan' and null the other date 'Real'

I need the Dates 'Plan 1' to appear between the range of Dates 'Date From' and 'Date to Cutoff', and the Dates 'Real 1' = null let myFrom := 'Date From'; let myDTC := 'Date To cutoff';…

• Answered

Need help organizing some information

Hello Ninox forums! I've been using the macOS version of Ninox for about 2 weeks, its the first time I've ever sat down and got serious about using a database to keep my business organized.…

Linking Related Fields between two tables

I need some help with setting up a script to automatically link two fields in my database. Table 1 "FAs" has the text field "Room" Table 2 "Survey" has the text field "Room" On the FAs table in the…

• Answered

Export data issue

Hi, For some time now I'm having an issue with my Ninox app. Every time I exported data (table) I have to close and re-open the database to be able to export another (or even the same in an other…

Icons Problem

I use Ninox in the web cloud version. Lately I've noticed that the style of the icons has changed. At the same time, "styled" functions containing icons and text are no longer displayed correctly in…

• Answered