-
Relations between records in the same table
Hi, I have a table for Invoices, where the type of the invoice can be selected: Fee requester, Proforma invoice, Invoice, Modified invoice, Storno invoice.…
-
Show two tables in one view
Hi there - has any body tried to do this and how will it be done ? The case is that I have a table for purchases (Danish name "Indkøb") An a table for Sales (Danish "Salg"),…
-
Locked out of our private server !
We have a licence extension to 27th November but have been locked out of the system over the weekend - this is outrageous. The support team are unresponsive to emails - I suspect intentionally so.…
-
RoleGrabber – Tool DB for Cloud Developers
The following text was translated using a translation program. Please excuse this. Here I present a small tool database that is intended to support the documentation and development of cloud…
-
Table or Sub-Table?
Hi, I'm building a database for my company we do production and sales and I'm confused when to make a related table and when to make a sub-table. I understand when I make a table invoice - with…
-
Data Modelling
I know it was written a few years ago now, but this book has become my go-to for all things data modelling. The Data Model Resource Book, Vol. 1: A Library of Universal Data Models for All…
-
Field of type JSON
Hello Friends, As I make a database app for my own food business, I am in the process of designing the menu table. The menu items come in varied units like (piece, container, plate, meal etc.).…
-
Table architecture with a 3 levels or deeper hierarchy
Hello friends, By any chance is it possible to have a Table architecture with a 3 levels or deeper hierarchy in Ninox? Below is the current structure of my database and desitred structure (if…
-
Complex criteria for Select
Hi, I am working on a project which requires a dynamic choice field to be populated by the results of a select based on one or more of four criteria. The criteria are selected at the top of a…
- Answered
-
Query regarding the sale price per item in Sale Order
Hello friends, This query might sound very basic, but I have some doubts about it. I am starting to develop a small sale-order system for my own food business.…
- Answered
-
How to maintain rates in old transactions
@Sean@Fred@Sotirios Zormpas Hello friends, This query might sound very basic, but I have some doubts about it. I am starting to develop a small sale-order system for my own food business.…
-
Using SNAGIT for tutorials
Hi, I use SNAGIT and it occurred to me that it could be a useful way to create user video tutorials. SNAGIT allows one to create a video and then share it via various methods such as Screencast which…
-
A consequence of proper DB design...
As you know I've been updating my DB structure, which means I'm creating more records. Well, by creating more records mean that I am now over my 50,000 record limit of the starter level.…
-
Time to create more work for myself...
Never to leave a functional DB alone, I decide to correct some poor DB design. As you can see in the picture, I break the tenant of not creating multiple fields that store the same type of data.…
-
Help Needed: Error: Database Connection Failed on Ninox
Hi everyone, I have migrated my complete data from Salesforce and imported it successfully, yesterday it was working fine, but right now, I'm encountering an error while trying to connect to my Ninox…
-
POS System ( Sales,Income,Expenses,Stock,Supply)
Hello, I have been working on a POS System all created in Ninox, What I'm trying is that when the sale of 1 product happens (Sales Table) the product is deducted from the Stock table and money added…
-
Merge visible PDF in one file
I have a table named "Allegati". Inside it, there's a field called "File" which contains a PDF. In another table called "DOC FIERA", I have created a reference to "Allegati" in such a way that if a…
-
Script to update records in another table
So I for this scenario I have 2 tables. One is called DID the other is called E911. I have data in both tables. In both tables there is a piece of information that may be the same.…
-
Issue with trigger conditions in 'Liste' Field: Multiple Text conditions not triggering as expected
I have an issue with a trigger in the 'Liste' field. I would like to create multiple triggers in the 'Liste' field that check if certain text is contained within it.…
- Answered
-
Analysis of your database structure with Ninext
Here's a JavaScript code snippet for analyzing the contents of your database. This code can be run from the Ninox console when Ninext is installed : #{ let tables = Object.values(database.schema.…
-
how to duplicate a subtable using a button
Hi everybody, I've created a table (Offertes) which has one subtable (Offertelijnen). Using a button, I would like to duplicate the record in the parent table as well as all the records in the child.…
- Answered
-
The Ninox Learning Lab is offered most Thursdays at 12pm EDT/ 5pm BST/ 6pm GMT and is free.
The Ninox Learning Lab is offered most Thursdays at 12pm EDT/ 5pm BST/ 6pm GMT and is free. The Ninox Learning Lab has provided training and support to thousands of Ninox users all over the world…
-
Mac app upgrade to 3.11.8 failure !!
after upgrading the Mac application, when starting the application, the system issues the attached alert.... could anyone help me ??
-
Charging for use of application.
Hi guys, I am after some advice. I built an application for my own use in the Audio Visual industry. Essentially it is a installation management tool (quasi Project Management) and also keeps track…