table numbers

Hello I have a reference to a table (1 : N) where all the relevant records are displayed. It would be very convenient if we were able to see the number of the array.…

Select multiple value in linked table

Hello, i have a table with car models I sell and a table with cars components. I have table with replacement parts that fit more than one model of car. In the repair table I wanted to display only…

The number of days in each month of the day period and its total

Suppose I want to know how to calculate the number of days in each month and their totals during the period from 8/1 to 9/10 Thank you

Retrieve API Key programmatically?

Hello, Is there any way to retrieve the right API key programmatically? Background: We want to use our project management system for multiple clients. It is composed of several external tools…

Seems basic math and date function are bugged

Hello I am evaluting Ninox in a trial database and need to follow projects Tasks. I am trying to to update a Task Table with a calculation of End Date as Start Date + Workdate (5 days a week).…

is there a formula to disconnect the link field to a table ?

i would like to disconnect the field linked to the table with a formula. I am trying to disconnect the field when i update another link field. I hope i've been clear. thanks in advance for your help.

Parent / Child / Grandchild

Hello there. I'm a new user and am struggling with the Parent / Child / Grandchild relationships. I have the set-up the following relationships as shown in the picture:…

• Answered

Filtering by first record

Hi All, I would appreciate some help with filtering a table view. How can the lines for only the first record of each customer be shown? thanks

Carriage Return and Line Feed (CRLF)

Hi there, In Ninox, I want to create a text file for an import into a 3rd party solution. The 3rd party solution requires line breaks to be formatted as carriage return + line feed ("CRLF").…

• Answered

Upload file to Ninox via API

Hi there, I want to upload a file to Ninox via MAKE / Integromat using the 'Make an API Call' module. Unfortunately, I do not really understand the API documentation.…

Dynamic Choice as table list/View column

let's say I have a column 'Quantity' in a table/View. I then add/Show a formula column calculated as:- if Quantity = 1 then "one" else "other" end In this case,…

How to get a formulae field to show the result of a Dropdown box instead of a number

Ive got a table of staff names table of scheduling & a table to show the daily allocation of staff. table 1: The table of staff names is just so when new staff join and old staff leave,…

Include links in PDF

Is there any way of including links in a PDF exported from Ninox without the line breaks destroying the link? I have tried scripting it several ways, but with no success.

Filtering data based on manual dates entered.

Ok, another question here. I feel I am in the ball park. I am trying to sort my data based on when clients were terminated. However, those dates I want to use can always change based on what…

• Answered

Dynamic Choice from Dynamic Multi Choice

I have a Multi Choice Dynamic field with which multiple choices can be selected (obviously). I then want to have a Dynamic Choice field, based on that same table but that includes ONLY those choices…

Change location of saved PDF's

Hi there, is it possible yet to change the location of where PDFs are saved when using the printAndSaveRecord function? Being able to do this would seriously cut down on clicks! Many thanks

Date suddenly wrong

Dear all, One of our users is suddenly seeing all the dates logged in the database backdated of one day. For example we have a date of 31/12/2021, he sees 30/12/2021.…

New record code needing a tweak

closeRecord(); let thisRecord := this; let myProject := 'SELECT PROJECT'; let myLoc := 'SELECT BUILDING, ROOM & DESCRIPTION'; let newRec := (create 'Project Equipment'); newRec.…

Text value from dynamic choice field

How do i extract the text value from dynamic choice field? text(field_name) is not working

Dimensione del modulo

Ciao a tutti, ho bisogno di un aiuto per aprire un modulo con le dimensioni da me scelte. Vorrei aprire il modulo al centro della pagina. Grazie per un eventuale aiuto

New result line in the console

How do I write a new result line in the console? This is the code I run let LastDate := last((select Notify) order by Data).Data; text(LastDate); while today() > LastDate do LastDate := LastDate +1;…

Normalising existing data

I've imported a spreadsheet to a table and now want to normalise it. In SQL I would have done a 'select distinct' on a given field to generate the list of values,…