Need Help to create a History Control Table

I need a Control Table, where every time the FechaR3, FechaR4 and FechaR5 are met in the Documents Table, they are copied to the Control Table with the Document Name, the Code and all 3 Dates.…

• Answered

NinoxCloud, automatic data saving

Hi there, Does anyone know how this works ? Is it purely at random and set to work, say, five times per day or does it depend on the team activity regarding a particular database?…

Calendar for photographers

Ciao, I am a photographer and I mainly deal with weddings. I am very happy with Ninox to manage my entire business and am also recommending it to other colleagues who seem enthusiastic.…

date change

I am having the issue of the date being changed after I enter it. I am using the DATE field to pull up the calendar so I can select a date and after it is selected it gets changed to exactly 1 day…

Auto generated email

hi, I'm trying to automate the email report. Like my aim is to fill fields and then my email would be ready. Here my workflow : Fill fields > Generate email > Mailto from ninox I can generate well my…

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