Search for parent

When in a child record and clicking the parent field, a large table opens with suitable parent records to choose from. There is also a search box at the top and I don't remember this not working…

Array eficiency

Let's say we want a 'list' of values of a particular field (e.g. Text type) from records in a child table. Easy to do in a Formula field in the parent record,…

Working with Multiple Choice Checkbox

Hi, I have a multiple choice checkbox field in a table (Claim Items) which contains 5 options. That table is related to another table, Claim, so for each of the items in the claim,…

• Answered

Trouble deleting all records in very large table

I often have tables with many records, possibly hundreds of thousands, and I occasionally might want to clear out the tables so I can reload them from scratch (e.g.…

Cards View, grouped items changing the standard header text colour. Help please.

Hi, Is there any solution for changing of the text colour in a cards view when fields have been grouped as the white on grey is just not that visible? any suggestions welcome please?

• Answered

Group by equivalent

I'm trying to gather records from a table with e.g. 3 fields (columns). Let's say field1, field2 and field3. The best way I can describe what I want is by pseudo Ninox/SQL like:- SELECT field1,field2,…

Views

It always creates confusion when the same word is used to describe different things. Ninox can create tabs at the top of the main window and these are called 'Views'.…

Impression de plusieurs champs sur une ligne

Bonjour, j’utilise 2 tables : une DSA DAE l’autre facture - je dois récupérer des infos de la table DSA DAE (image 109) pour les imprimer sur la facture (image 110).…

creating an online test environment that maintains my data create dates

Hi - I have an online membership database with about 800 members. I have a process to create a test environment that keeps all of my data (use my local Mac app, import the online database there,…

Is it HIPPA compliant?

What information is there regarding HIPPA compliance law, for privacy of protected medical information, and can I use my Ninox DB for this purpose?

Need Constraints

'Planning Data' table: Relationship field: 'a_Project' → to Projects table N:1 Relationship field: 'a_Employees' → to Employees table N:1 'Employees' table: Relationship field:…

Chart x-axis order

Hi guys, can't find a way to order my x axis by the value of a number field in the selected table. I can only sort it by the value of the field that is actually in the xaxis,…

I have a problem with the Ninox app on all my Macs

I have a problem with the Ninox app on all my Macs — both on my iMac and my MacBook Air. I don’t know what’s happening, but the app tries to open and then closes unexpectedly.…

Ninox Timesheet template

Hi All, I want to create something similar to the ninox timesheet template they have and I just wondered if someone can help me. Within this template they have a sub table called "Calendar Days"…

Image in form keeps jumping left

Hi, Is there a solution for an image (derived from an attachment) jumping to the left in a form? I've tried the html function but that doesn't work: I get a question mark displayed and not the file's…

translate

In meiner Datenbank habe ich verschiedene Tiere und Aktivitäten dazu erfasst. Jetzt übersetzt mir Ninox die 'Art' in Kunst. Dabei will ich nur zwischen Hund und Katze unterscheiden und nicht zwischen…

Extract string before character occurrence

Hi everyone, I need to extract text from a string until certain characters appear. Example: 123865,12 → should return 123865 I just need everything on the left side,…

• Answered

Comparing a formula field value with a string from within another formula field

Hello @Fred , hope you are well. I am facing a simple but silly issue and I am stuck at this point. Thought you might be able to help me out with this one.…

• Answered

Ninox failing to load on iPad

I have the latest version of Ninox on iPhone, iPad and Mac, all of which running the latest OS. MacBook and iPhone are fine, but iPad starts to load Ninox then hands with a blank white screen. IOS 15.…

freeze data in a field

Hi Folks, I'm sure this has been asked about before but none of the solutions are working for me. Simply put, I have a formula field that is calculating based on 2 number fields on separate tables.…

• Answered

rotate a formula date field

is there a way to rotate a formula field that has a month and year on the print form layout? this is the only thing that I haven't been able to work around.…

Sort the appointments in the calendar

Hello Everyone Is there a way to sort the appointments in the calendar? For example alphabet... Now they are coming completely random.

Passing null for a parameter of record type to custom functions

Hello Friends, I did a lot of finding on this and finally resolved it by chance (couldn't find anything in the forum or on internet) that in order to pass a null parameter (that is expected to be of…

Why is there no way to log-in to the Ninox Forum?

When I try to sign-in to the Ninox Forum with my username and password, it does not recognize me. (It always worked before.) Then when I click 'Forgot my password," and enter my email address,…

• Answered

change single items of an array

Hi, i would like to know how i change single items of an array. Let's say if have an array := [a,b,c] and i want to change item 2 [b] to f. The final array will look like [a,f,c].…