Optimize Formula

switch Medicion do case 1: (select DOCUMENTOS where 'Ganado REAL' = 10) case 2: (select DOCUMENTOS where 'Ganado REAL' = 50) case 3: (select DOCUMENTOS where 'Ganado REAL' = 80) case 4:…

• Answered

Alert function - trigger after update - cloud version

Hello, i would like an alert after trigger after update. On ipad/iphone this function works ok. On cloud version this doesnt work, when i use the same script with button everything works perfectly.

• Answered

MultiLine Text field with multiple rows alongside in form

Hi, I'm not sure if this has been asked before, but could not find it when searching. Apologies if it has been posted. I am looking at Ninox to migrate date from another database platform,…

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