Need transfer only the Approved.

I am using this table for the documents that will be incorporated into the main Documents table as scope changes, will not be included in the main table until the scope change is approved by the…

• Answered

Storage for small bar

Hello I need a simple initial database for a warehouse in a bar. please share if there is a finished version, no matter how perfect it is, I will finalize it. Thanks for your help

Subscription and payment ER example

Hello, I'm working on a database which required to handle subscription and payment to annual fee and events. Right now, I'm still design this senario in a ER chart. But, I've some doubts.…

Server error??

hey, we have a company server and nobody can seem to connect to Ninox today and today is a German holiday. is there anything at all that can be done???

Transfer all info on table to another table (script don't work)

let me := this; let myA := first(select 'wbs by Documents' where 'Name Document' like me.'Name Document'); if myA = null then if dialog(" Waiting Answer", " Document NOT found.…

• Answered

OpenURL opening multiple webpages.

Hello, I had a question regarding the OpenURL function. This is the code I am running and I think it should open 10 webpages, but it is only opening 1. What is wrong? for i in range(0,…

Remove comma from dmc-print layout

I have a dmc-field which filters the 'Name' field from the 'Employees' table. By inserting the dmc-field in the print layout, each "Name" field is divided by a comma.…

• Answered

Badges on TABS

@Jacques TUR and others. Using Ninext is it possible to add a badge to a TAB? In the screenshot below you can see I have a TAB to view the notes related to a particular Location.…

Button. On click - No empty fields and if there’s a dup confirm before adding record via dialog

I’m trying to make sure all the important fields are filled out when adding new record and if such record already exists to ask for confirmation before proceeding.…

Check box in list view?

Hi! I am currently trying to migrate from FileMaker to Ninox. I am still rather a beginner. In file maker I had check boxes in each row off the table in list view.…

Formula to Count item per Week

Hi I Need a Formula to count the amount of 'Rev A' per Week Example Week 15 - 3 Week 16 - 1

• Answered

count lines of text

Formula to count the lines of text in a text field? e.g. April is the cruellest month, breeding Lilacs out of the dead land, mixing Memory and desire, stirring Dull roots with spring rain. to yield 4

• Answered

convert formula to NINOX LANGUAGE

HOW CAN I GET THIS FUNCTION WORKING IN NINOX? I am trying to have a table that keeps the working hours for each day of the week, and a holiday table to store closed dates ,…

BULK Edit values with a button

I have the following Q: I have a table with yes/no field. So every record in that table has either yes or no. I sometimes need to reset all records to "no".…

Proper Syntax for counting any combination in a multiple choice field that includes at least one selection.

I have been trying all sorts of syntax along with using +, and, or to no avail. Here is my formula. let xStart := 'Start Date'; let xEnd := 'End Date'; count((select Chronos)['Date + Time' >= xStart…

Unable to Archive or Duplicate

When creating an archive on my ipad pro, iPadOS 16.4.1(a), ninox stalls and then shuts down. This also occurs when tying to duplicate. If I create a new,…

Sum of values of a field of a specific date

I'm looking (and can't find) a solution to calculate the grand total of a field of a given date... No problem illustrating this with a view, but that's no use to me since I need it as a value in a…

• Answered

SELECT function

Hello, which is the best way to identify records if the table as a below relation: Table A link to table B, and table B link to table C. I need to count records in table C based on a filter related…

Avoid deleting a record

Hi, I'm working on my first database, and I need your help about the record. What I want is avoiding accidental delete a record wherever I am. It means that,…

Creating a Record from a Button Sending an Email

Hi, I've set up buttons to send emails, but I need to keep a record of the emails sent. How can I get this same button to create a record in a new table for storing these emails?

Force trigger after update with mass update

I have a table called "Bancos" where I import a CSV file with the bank statement. As I wasn't sure on how to, once imported all records, create a new entry on a different table "Entradas/Salidas"…

• Answered

print view

I should be opening a view in a report, can anyone help me?

Variable in a text field

Is it possible to add a variable in a text field (multiline) then, to resume this text in a field of formula and that the variables are replaced by data of other fields? For example,…

• Answered

Incorrectly calculated Week

@Fred On Choice (Dynamic ) I use the formula let l := '1N_Control Issues'; l[let t := Week; first(l[Week = t]) = this] order by Week Copy And on the View I use the formula let s :…

• Answered

Problem with if and else in a loop

Hey, i got a problem with my code: do as server for i in select Leads do if i.Status = 2 then for j in select Kunden do if i.Nachname = j.Nachname then i.…