-
Is there a way to automatically create multiple records from a button?
I have a database I use to maintain a small budget for a coffee club (32 menmbers). I have a members table, income table and an expense table with a invoice subtable.…
-
Link records in 2 tables
Hi, I have two tables: Table 1 is called "Checks" and table 2 is called "Customers".The relationship between the two tables is N to 1. The two tables share a field called "codclt".…
-
Limit number of records in a subtable
Hi, I have a table Suscripciones and a subtable ´Planes Suscritos´. What would be the way to limit that the user can create only one record in ´Planes Suscritos´? Thanks. Jaime
-
Technical Help/Create new record in child table
Hello all. Newbie question- How can I trigger a new record creation from a parent table in a child table. i.e: I create a record in the parent table and it automatically creates a new record in the…
-
Location of data file?
Where is the database data file located locally (I'm quite sure it is stored locally)? Also, how can I tell if it is located locally or if its stored in iCloud
-
what is the formula to obtain the standard deviation ?
Hello, I'm trying to find the standard deviation of a serie but don't know the formula. Some help ? thank you
-
Constraint formula to prevent double
I have a table (Station) and a composit table (station composition). I also have another table (products). Inside Station table is some station name and inside station composition,…
-
General Knowledge question about Databse structure and Logic
As you all know, I am completely new to this wonderful program. First, is there anyplace you know of where I can get a general overview of how to go about data modeling and the logic behind designing…
-
I have a table in a database that is hidden, how do I un-hide it?
I have a table in a database that is hidden, how do I un-hide it? I don't even know how it got hidden. I've searched the manual to no avial. Thanks in advance! Marek
-
Have SQL Command That I Am Trying Run with Ninox
I have a table named DOTList and I want to run this SQL script but it's not working UPDATE DOTList SET DBA_NAME = LEGAL_NAME WHERE DBA_NAME = '' I get this error message: Field not found:…
-
Ciao
Salve, vorrei sapere come nascondere un valore in un campo di un report se tale valore è <= di 0, grazie mille!
-
Adding colour to records
Dear forum I have set up a table and everything is functioning just perfect, only, I would like to mark some of the records in colours according to their content.…
-
Update Multiple Records (assign calculated value ) vs Formula Trigger on create
Please, help. 1. When Using formulas like this in Field for Trigger on create Field, perfect. 'Invoice No' := "ArtNr.-" + format(cnt(select Rechnungen), "0000") 2.…
-
All Records Suddenly Disappeared
I have Ninox Database Premium Version 2.6.7, and I am running it on macOS 10.15.3 (Catalina). Today I was editing a database that I have been working on for years.…
-
Is there a way to get a checkbox to look and act like a checkbox in the TABLE view?
I just want to check off the item that was done without having to go to the attached form. Apple Reminders is an example of how this works.
-
Ninox Version 2.6.7
Is there anywhere i can look at the new patch notes for the new update? but in a better explanation?
-
Delete key
Hello, I propose a small improvement because the problem mentioned has happened to me several times.On the editing page, it would be wise to shift the basket from the "+" key,…
-
Lookup Tables
How do I create and then access a lookup table to select predefined records to import into another table? i.e. select standard products for purchase?
-
Import error while using the trial version
Dear forum I am testing Ninox as an archiving database for a project I am working on, but I am having problems importing a .csv file. While the initial overview over the imported data is shown,…
-
Quotes automatically inserted around text fields when copying and pasting
Hi, I have a table with a multiline text field. When I copy that field for multiple records (highlight the field across multiple records and press ctl c) and paste (ctl v) that field into a document,…
-
Ninox Beta Team
Does anyone know if the Beta Team database is still being used? As far as I can tell, no one has touched it for months. There are some key features that I really want to see implemented and I'm not…
-
I can't find the printer icon.
Good day,I'm discovering Ninox and I'm very enthusiastic about it.I have created a small base and I would like to print it as a pdf. Unfortunately I can't find the printer icon. Can you help me.…
-
Mac application freezes
The mac application 2.6.7 freezes at start up. I am on mac os 10.13.6. A solution?
-
Great experience
Great experience with Ninox
-
views populated with an array
In the form editor, I can add a view of a database with « Select data » query as a source. Is there a way to build an array structure from scratch, to be also able to give that array as the source of…