sum up the amount of expenses

There is a table projects and it contains a sub-table with the expenses name There is also a dynamic selection field that displays the name of the expense.…

How to rearrange fields in a form

Dynamic Reports - Data from Different tables

Another question: Is it possible to call data from two different unrelated tables to fill the report? Like this: let xFilter := record(Reports,1).Filter; let x :…

CreateXLSX not working

I can't get the CreateXLSX function to work, at all - on Ninox v3.17.13 (Mac OS Tahoe).. I tried with field names, and couldn't get it to work, so tried static hard coded data - in fact,…

Menus Larger

How can I make these menus larger so that the words are clear?

Line numbering in the Formula script editor not showing in the App.

Hi, Both the Apple and Android apps don’t show line numbering in the formula editor, is there a way to enable it or is line numbering not a feature in the App?…

• Answered

Formula Fields Not Returning via API

Hi everyone, I’m trying to fetch records from a Ninox table using the REST API, but the formula fields are not being returned in the response. Does anyone know the correct way to retrieve formula…

Print from Page NOT Table

Is there any way to access a dynamic print layout and save to file on the Page? This is available on the table view. Any ideas please?

• Answered

Problem accessing a subtable from a reference record

I have a Dynamic Choice field called “Employees”. In the same table, I also have two numeric fields: “USD” and “ZMW”. I want to create a button that, when clicked,…

• Answered

loop thru entire Table to enter a Value

Hello i need just a simple Countup thru complete Table. In Table "UNITS" the Field "Zahl" shuold be countet up by pressing a Button: with this it count only up in Row 1....…

Download files via API with umlauts in file name

Hi, I'm trying to download files via API and am having trouble with files that have umlauts in the file name. I cannot find a way to encode the file name so that it works.…

API request limit

Hi there. Want to know if there is API requests limit?

Seelect where Calculation from 2 entries

Hello i ned the difference from 2 entries in a table (Hour meter) the last of the entry i get: let myreg := Registration; last((select 'Flt Hrs' where Luftfahrzeuge.…

• Answered

Assistance with producing graphs

Hi All I use Ninox as an asset collection tool. So my databases can be 200 lines or 5000 lines. Part of the data I collect is the condition score - Red - Amber - Green And I also put a budget to each…

Sending email to multiple CCs

I need emails sent to multiple people but they are only being sent to one person in the CC list. Here's my code, the email sends to the 'To:' person and the last person in the CC list (i.e.…

• Answered

Filtering a formula column results in empty display

I have a table with a "Assigned To" field of type User. I would like to filter my view to show records for the current user only. I created a new formula field in my view called AssignedToCurrentUser.…

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