Hours result from appointment field

I have an appointmenet field which has started giving weird results in a formula providing hours worked. This is the formula: duration(appointment(datetime('DAY END'),…

Field alignment logic

What is the logic behind "bottom field alignment"? Have experimented with spaces etc. - no luck so far - is there a way to "top-align" fields? J:)

Gruppierungen in einer Tabelle berechnen

Hallo zusammen, ich habe in der Tabelle Rechnungen eine Ansicht erstellt die mit "yearmonth"(Datum) die Monatsumsätze (Nettobeträge) gruppiert. d.h. 2022/7 ; 08/2022 usw. angezeigt.…

Button to save a pdf when multiple print layouts are available

Hello, i have a form and multiple print layouts (that's because from the same data in the form, I need to have many different papers created). 1. Is there a way to add different buttons the form (one…

Can't see records, while they can be searched and found...

This seems like a basic problem, but I am not to able to solve it. I have a database of wines I have in the cellar, and I retire them by the bottle. So when all bottles of a certain wine have been…

• Answered

Find weekends dates

Is there some code to detect weekends in a list of Dates. Now I have a list of 2500 dates records and I need to know which ones are weekends. Thanks

• Answered

Add existing records to table automatically

Hello all, I have a populated table called 'Glossary' that I would like to bring into another table called 'Inspection Report' using View. At the moment,…

Print a 'View' page element

Hi, I need to include a selection of images from a subtable in a print layout.. I can do that, but I need to use the 'unique' function, as some of the images are repeated but I need to only show each…

But After Update ?

Is Thérèse a bug. Ninox dosen’t run ?

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…